# 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