Mysql Tutorial

A brief MySQL tutorial CSE 134A: Web Service origination 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 set back 3) After we have created the database we engross the USE statement to variety show the current database; mysql> USE 134a; Database changed 4) Creating a table in the database is achieved with the nominate table statement mysql> CREATE TABLE chairwoman ( -> -> -> -> -> -> -> ); dubiousness OK, 0 rows affected (0.00 sec) last_name varchar(15) non zilch, 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 are present in the database use the aim tables: mysql> SHOW t ables; +----------------+ | Tables_in_134a | +----------------+ | president | +----------------+ 1 row in decide (0.

00 sec) 6) The command draw and quarter can be used to involve the structure of a table mysql> DESCRIBE president; +------------+-------------+------+-----+------------+-------+---------------------------------+ | Field | fictitious character reference | Null | Key | Default | Extra | Privileges | +------------+-------------+------+-----+------------+-------+---------------------------------+ | last_name | varchar(15) | | | | | | | | | | | | | | | | select,insert,update,references | | select,inse rt,update,references | | select,insert,updat! e,references | | select,insert,update,references | | select,insert,update,references | | select,insert,update,references | | first_name | varchar(15) | | state | metropolis | 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: OrderCustomPaper.com

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