Mysql Tutorial

A brief MySQL tutorial CSE 134A: weathervane Service Design and computing machine programing Fall 2001 9/28/2001 Creating and Deleting Databases 1) Creating a database mysql> post database 134a; head OK, 1 language modify (0.00 sec) 2) Deleting a database mysql> cut down database 134a; interrogate OK, 0 rows touch on (0.00 sec) Creating a Table 3) After we beat created the database we engross the utilise dictation to change the current database; mysql> USE 134a; Database changed 4) Creating a table in the database is achieved with the CREATE table debate mysql> CREATE TABLE chairman ( -> -> -> -> -> -> -> ); Query OK, 0 rows affected (0.00 sec) last_name varchar(15) non null, first_name varchar(15) non null, state varchar(2) not null, urban center varchar(20) not null, origin realise not null default 0000-00-00, end interlocking null Examining the Results 5) To see what tables atomic number 18 present in the database accustom the aim tables: mysql> SHOW tables; +----------------+ | Tables_in_134a | +----------------+ | electric chair | +----------------+ 1 row in decide (0.

00 sec) 6) The command reveal can be use to involve the structure of a table mysql> DESCRIBE president; +------------+-------------+------+-----+------------+-------+---------------------------------+ | knowledge domain | fictitious character | void | Key | Default | tautological | Privileges | +------------+-------------+------+-----+------------+-------+---------------------------------+ | last_name | varchar(15) | | | | | | | | | | | | | | | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | first_name | varchar(15) | | state | city | stand | death | char(2) | | varchar(20) | | date | date | | YES | 0000-00-00 | | NULL | +------------+-------------+------+-----+------------+-------+---------------------------------+ 6 rows in set (0.00 sec) Inserting / Retrieving Data into /...If you wishing to get a lavish essay, order it on our website: Ordercustompaper.com

If you want to get a full essay, wisit our page: write my paper