How to learn the third day of php in ten days

Objective: to learn how to build a database in ASP. if it is an ACCESS database, you can open ACCESS directly to compile the MDB file. if it is SQLSERVER, you can open the enterprise controller to compile the SQLSERVER database, however, in PHP, MYSQL command line compilation

Objective: to learn how to build a database

In ASP, if it is an ACCESS database, you can directly open ACCESS to compile the MDB file. if it is an SQL server, you can open the Enterprise Administrator to compile the SQL SERVER database, but in PHP, it may be difficult for beginners to compile the command line of my SQL. you can download a PHPMYADMIN and install it. you can establish a compilation database later.

Let's talk about its application.
After entering phpmyadmin, we first need to create a database, Language (*) Here select simplified Chinese, then create a new database on the left here fill in the database name, click create.

Select the created database from the drop-down list on the left. In the following

Create a new table in the database shop:
Name:
Number of fields:

Enter the table name and the approximate number of fields you think (it does not matter if it is not enough or more, you can add it later or use the default value.
Then you can start to create a table.
The first column is the field name, and the second column selects the field type:
We usually use the following:
1) VARCHAR, text type
2) INT, integer type
3) FLOAT, floating point type
4) DATE, DATE type
5) You may ask where the ID is automatically added? You only need to select the INT type, and select auto_increment in the additional section below.

After creating a table, you can see the table you created on the left. after clicking it, you can:
1) view the modified table structure by structure on the right
2) click browse on the right: view the data in the table
3) press SQL on the right to run the SQL statement.
4) insert to the right: insert a row of records
5) clear by right: delete all records in the table
6) delete the table on the right: delete the table

Another important function is import and export. However, when the program and database are ready on the local machine, we need to have a local image on the server. if asp access is simple, you can directly upload the MDB file, and use SQL SERVER to connect to the remote SERVER for import. In my SQL, you can export all SQL statements to PHPMYADMIN on the remote server. after creating a database, press SQL, paste all the native SQL statements that you just copied.

Let's talk about database control today.