如何使用mysql在表中创建ID [英] How to create id in a table using mysql

问题描述

我的表是订单表.我想要订单号ORD01和自动递增.如何创建?请发布示例查询.

My table is orders table. I want order id ORD01 and autoincrement. How can I create? Please, post sample query.

推荐答案

谁在等待给您查询?和发布样本查询".甚至没有要求.

将auto_increment约束添加到您的主键
尝试以下查询获取下一个ID

who is waiting to give you query??????? and "Post sample query." not even a request.

add auto_increment constraint to your primary key
try the below query to get next id

SELECT AUTO_INCREMENT FROM information_schema.TABLES
WHERE TABLE_SCHEMA =  'database_name'
AND TABLE_NAME =  'table_name';

嗨

CREATE TABLE TABLE_NAME
                (
                 COLUMN1 DATATYPE (OPTIONAL)PRIMARY KEY AUTOINCREMENT NOT NULL,
                 COLUMN2 DATATYPE (OPTIONAL)NULL,
                )

示例:

Example:

CREATE TABLE [ORDERS]
                (
                 [ORDER_ID] INTEGER  PRIMARY KEY AUTOINCREMENT NOT NULL,
                 [ORDER_BY] VARCHAR(50)  NULL,
                 [ORDER_DATE] TIMESTAMP  NULL,
                 [IS_ACTIVE] BOOLEAN  NULL
                )

这是创建表的示例，您可以添加尽可能多的列.

This is the sample of create a table u can add as many columns as you can .

这篇关于如何使用mysql在表中创建ID的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！