create database test; use test; create table mytable(id int, name varchar(30), constraint pk_mytbl_id primary key (id));