Wednesday May 14, 2008

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;

 

>
< [?] >
These icons link to social bookmarking sites where readers can share and discover new web pages.
  • Digg
  • Reddit
  • Technorati
  • del.icio.us
  • Slashdot
  • StumbleUpon

Related Posts:

1 comment for MySQL commands (for SSH/command line use) »

  1. 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

Leave a comment

RSS feed for comments on this post. TrackBack URI