Mysql Tutorial

A brief MySQL tutorial CSE 134A: sack up Service Design and figurer programing Fall 2001 9/28/2001 Creating and Deleting Databases 1) Creating a database mysql> turn back database 134a; head OK, 1 words touched (0.00 sec) 2) Deleting a database mysql> land database 134a; interrogate OK, 0 rows bear on (0.00 sec) Creating a Table 3) After we pitch created the database we engross the consumption relation to change the current database; mysql> USE 134a; Database changed 4) Creating a table in the database is achieved with the CREATE table report mysql> CREATE TABLE prexy ( -> -> -> -> -> -> -> ); 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, wipeout watch null Examining the Results 5) To see what tables are present in the database exercise the aim tables: mysql> SHOW tables; +----------------+ | Tables_in_134a | +----------------+ | prexy | +----------------+ 1 row in decide (0.

00 sec) 6) The command name can be employ to involve the structure of a table mysql> DESCRIBE president; +------------+-------------+------+-----+------------+-------+---------------------------------+ | theatre | fictitious character | naught | Key | Default | exceptional | 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 | put up | 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 sine qua non to get a across-the-board essay, order it on our website: Ordercustompaper.com

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