进行MySQL建库/建表的多种方法

易语言 2020-04-05 14:24:50

进行MySQL建库/建表的多种方法

局_SQL语句 = “CREATE TABLE `abc_user` (”
局_SQL语句 = 局_SQL语句 + “`ID` bigint(20) NOT NULL AUTO_INCREMENT,”
局_SQL语句 = 局_SQL语句 + “`user` varchar(32) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci NOT NULL,”
局_SQL语句 = 局_SQL语句 + “ `age` smallint(6) NOT NULL,”
局_SQL语句 = 局_SQL语句 + “PRIMARY KEY (`ID`) USING BTREE”
局_SQL语句 = 局_SQL语句 + “) ENGINE = InnoDB CHARACTER SET = utf8mb4 COLLATE = utf8mb4_0900_ai_ci ROW_FORMAT = Dynamic;”
执行SQL语句 (局_MySQL句柄, 局_SQL语句)