Objective: Construction Institute database
In ASP, if it is ACCESS database you can open the MDB ACCESS to edit the document, if you can open SQL SERVER Enterprise Manager to edit SQL SERVER database, but in PHP, MY SQL command line editing may be beginners Am very troublesome, it does not matter, you download the installation of a PHPMYADMIN, after the establishment of Kaota can edit the database.
Below talk about its use.
Entered the phpmyadmin, we first need to create a database,
Language (*) here for the Simplified Chinese, then the left to create a new database here fill in name of the database, to create a click.
The drop-down menu on the left and then select the database that has been created. In the following
In the database shop in the creation of a new table:
Name:
Field:
Fill in the form name and generally do you think the field (or more are not does not matter, the future may add or default), according to the Executive.
Then you can start the establishment of the table.
The first column is the name field; second column select field type:
We used the following:
1) VARCHAR, type text
2) INT, type Integer
3) FLOAT, floating-point type
4) DATE, the date of
5) We may ask, automatically add the ID where ยป INT as long as the choice of this type, in the back of the additional choice auto_increment it.
After the establishment of a table, you can see the establishment of the left in the table, after the click, you can:
1) the right of the structure: Show modified form of
2) Click the right here: the data in Table View
3) the right of the SQL: running SQL statement
4) the right of the insert: Insert his record
5) the right of the Empty: delete all records in the table
6) the right to delete: Delete table
There is also a very important feature is the import and export, when we do a good job in the local procedures and databases, required on the server has a local mirror, if the ACCESS ASP is a simple, direct upload files that MDB May, if it is SQL SERVER can also connect remote server import. MY SQL then you can export all of the SQL statement to the remote server PHPMYADMIN, create a database and then click SQL, Niantie you just copy all of this level can be generated SQL statement.
Here today and tomorrow to say that the database operation.