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 vote128 views1 answer
Transaction database with php
SQL
1 vote138 views1 answer
PL SQL MODIFY COLUMN NME
SQL
0 vote138 views2 answers
Coursera spark sql max count
SQL
11 votes154 views4 answers
Reset identity column values in sql server
SQL
10 votes138 views4 answers
Mysql one week ago
SQL
3 votes134 views1 answer
Mysql set field unique
SQL
8 votes99 views1 answer
Oracle current date plus 1 month
SQL
0 vote125 views1 answer
Mariadb LOAD DATA INFILE
SQL
4 votes133 views3 answers
How to describe a table in sqlite3
SQL
1 vote154 views1 answer
Select inside insert query
SQL