mysql查询s开头的数据_数据库之基本查询示例（一）

1、创建所需表及插入数据

#创建数据表

mysql> create table fruits ( f_id char(10) not null, s_id int not null, f_name char(255) not null, f_price decimal(8,2) not null, primary key(f_id) );

#插入数据

mysql> insert into fruits(f_id,s_id,f_name,f_price)

-> values(‘a1‘,101,‘apple‘,‘5.2‘),

-> (‘b1‘,101,‘blackberry‘,‘10.2‘),

-> (‘bs1‘,102,‘orange‘,‘11.2‘),

-> (‘bs2‘,105,‘melon‘,‘8.2‘),

-> (‘t1‘,102,‘banana‘,‘10.3‘),

-> (‘t2‘,102,‘grape‘,‘5.3‘),

-> (‘o2‘,103,‘coconut‘,‘9.2‘),

-> (‘c0‘,101,‘cherry‘,‘3.2‘),

-> (‘a2‘,103,‘apricot‘,‘2.2‘),

-> (‘l2‘,104,‘lemon‘,‘6.4‘),

-> (‘b2‘,104,‘berry‘,‘7.6‘),

-> (‘m1‘,106,‘mango‘,‘15.7‘),

-> (‘m2‘,105,‘xbabay‘,‘2.6‘),

-> (‘t4‘,107,‘xbababa‘,‘2.6‘),

-> (‘m3‘,105,‘xxtt‘,‘11.6‘),

-> (‘b5‘,107,‘xxxx‘,‘3.6‘);

#创建第二个表

mysql> create table customers(

-> c_id int not null auto_increment,

-> c_name char(50) not null,

-> c_address char(50) null,

-> c_city char(50) null,

-> c_zip char(50) null,

-> c_contact char(50) null,

-> c_email char(50) null,

-> primary key(c_id)

-> );

#第二张表插入数据

mysql> insert into customers(c_id,c_name,c_address,c_city,c_zip,c_contact,c_email)

-> values(10001,‘RedHook‘,‘200 Street‘,‘Tianjin‘,‘300000‘,‘LiMing‘,‘LMing@163.com‘),

-> (1002,‘Stars‘,‘333 Fromage Lane‘,‘Dalian