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

6 votes205 views1 answer
Check Table Exists
SQL
5 votes187 views1 answer
Mysql select greater than yesterday
SQL
0 vote311 views1 answer
Postgresql powershell query
SQL
0 vote196 views1 answer
Phpmyadmin tabellentyp ändern
SQL
-1 vote195 views2 answers
Full join sql
SQL
0 vote200 views1 answer
Minecraft duping allowed servers
SQL
0 vote204 views1 answer
Limit and offset in stored procedure mssql
SQL
9 votes212 views1 answer
Sql server get utc date
SQL
12 votes240 views4 answers
How to drop all tables in postgresql
SQL
0 vote247 views1 answer
Oracle executing sqlplus commands and waiting for completion
SQL