How can tables be created in a database using MySQL?

To create a table in MySQL database, you can use the CREATE TABLE statement. The syntax is as follows:

Create a table with the following columns and data types:

For example, to create a table named “students” with columns “id” and “name”, you can use the following statement:

Create a table for students with columns for student ID as an integer and student name as a variable character up to 50 characters long.