MySQL commands (for SSH/command line use)
<
I hate looking this stuff up and I don’t do it enough to remember so here goes:
- Logging in: mysql -u <username> -p
- list or show all databases: show databases;
- open or start using database: use <database name>;
- list or show all tables: show tables;
Â
><
[?]
>
Related Posts:







I use lazy way do this with phpmyadmin but ssh and commands is the best approach if you want to be sure about what happen with your blog
Comment by Instant Messanger — May 26, 2008 @ 5:17 am