以如下建表语句填充数据,不超过10create table db_test.tb_student( name string, score int, city string, sex string, hobby string )
时间: 2024-06-07 13:09:26 浏览: 82
mysql数据抽取,自动生成hive建表语句
insert into db_test.tb_student values ('Alice', 90, 'Shanghai', 'female', 'reading');
insert into db_test.tb_student values ('Bob', 80, 'Beijing', 'male', 'swimming');
insert into db_test.tb_student values ('Cathy', 85, 'Shenzhen', 'female', 'music');
insert into db_test.tb_student values ('David', 70, 'Guangzhou', 'male', 'drawing');
insert into db_test.tb_student values ('Emily', 95, 'Hangzhou', 'female', 'cooking');
阅读全文