我安装的MySQL怎么没有Advanced Toolbar呀???? 是windows环境,还有使用load data local in file "D:\pet.txt" into table pet;怎么不能把文件导入进去啊?我是刚学数据库。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 load data local infile "D:\pet.txt" into table pet;in file -> infile LOAD DATA [LOW_PRIORITY | CONCURRENT] [LOCAL] INFILE 'file_name' [REPLACE | IGNORE] INTO TABLE tbl_name [CHARACTER SET charset_name] [{FIELDS | COLUMNS} [TERMINATED BY 'string'] [[OPTIONALLY] ENCLOSED BY 'char'] [ESCAPED BY 'char'] ] [LINES [STARTING BY 'string'] [TERMINATED BY 'string'] ] [IGNORE number LINES] [(col_name_or_user_var,...)] [SET col_name = expr,...]初学可以多参考一下MYSQL的官文档中的语法说明。MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html load data local infile "D:\pet.txt" into table pet;前提你有file权限 还有就是,MySQL怎么没有Advanced Toolbar? mysql存储过程实现自动插入海量数据?(大家热情探讨!) mysql 有没有类似于oracle的comment on之类的语法? 哪位简单说说在ubuntu下用c++怎么连接mysql? 存储过程输出参数为null?? select into null 付值问题 为什么我不能往mysql中写入文件。 在线等待!WINDOWS下C语言连接MySql数据库的问题。 如何实现这样的联结查询 sql统计 ...又遇到问题了,关于java和mysql时间数据类型的问题,有图有代码。快没分了,省着用 求一MYSQL存储过程 还是MYSQL的问题(在线等待)[几乎每天都会在]
in file -> infile
[REPLACE | IGNORE]
INTO TABLE tbl_name
[CHARACTER SET charset_name]
[{FIELDS | COLUMNS}
[TERMINATED BY 'string']
[[OPTIONALLY] ENCLOSED BY 'char']
[ESCAPED BY 'char']
]
[LINES
[STARTING BY 'string']
[TERMINATED BY 'string']
]
[IGNORE number LINES]
[(col_name_or_user_var,...)]
[SET col_name = expr,...]初学可以多参考一下MYSQL的官文档中的语法说明。MySQL官方文档 http://dev.mysql.com/doc/refman/5.1/zh/index.html