用phpMyAdmin创建一个简单MySQL数据库表

You’ll find a lot of MySQL tutorials go straight to the command line. While there’s a lot that’s right about that approach – the command line is precise, and always works so long as you type commands correctly – its precision and bare-bones interface is also intimidating to new users. Instead, here I’ll do a light, basic introduction to creating a database table via phpMyAdmin.

您会发现很多MySQL教程直接进入命令行。 尽管该方法有很多正确的地方-命令行很精确，并且只要您正确键入命令就可以正常工作-但它的精确性和准系统界面也使新用户感到恐惧。 相反，在这里，我将对通过phpMyAdmin创建数据库表进行简单的基本介绍。

First, you have to set up a database to contain your table. The name of this database can be almost anything, but should follow

standard web naming conventions, with the addition that you should avoid underscores in the name. Click on the Databases tab and enter the name of the database that will contain your tables.

标准的Web命名约定 ，此外还应避免在名称中使用下划线。 单击数据库选项卡，然后输入将包含表的数据库的名称。

“Collation” is essentially the default character encoding for the database and any tables stored inside it. As a general rule, we should use the same encoding we use on everything else (HTML, CSS, files): utf-8. In phpMyAdmin, there are a bunch of options for this: we’ll stick to utf-8_general_ci.

本质上，“归类”是数据库及其中存储的任何表的默认字符编码。 通常，我们应该使用与其他所有代码( HTML ， CSS ，文件)相同的编码： utf-8 。 在phpMyAdmin