问题描述
我正在使用MySQL Workbench 5.2.28设计数据库架构.我需要将默认数据插入某些表中,这可以使用插入"选项卡来完成.但是,似乎只允许手动输入数据,一次只能输入一行.我有一个要插入几百行的输出文件.
I am using MySQL Workbench 5.2.28 for designing my database schema. I need to insert default data into some tables which can be done using the "Inserts" tab. However, it seems like it only allows entering data manually, one row at a time. I have an OUTFILE with several hundred rows that I would like to insert.
MySQL Workbench有可能吗?创建单独的MySQL脚本以导入默认数据会是更好的方法吗?
Is this possible with MySQL Workbench? Would creating separate MySQL scripts for importing default data be a better approach?
推荐答案
我现在正在使用单独的sql脚本来插入数据,因为似乎没有一种简单的方法可以向MySQL工作台添加批量插入.
I am now using separate sql scripts for inserting my data as there doesn't seem to be an easy way to add bulk inserts to MySQL workbench.
这篇关于MySQL Workbench插入的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!