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

4 votes363 views1 answer
Oracle session date format
SQL
5 votes381 views1 answer
Oracle nls session
SQL
0 vote337 views1 answer
Oracle character index
SQL
4 votes356 views3 answers
How to describe a table in sqlite3
SQL
0 vote360 views1 answer
Search mysql database for column
SQL
16 votes342 views4 answers
Mysql import from sql file
SQL
0 vote386 views1 answer
Google sheets data validation custom formula filter
SQL
0 vote397 views1 answer
Sql server query all database objects
SQL
1 vote349 views3 answers
Mysql Server Start
SQL
0 vote335 views1 answer
Implicit inner join table alias with id values
SQL