• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Part VII: Appendixes > Getting Around in MySQL

Getting Around in MySQL

As long as you never have to edit a database, you don’t have to know much more about working in MySQL than what has already been covered in this appendix. However, you might find it handy to know at least the basics of working with databases in the MySQL client program.

MySQL works in the command-line interface. You type in SQL commands to edit the database. (This is actually a great way to learn how to write SQL statements.) After you’ve got the client program launched in your Command Prompt or Terminal window, and the mysql> prompt is showing, you can use some basic commands to examine and edit your database. Table C.1 shows some of these basic commands you can use to examine and edit your database. (The sample code shows the Antiques database being used.)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint