my sql

Creating a table
mysql> create table guests (autoID,int unsigned,auto_increment)
mysql> insert into guests VALUES (NULL, 'ádam','pop',46) same order as the fields created.
date is typed as "1990-03-05" year,month,day
to delete a table
mysql> drop table {table_nm};
to display the table:-
mysql> select * from guests;
mysql> update guests SET last_name="xyz123" WHERE autoID=1;

MYSQL ADMIN tasks

monitoring status of database server, uptime etc

mysql>status;

Show the databases mounted:-

mysql>show databases;

Create a database

mysql>create database {name};

use a database i.e., use the databse to create tables in it:-

mysql> use {database_name};

Delete a database:-

mysql> drop database {database_name};

Show tables in a database:-

mysql>show tables;

Show the fields in a table:-

mysql> describe {table_name};