×
Night mode
Sign up
Login
Multiple columns can be primary key of the table at the same time
We can have several primary keys in the same table
CREATE TABLE note (
    id int AUTO_INCREMENT,
    note_id int,
    title varchar(50),
    description varchar(50),
    PRIMARY KEY(id, note_id, title)
);
by Valeri Tandilashvili
4 years ago
MySQL
CREATE TABLE
AUTO_INCREMENT
1
Pro tip: use ```triple backticks around text``` to write in code fences