mysql建表命令

1. mysql建表命令

CREATE TABLE javafind2 (
   id varchar(10) not null primary key,
   image varchar(30)  NOT NULL,
   password varchar(20)   NOT NULL
 
);

学的都还回去了，建表命令频频写错。。。。
2.插入命令

CREATE TABLE javafind2 (
   id varchar(10) not null primary key,
   image varchar(30)  ,
   password varchar(20)   NOT NULL
 
);
drop table javafind2;


-- ----------------------------
-- Records of javafind
-- ----------------------------
INSERT INTO `javafind2` VALUES ('123', 'C:\Users\asus\Desktop\cat\1(1).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092079', 'C:\Users\asus\Desktop\cat\1(2).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092135', 'C:\Users\asus\Desktop\cat\1(3).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092222', 'C:\Users\asus\Desktop\cat\1(4).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092232', 'C:\Users\asus\Desktop\cat\1(5).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092301', 'C:\Users\asus\Desktop\cat\1(6).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092314', 'C:\Users\asus\Desktop\cat\1(7).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092444', 'C:\Users\asus\Desktop\cat\1(8).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092521', 'C:\Users\asus\Desktop\cat\1(9).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092643', 'C:\Users\asus\Desktop\cat\1(10).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092684', 'C:\Users\asus\Desktop\cat\1(11).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092747', 'C:\Users\asus\Desktop\cat\1(12).jpg', '123');
INSERT INTO `javafind2` VALUES ('202092859', 'C:\Users\asus\Desktop\cat\1(13).jpg', '123');