我安装的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触发器语句的问题 update 问题 关于一条SQL语句效率的问题 mysql空值查询 求一触发器 mysql下,能否按时间查询某张表里被修改了的数据 group by 的缺点 请高手指点,在MYSQL搜索中,利用concat 函数对中英混合内容搜索,怎么达到像 Like 的效果(忽略英文的大小写)? You can't specify target table city' for update怎么处理 获取查询过指定的多个域名中的每一个的IP及该IP的总查询次数 求一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