TJ-Bot
CREATE TABLE tabulka( id INT PRIMARY KEY AUTO_INCREMENT, cesky VARCHAR(50) NULL, anglicky VARCHAR(50) NULL);
im not too sure why the NULL is there, but according to the tutorial im looking for is saying that its supposed to be there. i know the varchar(50)
earning from, the NULL keyword in MySQL allows a column to have no value (be empty). In the example provided, the columns "cesky" and "anglicky" can have empty values if the NULL keyword is used. This means that when inserting data into these columns, it is not mandatory to provide a value.
The PRIMARY KEY constraint on the "id" column ensures that each row in the table will have a unique identifier, and the AUTO_INCREMENT attribute automatically increments the value of the "id" column with each new row inserted.
In summary, this SQL statement creates a table named "tabulka" with three columns: "id", "cesky", and "anglicky". The "id" column is an integer primary key that auto-increments, while the "cesky" and "anglicky" columns are variable character strings that can be left empty (NULL).
It's important to note that using NULL for columns may have implications on data integrity and search queries. It's recommended to carefully consider whether allowing NULL values is appropriate for your data model and business logic.
naive comet
manic abyss