![]() ![]() In the Index list, choose PRIMARY, since this will be our PK. Select INT (integer) as the type and choose UNSIGNED in the Attributes drop down list. The first column should be a PK column user_id. Next, phpMyAdmin will display a form to enter your database column (field) definitions. To create such a table, enter user in the Name field and specify the number of fields (we’ll use 6 to start with). Thus, if we create a table named user, the PK column would be named user_id. Preferably, the PK is an integer number and the PK column name is the name of the table plus “_ID”. Each table should have a primary key (PK), which is a value that uniquely identifies a particular record (row) in the table. In database terminology, these are called keys. MySQL is a RDBMS, or relational database management system, which means that you will normally have some relationships between the tables. Each table in your database stores a particular set of data. You can now create the tables in your database. PhpMyAdmin will display the new database automatically. See the MySQL documentation for more information about collation and character sets.) Press Create to create the new database. (Typically, the type of collation in MySQL is not important, but for reasonable flexibility, utf8_general_ci is a good choice. In the Collation drop down, select utf8_general_ci. Note that database names must be a single “word”, but you can use underscores in place of spaces. Enter the name of the database that you desire (in my example, I’ll use workroom_inventory). At the bottom of the Databases tab is a field to create a new database. To create a new database, click on the Databases tab. In general, you do not want to edit these databases directly, but it’s fine to query these databases to learn about MySQL. These databases contain the MySQL metadata and configuration details. To launch phpMyAdmin for WampServer, click on the WampServer icon in the system tray and choose phpMyAdmin from the menu (or you can open it directly in your web browser at All MySQL installations have two databases which are built in: information_schema and mysql. Since most web hosts include phpMyAdmin in their set of default tools, even if you use other tools, it’s good to have a basic understanding of phpMyAdmin. PhpMyAdmin is the most popular PHP-based database configuration utility, although there other options, such as Adminer, are starting to gain traction. WampServer includes phpMyAdmin in it’s installation. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |