MySQL, database, tables, column, select, delete, record MySQL - Tech-Recipes

MySQL tutorials

MySQL: How to get row number order

contributed by Vishwanath Dalvi on October 1, 2011 under Database, MySQL

These directions walk through how one can displaying the row number order/rank for result set obtained from executing a sql query. An example with walkthrough explanation is provided.

Import CSV file directly into MySQL

contributed by katy8439 on May 8, 2007 under MySQL

Instead of writing a script to pull in information from a CSV file, you can link MYSQL directly to it and upload the information using the following SQL syntax.

MySQL: Increment an exisitng value

contributed by qmchenry on February 24, 2007 under MySQL

This slick MySQL syntax allows you to increment or decrement an existing number in a table without first having to read the value. This is a nice way to increment an access counter.

MySQL: Use CONCAT to include text in SELECT results

contributed by qmchenry on January 31, 2007 under MySQL

The CONCAT function in MySQL allows SELECT statements to act like printf commands by mingling text and query results together.

Copy an existing MySQL table to a new table

contributed by qmchenry on July 4, 2006 under MySQL

This is a great set of two commands that allow the creation and population of a new table with the structure and data of an existing table. This provides a quick means of making a point-in-time copy of a table and is a safe, easy way to make a quick copy of a table for testing an application in development on live data without risking a production environment.

Rename or change name of MySQL table

contributed by qmchenry on under MySQL

If you change your mind and want to rename an existing MySQL table, with or without data in it, it is no problem. One simple command will change the table’s name.

Ignore duplicate entries in MySQL select using DISTINCT keyword

contributed by qmchenry on July 3, 2006 under MySQL

Sometimes every occurance of a value which may be duplicated multiple times in a result set is not needed. For example, if making a pulldown menu list of options, each option should be seen only once. The DISTINCT keyword in a select statement eliminates duplication in the result set.

Save MySQL query results into a text or CSV file

contributed by qmchenry on June 28, 2006 under MySQL

MySQL provides an easy mechanism for writing the results of a select statement into a text file on the server. Using extended options of the INTO OUTFILE nomenclature, it is possible to create a comma separated value (CSV) which can be imported into a spreadsheet application such as OpenOffice or Excel or any other applciation which accepts data in CSV format.