I got a DB in MYSQL (that I haven't created), I do not have the code that was used for it. I want to know what was the code used to create one of the tables in the DB , is there an option to do so? I need to create the same table but on diffrent data..
我在MYSQL中有一个DB(我还没有创建),我没有用于它的代码。我想知道用于在DB中创建其中一个表的代码是什么,是否有选项可以这样做?我需要创建相同的表,但在不同的数据..
Thanks alot! P
非常感谢! P
1 个解决方案
#1
0
In MySQL Workbench you can display the DDL for any DB object. Just right click on it in the schema tree on either Copy to Clipboard or Send to SQL Editor and Create Statement:
在MySQL Workbench中,您可以显示任何DB对象的DDL。只需在模板树中右键单击复制到剪贴板或发送到SQL编辑器和创建语句:
#1
0
In MySQL Workbench you can display the DDL for any DB object. Just right click on it in the schema tree on either Copy to Clipboard or Send to SQL Editor and Create Statement:
在MySQL Workbench中,您可以显示任何DB对象的DDL。只需在模板树中右键单击复制到剪贴板或发送到SQL编辑器和创建语句: