How to assign custom id in mysql

CREATE TABLE document_control (
  id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
  created_at DATETIME DEFAULT CURRENT_TIMESTAMP,
  name VARCHAR(10)
);

Source: stackoverflow.com

How to assign custom id in mysql

CREATE TABLE document_control (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT...

Source: stackoverflow.com

How to assign custom id in mysql

INSERT INTO document_control 
  SELECT CONCAT_WS('-', RIGHT(YEAR(CURRENT_TIMESTAMP), 2), LPAD(COUNT(*) + 1, 3, 0)) 
  FROM document_control
  WHERE LEFT(id_custom, 2) = RIGHT(YEAR(CURRENT_TIMESTAMP), 2)

Source: stackoverflow.com

Similar codes

0 vote196 views1 answer
Find how many tables in database sql query
SQL
-1 vote169 views3 answers
Update mongodb version ubuntu
SQL
0 vote162 views1 answer
Oracle job class
SQL
0 vote186 views2 answers
How to install psql in ubuntu
SQL
6 votes183 views3 answers
Error Code: 1055. Expression #2 of SELECT list is not in GROUP BY clause and contains nonaggregated column 'mydb.term.year' which is not functionally dependent on columns in GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
0 vote173 views3 answers
Find below average salary in sql
SQL
0 vote185 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
1 vote174 views1 answer
Timestamp in sqlite
SQL
9 votes172 views1 answer
No sql
SQL
17 votes162 views2 answers
How to assign date field for table in mysql
SQL