如何给除了主键外的字段设置自增？

如何给除了主键外的字段设置自增？一个表有主键，是自增的，我想给表的另一个字段设置主键，设置成自增从10000开始自增，在网上找了好多资料都是设置主键的，没有其他字段的，想问下如何写？

From [MySQLdiscussion group] 2017-03-08 16:37:59 0  1  1163

How to solve the problem of errors in the cracked version of navicat for mysql downloaded from this website?

The MySQL service cannot be found in the service and cannot be started. What is this error code? The bin folde...

From [MySQLdiscussion group] 2020-03-08 19:46:35 0  1  1163

Web page download problem!

Let me describe it first. For example, we have a direct download address www.php.cn/a.zip [we know that the do...

From [MySQLdiscussion group] 2018-07-11 10:25:23 0  3  1163

Problems with navicat and MYSQL5.7

Scenario: An insert statement is run on the query interface of navicat and an error is reported, such as the f...

From [MySQLdiscussion group] 2017-05-18 10:46:38 0  1  1159

java - mysql blob type reading problem!

The type saved in the database is a blob type, written in C++. I don’t know if it is any different from Java s...

From [MySQLdiscussion group] 2017-06-24 09:41:30 0  1  1152

2-8 The video deleted from the database was placed in the wrong place

2-8 The video deleted from the database was placed in the wrong place

From [MySQLdiscussion group] 2021-11-25 14:17:15 0  6  1148

Common methods for connecting to MYSQL database with PHP

After configuring a Xiaoniao cloud server and deploying a PHP environment, what are the common methods for con...

From [MySQLdiscussion group] 2021-09-07 13:56:33 0  3  1148

Virtual centos error when connecting to mysql

内容Can't connect to local MySQL server through socket '/tmp/mysql.sock'

From [MySQLdiscussion group] 2021-12-10 12:57:42 0  0  1147

mysql optimization - Will the mysql like statement cause a full table scan?

select id from t where name like '%abc%'

From [MySQLdiscussion group] 2017-05-24 11:34:37 0  3  1146

django中使用SQL原生语句如何动态插入变量

我用python写了一段代码用于批量插入数据库出错，如何解决，伪代码：from django.db import connection ... cursor = con...

From [MySQLdiscussion group] 2016-11-14 10:42:15 0  1  1145

mysql group by 不能排序问题

我现在有一个文章表 有两个字段 id 和 catid我想给 每个catid 有8个分类 列出 最新发的一篇文章 {代码...} 这样我只能取出 8条 id 最小的 也就是 最老的一篇文章 order by id 并不起作...

From [MySQLdiscussion group] 2017-04-17 16:52:09 0  3  1144

How to upgrade the database in phpstudy? It is integrated with mysql5.5. How can I upgrade to 5.6 or 5.7? After reading many tutorials on the Internet, it is still 5.5 after installation.

How to upgrade the database in phpstudy? It is integrated with mysql5.5. How can I upgrade to 5.6 or 5.7? Afte...

From [MySQLdiscussion group] 2017-11-15 16:48:28 0  0  1143

mysql怎么实现mssql的if exists() begin...end功能？

需要实现逻辑:判断一子集中是否有制定条件查询值，有的话则向下执行,没有下面代码块不执行。 {代码...} mssql的if exists用法可能有些不同，case语句的话，代码块太长也不合适。 麻烦大神看看怎么实现这个功...

From [MySQLdiscussion group] 2017-04-17 16:22:37 0  2  1143

mysql和redis效率问题？

<?php  $redis = new redis(); $redis->connect('127.0.0.1', 6379); for&nb...

From [MySQLdiscussion group] 2017-03-14 09:37:36 0  2  1142

GROUP BY 出错

代码为：SELECT goods_id , goods_name FROM tdb_goods GROUP BY goods_name;报错为：ERROR 1055 (42000): Expression #1 of S...

From [MySQLdiscussion group] 2016-12-21 17:45:47 0  2  1139