Mysql Tutorial

A brief MySQL tutorial CSE 134A: Web Service endeavor and computer programing Fall 2001 9/28/2001 Creating and Deleting Databases 1) Creating a database mysql> hold database 134a; head OK, 1 row affected (0.00 sec) 2) Deleting a database mysql> DROP database 134a; interrogate OK, 0 rows affected (0.00 sec) Creating a add-in 3) After we have created the database we engross the USE statement to diversity the current database; mysql> USE 134a; Database changed 4) Creating a table in the database is achieved with the induce table statement mysql> CREATE TABLE chair ( -> -> -> -> -> -> -> ); interrogation OK, 0 rows affected (0.00 sec) last_name varchar(15) non unimportant, first_name varchar(15) not null, state varchar(2) not null, urban center varchar(20) not null, origin realise not null default 0000-00-00, death date null Examining the Results 5) To see what tables atomic number 18 present in the database use the aim tables: mysql> SHOW tables; +----------------+ | Tables_in_134a | +----------------+ | president | +----------------+ 1 row in decide (0.

00 sec) 6) The command hear can be used to involve the structure of a table mysql> DESCRIBE president; +------------+-------------+------+-----+------------+-------+---------------------------------+ | Field | fictitious computer address | Null | Key | Default | Extra | Privileges | +------------+-------------+------+-----+------------+-------+---------------------------------+ | last_name | varchar(15) | | | | | | | | | | | | | | | | select,insert,update,references | | select,ins ert,update,references | | select,insert,upda! te,references | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | first_name | varchar(15) | | state | city | birth | 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 want to get a full essay, order it on our website: BestEssayCheap.com

If you want to get a full essay, visit our page: cheap essay