create table S
  (SNO char(20),
  SNAME char(20),
  STATUS int,
  CITY  char(10)
);
insert into S
values
      insert to S1 ('S1','精益','20','天津');
      insert to S2 ('S2','盛锡','10','北京');
      insert to S3 ('S3','东方红','30','北京');
      insert to S4 ('S4','丰太盛','20','天津');
      insert to S5 ('S5','为民','30','上海');

还没开始学！帮顶一个。。。。。。

insert into S
values
      ('S1','精益','20','天津'),
      ('S2','盛锡','10','北京'),
      ('S3','东方红','30','北京'),
      ('S4','丰太盛','20','天津'),
      ('S5','为民','30','上海');

谢啦,BZ