Q&A
Ask and answer questions to make information more available to wider audiences.
Adam Kaicler
@kaicleradam 19, Jul 2023 12:00 AM
create a table
How to create a table in MariaDB's database?
answers 1
Answer 1
Aiden Barti
@aidenbarti 09, Aug 2023 02:55 PM
First, you have to create a database in MariaDB follows by selecting the database and then create a table by using the CREATE TABLE statement. You must have the CREATE privilege for a table or on the database to create a table.
Create table statement creates a table name followed by a list of columns, indexes, and constraints. By default, a table is created in the default database
Syntax:
CREATE TABLE table_name (column_name column_type);