SQL Introduction What is sql. Learn the common language on how to construct Structured Query language  Data from Access To MySQL You can transport /convert access or excel data to MySQL database using myodbc. Read details  Select Query to display records We can control the data by using sql where command. The display order can be managed by using order by query. We can restrict the number of records to be displayed by using limit command. We can use SQL IN along with logical combination with OR AND to get required result from the tables  SQL Linking Tables More than one table can be linked to each other by using sql left join,  sql union.  Handling records in Tables by groups We can collect distinct data from fields by using distinct sql. We can get the records between two ranges by using sql between. Get similar data with matching patern by using sql like. You can collect random records each time by using rand() query and by using this with sql limit query you can generate one random record on every request.  MySQL commands and functions We can find out the number of records affected by any query by using mysql_affected_rows() function. Mysql_insert_id() will tell us the value of auto increment field after an insert query. We can display error message in case of an error generated by mysql query by using mysql_error(). To display the error number we can use mysql_errno(). We can post the message and error number in case of an error to an email address. Get the total number of records in a table by using mysql_num_rows() function.

SQL to Rename Tables Table field name can be changed using alter command. We can creaete a new table with same data or we can copy the structure of the table by using copy table command.  Data updation by update query Data can be deleted or inserted to a table by using query  Number of records counting query SQL group by command is used to findout the SUM, Average, Maximum value, Minimum value of data in a table.

Discuss this tutorial at forum List of SQL Tutorials