Intelligentedu
Best New Free Computer IT Training Tutorial Resources


August 17, 2009

61 MySQL References and Code Examples

Here are 61 nice MySQL References and Code Examples, at psoug.org. These will help you to learn how to code SQL with the most popular open source database server, MySQL, which is one of the best RDBMS being used for developing web based software applications. By using these references and code examples you will increase your mySQL skills, and can become a better MySQL user or DBA. 


61 MySQL References and Coding Examples:
 
 - A minus B query
 - Add new user
 - Add or Subtract days
 - Add random numbers to columns
 - Add string to field
 - Almost any date to Mysql date
 - Binary RegExp select example
 - Calculate TIMEDIFF with mysql version < 4.1
 - CaSe sEnsiTvE query
 - Change table type
 - Check for duplicates & delete duplicates from database
 - Column copy with string replacement
 - Copy one table to another
 - Counting rows
 - Create monthly partitions
 - Create Random Password
 - Detect Daylight Saving Time
 - Export table to pipe delimited file
 - Extract part of a string
 - Fake Union
 - Fast random row picker #1
 - Fast random row picker #2
 - Find all duplicates in a column
 - Find Duplicates
 - Find Worst Performing Indexes
 - Finding a substring in a string
 - Follow the progress of a mySQL command
 - Format numbers to two decimal places
 - Get HTML/XML output from queries.
 - Get MySQL Database Size
 - Get ordered list of near match items based on tag matches
 - Grouping rows by frequency
 - Import file
 - Lead-In Sentence fragment...
 - Make comma-separated list of strings
 - Move position of mySQL field
 - MySQL Capitalize
 - mySQL DUMP command
 - MYSQL Select time from a date
 - Opposite of mysql_fetch_assoc
 - Opposite of UNION
 - Password setup
 - Rebuild table indexes
 - REGEXP SELECT Example
 - Remove Duplicates
 - Replace a NULL with a given value.
 - Reset auto increment value
 - Return text between delimiters in MySQL
 - Search and Replace
 - Select based on a field that can have a NULL value
 - Select distinct/unique entries
 - SELECT from multiple tables.
 - Select maximum value
 - Select minimum value
 - Select or match a range of dates
 - Select row number in MySQL
 - SELECT within SELECT (SubSelect)
 - Sort comma separated string
 - Update and Subtract single query
 - Update/convert DB field to uppercase
 - url_decode that respects utf8 characters.  



Tags for this post>> |


Filed under: Best New Free Computer IT Training Tutorial Resources — computer_teacher @ 11:29 am


Powered by WordPress