56,675
社区成员
发帖
与我相关
我的任务
分享
DROP TABLE IF EXISTS a1;
-- 创建a表
CREATE TABLE a1
(a1 INT NOT NULL AUTO_INCREMENT,
a2 VARCHAR(50),
CONSTRAINT PRIMARY KEY(a1)
);
-- 插入a表数据
INSERT INTO a1 (a2) VALUES ('SB1203');
INSERT INTO a1 (a2) VALUES ('A2002');
INSERT INTO a1 (a2) VALUES ('Au(T+5)');
INSERT INTO a1 (a2) VALUES ('Ag99.9');
INSERT INTO a1 (a2) VALUES ('FS21104');
INSERT INTO a1 (a2) VALUES ('BRBW');
mysql> select * from a1;
+----+---------+
| a1 | a2 |
+----+---------+
| 1 | SB1203 |
| 2 | A2002 |
| 3 | Au(T+5) |
| 4 | Ag99.9 |
| 5 | FS21104 |
| 6 | BRBW |
+----+---------+
6 rows in set (0.00 sec)