We learn MySQL CREATE and DROP. “You ask, why bother when I can point and click?” Because you might have to do SQL on a server with no GUI, Create an install script, a program SQL update script, etc. So It’s important! So, we finally jump into the SQL Syntax. It’s a bit strange if [...]
Archive for the ‘MYSQL’ Category
(3) Learn MySQL CREATE and DROP
Posted: 11th January 2011 by admin in MYSQLTags: Create, Drop, Learn, MYSQL
2
(11) MySQL Sub Query Tutorial
Posted: 7th January 2011 by admin in MYSQLTags: MYSQL, query, Tutorial
This ones tricky guys! We are going to create a Query within a Query. Please take your time to see the code and think about what is happening so you understand. The SELECT statement in the SUB QUERY compares it to the MAIN QUERY’s WHERE statement. Confused? Study the code a few times! jream.com
The MySQL Console is good to get comfortable in, it’s the same thing we were doing with Heidi SQL, except it’s not as fun to type in and it’s easy to typo’s that you have to redo everything with. I’m showing you so that you know it’s available to you, I never use it, but [...]