create table addressbook (fname varchar(255) null,-- first name,255设置最大长度255个字符
lname varchar(255) null,-- last name
phone varchar(255) null,
fax varchar(255) null,
email varchar(255) null);
drop table addressbook;
describe addressbook;
-- 插入数据
insert into addressbook(fname,lname,phone,fax,email)
values ('lames','Boss','123','234','23@jikexueyuan');-- 建议写列名
insert into addressbook(fname,lname)
values ('Jake','Mike'); -- 建议写列名
insert into addressbook values ('Jam','Bob','123','234','23@jikexueyuan');-- 不带列名的情况
insert into addressbook values ('Jam','Bob'); -- 不带列名的错误示范
insert into addressbook(fname,lname,phone,fax,email)
values ('lames','Boss','123','234','23@jikexueyuan'),
('Jam','Bob','123','234','23@jikexueyuan');-- 可同时插入
insert into addressbook set fname = 'jck';-- 用set插入方式
select * from addressbook;
lname varchar(255) null,-- last name
phone varchar(255) null,
fax varchar(255) null,
email varchar(255) null);
drop table addressbook;
describe addressbook;
-- 插入数据
insert into addressbook(fname,lname,phone,fax,email)
values ('lames','Boss','123','234','23@jikexueyuan');-- 建议写列名
insert into addressbook(fname,lname)
values ('Jake','Mike'); -- 建议写列名
insert into addressbook values ('Jam','Bob','123','234','23@jikexueyuan');-- 不带列名的情况
insert into addressbook values ('Jam','Bob'); -- 不带列名的错误示范
insert into addressbook(fname,lname,phone,fax,email)
values ('lames','Boss','123','234','23@jikexueyuan'),
('Jam','Bob','123','234','23@jikexueyuan');-- 可同时插入
insert into addressbook set fname = 'jck';-- 用set插入方式
select * from addressbook;