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

1 vote180 views2 answers
ImportError: No module named mysql.connector
SQL
10 votes184 views3 answers
Join multiple tables sql
SQL
0 vote177 views1 answer
Addition of 2 column value in mysql
SQL
0 vote188 views1 answer
Sql case sttement with set
SQL
0 vote193 views1 answer
Create table in mysql mariadb primary key foreign key
SQL
0 vote166 views1 answer
Mysql xampp reset root password
SQL
0 vote225 views1 answer
Sql query to select even numbers
SQL
1 vote173 views1 answer
Sql injection
SQL
1 vote191 views2 answers
Copy database mysql
SQL
0 vote182 views1 answer
Update sqlaclehmy sqlalchemy.orm.evaluator.UnevaluatableError: Cannot evaluate BinaryExpression with operator <function like_op at 0x03CF1DF0>
SQL