Breaking News
yeni film izle hd film seyret film izle

Adding Data to a Table

Adding Data to a Table To insert the data in a Table related to the courses use the SQL INSERT statement.

INSERT INTO table VALUES (value1, value2, …);

This inserts values into each of the fields of the table, in the order that the fields were created.

Alternatively, you can create a row with only some fields populated. The remaining fields will contain NULL (if allowed), or in the case of special fields such as an AUTO_INCREMENT field, the field value will be calculated automatically. To insert a row of partial data, use:

INSERT INTO table ( field1 , field2 , … ) VALUES ( value1 , value2 , … );

So you can add three rows to the Course table by inserting data into just the Course name and Duration fields (the id field will be filled automatically):

mysql > INSERT INTO Course ( Course name, Duration ) VALUES ( ‘C’, ‘3’ );
Query OK, 1 row affected
mysql > INSERT INTO fruit (Course name, Duration) VALUES ( ‘ASP.NET’, ‘6’ );
Query OK, 1 row affected
mysql > INSERT INTO fruit (Course name, Duration) VALUES ( ‘MySql’, ‘8’ );
Query OK, 1 row affected

Check Also

Copying, Renaming, and Deleting Files

PHP also allows you to copy, rename, and delete files. The functions to perform these …