如何执行.sql文件以创建新表 [英] How to execute .sql files to create new tables
问题描述
phpMyAdmin配置存储(phpMyAdmin/doc/html/setup.html#linked-tables)说
phpMyAdmin configuration storage (phpMyAdmin/doc/html/setup.html#linked-tables) says
[..],然后通过导入examples/create_tables.sql
[..] and then create new tables by importing examples/create_tables.sql
这不是明确的.我在哪里导入"此文件?它是我必须执行的SQL脚本吗?如何?这些表将在哪里创建?
This is not explicit. Where do I 'import' this file? Is it an SQL script I have to execute? how? Where will these tables be created?
推荐答案
完全按照您的问题说:
-
在我的phpMyAdmin目录中,我可以找到 /examples/create_tables.sql脚本.
In my phpMyAdmin directory I can find the /examples/create_tables.sql script.
当您打开phpMyAdmin时,有一个标签为Import
的选项卡,您可以在其中单击按钮在计算机上浏览该文件.然后,您只需单击Go
.
Right when you open phpMyAdmin there is a tab labeled Import
where you can click on a button to browse on your computer for that file. Then you can just click Go
.
该脚本似乎仅创建一个名为phpMyAdmin的数据库,然后在该数据库内创建表,以便在其中定位表.
The script seems to only create a database called phpMyAdmin and then creates tables inside that database so that's where the tables will be located.
这篇关于如何执行.sql文件以创建新表的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!