macdiggs.com

Well it was fun for the first time, it was OK for 10th.. But after first hundred times it seems to become clear enough that I need some patch applied to my poor brain ;)

Here's how you try (unsuccessfully) to get a list of tables in a database ;)

[meito@www meito]$ mysql -u root -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7003 to server version: 3.23.58

Type 'help;' or '\h' for help. Type '\c' to clear the buffer.

mysql> use main
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

Database changed
mysql> ls
->
-> ;
ERROR 1064: You have an error in your SQL syntax near 'ls' at line 1

This entry was posted on Friday, June 16th, 2006 at 2:23 pm and is filed under Misc blog, SQL, Servers. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.