MySQL, database, tables, column, select, delete, record MySQL - Page 3 | Tech-Recipes

MySQL tutorials

Create a basic MySQL table

Contributed by qmchenry on February 8, 2004 under MySQL

Creating tables in databases is an important first step to storing data. The CREATE TABLE statement is rich and sometimes confusing. This recipe describes the basics of creating a table in MySQL.

Drop or delete a table in MySQL

Contributed by qmchenry on December 14, 2003 under MySQL

Describe the column structure of a MySQL table

Contributed by qmchenry on under MySQL

The SQL command ‘describe’ allows you to view the column structure of a MySQL table. It provides a listing of the columns of a table, the type of each column, and additional information on each column.

Select a MySQL database to use

Contributed by qmchenry on under MySQL

A single instance of MySQL can hold many separate databases. It is important to specify the database to which subsequent commands will be issued.

Display a list of databases on a MySQL server

Contributed by qmchenry on under MySQL

Create a MySQL database

Contributed by qmchenry on under MySQL

Determine the version of MySQL server

Contributed by qmchenry on under MySQL

Connect to a MySQL server using the mysql command

Contributed by qmchenry on under MySQL

The mysql command provides a text-based interface into the MySQL database server. Once connected, SQL commands can be issued to the server to make queries, create or alter databases or tables, or many other operations.

—