OpenSource For You

Inserting data into a MariaDB table

-

To insert data into a MariaDB table, use the following commands:

INSERT INTO details(name,age,marks) values ("anu",15,450);

INSERT INTO details(name,age,marks) VALUES("Bob",15,400);

The output will be as shown in Figure 4.

We need not add values in student_id. It is automatica­lly incremente­d. All other values are given in quotes.

 ??  ?? Figure 4: Inserting data into a table
Figure 4: Inserting data into a table

Newspapers in English

Newspapers from India