MySQL Workbench插入 [英] MySQL Workbench Inserts

问题描述

我正在使用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插入的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！