17 lines
481 B
Plaintext
17 lines
481 B
Plaintext
# drop existing table. If it doesn't exist, msql will basically ignore
|
|
# this.
|
|
drop table tools
|
|
\g
|
|
|
|
# Create a new table in the database
|
|
create table tools (
|
|
tooltype int not null, # 0: hand tool; 1: power tool
|
|
toolname char(255) not null # name of the tool
|
|
)
|
|
\p\g
|
|
|
|
# Insert a few entries into the table
|
|
insert into tools values (0, "hammer") \g
|
|
insert into tools values (0, "screwdriver") \g
|
|
insert into tools values (1, "table saw") \g
|