Use this:
ALTER TABLE users AUTO_INCREMENT=1001;
or if you haven’t already added an id column, also add it
ALTER TABLE users ADD id INT UNSIGNED NOT NULL AUTO_INCREMENT, ADD INDEX (id);
Related Posts:
- Get the new record primary key ID from MySQL insert query?
- How to make MySQL table primary key auto increment with some prefix
- “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
- MySQL Every derived table must have its own alias
- MySQL Error 1264: out of range value for column
- LAST_INSERT_ID() MySQL
- How to join two tables by multiple columns in SQL?
- Object of class DateTime could not be converted to string
- MySQL date formats – difficulty Inserting a date
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- Warning: session_start(): Cannot send session cookie – headers already sent by (output started at [duplicate]
- How to do a batch insert in MySQL
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
- When is K 1024 and when is it 1000?
- Dial pad to get phone number (with Android button images)
- Why is it not possible to fake an IP address?
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Authentication versus Authorization
- What is tail recursion?
- what is svn? and how to use it with project?
- How should I tackle –secure-file-priv in MySQL?
- Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- How to set a timer in mysql
- ERROR 1064 (42000) in MySQL
- Error Code: 2013. Lost connection to MySQL server during query
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- Even though JRE 8 is installed on my MAC -” No Java Runtime present,requesting to install ” gets displayed in terminal
- Search for all occurrences of a string in a mysql database
- What fonts can I use with pygame.font.Font?
- CSS Box Shadow Bottom Only
- Create mysql table directly from CSV file using the CSV Storage engine?
- What is the “N+1 selects problem” in ORM (Object-Relational Mapping)?
- HTML Best Practices: Should I use ’ or the special keyboard shortcut?
- What is runtime in context of Python? What does it consist of?
- How to update a record using sequelize for node?
- Multiplying a register value by a constant in MIPS?
- What’s the use of the staging area in Git?
- Mac install and open mysql using terminal
- Getting DOM element value using pure JavaScript
- What is the difference between lemmatization vs stemming?
- MySQL Select Multiple VALUES
- What is a .meta file and why does Unity create them for all of my assets?
- What’s the difference between sx and σx in the statistics calculations on a TI-Nspire?
- Apache Kafka vs Apache Storm
- Get Featured Image via direct sql query
- Get url of product’s images (woocommerce)
- MySQL Query to Retrieve Category from wp_posts
- How does WordPress handle MySQL row lock errors?
- Manually delete post from database
- Huge wp_options table
- Custom ordering fails after AJAX post filter
- Check if image exists before uploading with media_sideload_image()
- How to remove ‘GROUP BY’ from SQL query produced from get_posts?
- MySQL LIKE not working
- theme options echoing multiple times
- WordPress 3 – how are passwords stored and how do I compare to them?
- how to echo all tables that start with a prefix
- How to find exact match for search term in WP_Query? What is the additional string added in LIKE query in WP_Query?
- Improve wp query perfomance on large db
- SQL database export-import
- Removing a wordpress multisite installation and preserving the database before migrate to nginx
- database collation differences
- Accessing data from a non-WP database/table within a page content
- Uncaught Error: Call to undefined function mysql_connect() – WordPress installation
- MySQL select query with ajax
- wp_insert_post sometimes fails after API call
- Code to remove authors with no posts connected to them
- Remove a shortcode from all WordPress posts
- SQL Query in WordPress – Getting Impossible WHERE error
- Add Woocommerce product to cart with Contact Form 7 [closed]
- Can’t update WordFence Options, clear data manually
- Moving wordpress site from localhost to live server using GoDaddy cPanel
- How does WP work in conjunction with a web server?
- DB Query not working in Plugin
- How to unserialize data from MySQL
- Remote database -> massive response time increase?
- SQL error with custom query
- What database state changes happen after a post is manually “updated” with no changes?
- Woocommerce Get Orders By Meta Value
- How to simulate web traffic to test performance of a website
- Remove escape characters from JSON string pulled from a database
- Custom post type and custom taxonomy key lenght & query performance
- WordPress Bad Request Error 400
- I am facing this error Your PHP installation appears to be missing the MySQL extension which is required by WordPress
- SQL. Select category descendants
- WordPress Query optimaization for slow query
- autocomplete in wordpress using ajax with json-data
- Is it possible to replace MySQL with JSON files for WordPress
- WordPress doesn’t create table on plugin activation
- WPCLI search and replace in a particlar site dir effect another site-dir
- In woocommerce some products have empty options, but how to check this
- Migration of wordpress database from mariadb 10.0.20 to 5.5.50
- To remove rendering of menus and header, plugin or theme?
- Custom redirects with using SQL
- is_user_logged_in() not working after domain change
- SQL query into to WP query
- Why is the response on localhost so slow?
- apache2: Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName