从文件里面load数据到table中 >create database test1; >create table tb1(name varchar(20),number varchar(20)); >load data local infile "/home/kevinsqb/桌面/score" into table tb1; 表结构如下: +-------+------+ | name | age | +-------+------+ | alice | 100 | | bob | 200 | +-------+------+
Copyright © 2005-2024 51CTO.COM 版权所有 京ICP证060544号