Basics of Creating and Using MySQL Databases
15 Oct 2007 Quan Quach 2 comments 337 views
Part III: Entering data into the database
You can manually enter data into the database using the MySQL query method or using the GUI method. That being said, programmers often use a PHP script to write data to MySQL databases, and similarly, use PHP scripts to extract data from MySQL databases. This tutorial will not go into the PHP side, as it is beyond the scope of this tutorial.
Method 1: SQL query window
Let’s enter in some of the following data records manually using the MySQL query method.
To insert the first record, we would type in the following command at the MySQL query window. Make sure that you have the correct database selected before you try to issue this command!
INSERT INTO employees
(name, email, social)
values
("Peter", "peter@blinkdagger.com", "111-11-1111")
Notice that we did not specify a value for emp_id because MySQL automatically takes care of that.
Similarly, we can keep on inserting as many records as we please using this method.
Method 2: Using the Graphical User Interface
Select the database wherein the table is located and select the correct table.
Next, click on the “insert” tab and fill in the information accordingly. Remember that the emp_id field should be left empty because MySQL automatically generates the value for that!
If we browse the table after inserting two records, we would see the following:
Congratulations, you now know how to insert records into the table that you created! You can use the “Browse” tab to see that your records were entered.
End of Tutorial
2 Responses to “Basics of Creating and Using MySQL Databases”
Leave a Reply
Include MATLAB code in your comment by doing the following:
<pre lang="MATLAB">
%insert code here
</pre>
[...] of Creating and Using MySQL Databases blinkdagger placed an interesting blog post on Basics of Creating and Using MySQL DatabasesHere’s a brief [...]
SERERER FYVGFG FDGGTR FNRT TK
DERMFRAGFGF