Iv. creating a database using visual ToolsAlthough using the command line feels more like our programmers, I prefer to use Workbench to create a database. first Open the workbench, a more friendly interface on the open, haha. I still prefer this interface.
you can see that the database I created yesterday with the command line is also in. Here the names of these columns are my own, because I am research, and have not seen the formal name, too lazy to check. But in Workbench this visual interface to create a database, it executes the command is not database but the schema, click the Create database shortcut, in the Quick Create Bar fourth button, . Then enter the name, in the lower right corner there is an apply, click on the created. Then your database that column will have a database, point open the front of the small triangle, you will see the inside of things,The following three are not used here, just use tables this option is good. In the PHP operation of this database is best to first set the database as the default database, right click on the database, select the first set as default ... Then he was bold. Then create the database table in the tables, right-click, create TABLE, and you will see the interface for creating tables:
using the visualizer to create is very simple, adding a column only needs to double-click under the column name, you can edit, and then select the data type, this column of properties, on the above is a shorthand for the property, the following details can be seen complete, and the default value can be set by itself. Once you have added the required columns, click Apply to OK. and then just add the data to the table, which is also called simple, using the student table in the test database I created yesterday, for example, first, I right-student, select Rows, you can see the records in this table, However, the default limit is 1000 records.
If I want to add a record, I can write directly in the code edit area above, yesterday's those statements, and then click on the Execute button above. There is one more record when you view the record. Of course, since the visualization will certainly have a simpler way, is to display the records below the place, directly to add. Like here I double-clickHere's the ID below where you can edit it. After adding the data to all the columns, click Apply below and then add it. I think that's all I can use. All of this should then be done using the PHP language to manipulate the database. So the visualization is still relatively friendly.
Learn php-(15) MySQL database basic operations 2
