mysqlshowtables.pptVIP

How to Use MySQL CS430 March 18, 2003 MySQL, the most popular Open Source SQL database, is developed, distributed and supported by MySQL AB. MySQL is a relational database management system. MySQL software is Open Source. Written in C and C++. Tested with a broad range of different compilers. Works on many different platforms. APIs for C, C++, Eiffel, Java, Perl, PHP, Python, Ruby, and Tcl. You can find MySQl manual and documentation at: /documentation/ Basic Query: select A1, A2,…,An from r1, r2, …,rm where P; A1, A2,…,An represent attributes r1, r2, …rm represent relations P represents predicate (guard condition) Keywords may be entered in any letter case: mysql SELECT VERSION(), CURRENT_DATE; mysql select version(), current_date; mysql SeLeCt vErSiOn(), current_DATE; Basic Database Operation Create a database Create a table Load data into the table Retrieve data from the table in various ways Use multiple tables Suppose you have several pets in your home (your menagerie) and youd like to keep track of various types of information about them. You can do so by creating tables to hold your data and loading them with the desired information. Then you can answer different sorts of questions about your animals by retrieving data from the tables. Retrieving Information from a Table The SELECT statement is used to pull information from a table. The general form of the statement is: SELECT what_to_select FROM which_table WHERE conditions_to_satisfy The simplest form of SELECT retrieves everything from a table: mysql SELECT * FROM pet; You can select only particular rows from your table. mysql SELECT * FROM pet WHERE name = Bowser; You can specify conditions on any column, not just name. For example, if you want to know which animals were born after 1998, test the birth column: mysql SELECT * FROM pet WHERE birth = 1998-1-1; You can combine conditions, for example, to locate female dogs: mysql SELECT * FROM pet WHERE species = dog AND s