Administrative Tools Sqlyogent: Simple to create a MySQL database

If you choose PHP to build the site, you must understand that PHP to build a database, it is necessary to use MySQL data. Just contact with a friend of PHP may be unfamiliar to this MySQL database, but if there is a very useful database management tools, it is more convenient to use, the author a few days to introduce a MySQL management tool sqlyogent, the author is used sqlyogent is the English version, At present, there seems to be no Chinese version, because of powerful, so sqlyogent very popular with PHP users, and then use the example to explain how to use sqlyogent to build a simple database.

The database I built today is called "MyDB", and the database contains a table "news". Next we will open the sqlyogent to actually operate.

First, open sqlyogent, because to run MySQL must first open the operating environment, the author uses the PHP operating environment is WAMP, very good use, a key installation.

Second, open the sqlyogent will first pop-up link database interface, such as figure, MySQL hostaddress option box fill in the address of the stack, the default this machine is "localhost", User name option box is to fill in the database management username, local default "root ", the Password option box is to fill in the database management password, this machine defaults to empty, port is the database port, the default is OK, the last point of the" Connect "button to link.

If the address, username, password will be the correct link to the success of the random pop-up interface is the entire database list, as shown.

Third, create a new database. In the left margin of the list in the right mouse button, pop-up menu, select "Create Database", and then pop-up fill in the name of the box, such as figure, we fill in "MyDB", and then click the "Create" button, "MyDB" database was created successfully, The "MyDB" database appears in the list of databases on the left.

Four, create the "news" table in the "MyDB" database, find the "mydb" database in the left menu, then right-click on it, and in the pop-up menu, select "CREATE TABLE" to pop up and create the table interface, as shown

To create a field, first introduce the next Sqlyogent tool to create the table interface. The fields column is the field name, "Datetype" is the field type, "Len" is the field length, "PK" is the primary key, "not NULL" is allowed to be null, "Auto incr" Automatically grows (the general primary key is selected), "Comment" field description, Okay, here's how to create an interface, which is really simple. You can see how I set up the news table. When the settings are complete, click the Create Table button, and then the dialog box that sets the table name will pop up and write the news click OK button.

Okay, after the five steps above, you've built a MySQL database that contains a table that you can build with your actual needs on your site, and I'll continue to explain the other applications of sqlyogent.