Q&A
Ask and answer questions to make information more available to wider audiences.
Riley Kelsey
@kelseyriley85 19, Jul 2023 12:00 AM
insert records in a table
How to insert records in a table in MariaDB database?
answers 3
Answer 1
Ethan Barbrow
@ethanbarbrow 09, Aug 2023 03:12 PM
Or you can use it also with WHERE condition
1. INSERT INTO table
2. (column1, column2, ... )
3. SELECT expression1, expression2, ...
4. FROM source_table
5. [WHERE conditions];
Answer 2
Ethan Barbrow
@ethanbarbrow 09, Aug 2023 03:11 PM
1. INSERT INTO
2. (column1, column2,... )
3. VALUES
4. (expression1, expression2, ... ),
5. (expression1, expression2, ... ),
6. ...;
Answer 3
Aiden Barti
@aidenbarti 09, Aug 2023 03:06 PM
INSERT INTO statement is used to insert records in a table in the MariaDB database.
Syntax:
INSERT INTO tablename (field, field2,...) VALUES (value, value2,...);