问题遇到的现象和发生背景
问题相关代码,请勿粘贴截图
use new_schema
create table userbehavior(
userID int,
itemID int,
categoryID int,
bahaviortype text,
timestamp int
);
load data infile "C:\Users\pc\Desktop\UserBehavior.csv"
into table userbehavior
fields terminated by ','
lines terminated by '\n';
运行结果及报错内容
error syntax near 'create table'