Outline

1
???????(?)
2
Outline

• ??Mysql 5.0?
• MySQL????
• MySQL????

3
1. ??Mysql 5.0?
??Mysql 5.0?
4
2. MySQL???? (1/5)
5
2. MySQL???? (2/5)
6
2. MySQL???? (3/5)
7
2. MySQL???? (4/5)
8
2. MySQL???? (5/5)
9
3. MySQL???? (1/15)
??MySQL??
10
3. MySQL???? (2/15)
??root??
11
3. MySQL???? (3/15)

• Setup a new database
• SQLgt create database database02

12
3. MySQL???? (4/15)

• Open the database
• SQLgt use database02

13
3. MySQL???? (5/15)

• Create a table
• SQLgt create table table01 (field01 integer,
  field02 char(10))

14
3. MySQL???? (6/15)

• List the tables
• SQLgt show tables

15
3. MySQL???? (7/15)

• List the fields in a table
• SQLgt show columns from table01

16
3. MySQL???? (8/15)

• Insert a record
• SQLgt insert into table01 (field01, field02)
  values (1, las')

17
3. MySQL???? (9/15)

• List all the records
• select from table01

18
3. MySQL???? (10/15)

• Adding fields

SQLgt alter table table01 add column field03
char(20) SQLgt alter table table01 add column
field04 date, add column field05 time
SQLgt Select from table01
19
3. MySQL???? (11/15)

• Insert records into the table
• SQLgt insert into table01
• (field01,field02,field03,field04,field0
  5) values (2, eddy', 1983-1-1',
  2007-03-15', '160000')

20
3. MySQL???? (12/15)
SQLgt select from table01
21
3. MySQL???? (13/15)

• Updating existing records
• SQLgt update table01 set field031984-2-2' where
  field011

22
3. MySQL???? (14/15)

• Deleting records
• SQLgt delete from table01 where field012

23
3. MySQL???? (15/15)

• Quit
• quit