But if you use reserve words or space in table or column names, an error will occur. Of course, you don’t need to enclose these identifiers. NOT NULL DEFAULT GETDATE(),ĬONSTRAINT PRIMARY KEY
MYSQL CREATE TABLE IN DATABASE CODE
If you are not used to enclosing table and column names with this, trust me, you are not alone.Ĭheck the equivalent code in T-SQL below: - T-SQL CREATE TABLEĬREATE TABLE. `ModifiedDate` DATETIME NOT NULL DEFAULT NOW(),įrom the code sample above, table and column name identifiers are enclosed in backticks. Now, check out the sample: - MySQL CREATE TABLE The backtick character is shown on a US keyboard layout. Figure 1 shows where you find it on a US keyboard layout: Figure 1. You should use a pair of backticks to enclose identifiers instead. Using square brackets in table and column names will trigger an error in MySQL.
However, if you need to create a table in another database in the same script, this is a must. The database and schema names are optional. Why? Because in MySQL, a schema is synonymous with a database. Here’s how it goes: CREATE TABLE database_name.table_nameĭid you notice the table name preceded by the database name? Now, here’s a T-SQL equivalent format you are familiar with:ĬREATE TABLE database_name.schema_name.table_name One of the noticeable syntax differences in MySQL CREATE TABLE is the absence of a schema name. Let’s start the comparison by defining the table name. Create Table Statement in MySQL and T-SQL The SQL Server version used here is SQL Server 2019.The MySQL version used here is MySQL 8 using the InnoDB storage engine.However, before we proceed, let’s clarify a few points:
So, we will only cover 5 basic points to get you up and running with MySQL CREATE TABLE command.
Besides, the fastest way to learn a new SQL database platform is by comparing its common functionality and syntax. Are you a T-SQL developer learning the basics of MySQL? Then, one of the things you might want to learn is MySQL CREATE TABLE statement.
0 kommentar(er)
