>>INSERT INTO profile VALUES
(null,'Parvez','Khan','gli@gmail.com');

Display

DESCRIPTION

We insert data into the profile table, as we know the order of the columns, we don’t need to list it here, but it is not a good idea to do that. Usually, we need to list the columns to make sure that we insert data in the right order. We don’t need to specific the id column, because the id is auto increment and primary key, when we assign the null value to the auto increment column, it is automatically generated the unique id for us.

0 comments:

Post a Comment

 
Top
Blogger Template