PHP

How to set AUTO_INCREMENT ID in mySQL ?
CK CK 3788 
Created at
Updated at  
 607 0 0

In case that you need to set AUTO_INCREMENT ID manually, you can set it as below:

 

ALTER TABLE tbl AUTO_INCREMENT = 1000
Tags AUTO_INCREMENT MySQL Facebook X
Comments 0
Similar posts
  1. How to create private URL on S3/CloudFront with time-limit ?
    919
  2. Stateful Databases: A Deep Dive with Cassandra & TiDB
    187
  3. Change MySQL port number for security purpose
    815
  4. Using MySQL in Node.js
    477
  6. Rust code example to access MySQL
    1,098
  7. The Ultimate Data Engineering Roadmap
    1,072
  8. How do I create a user account in read-only mode at MySQL?
    3,308
  9. Vector Search in Relational Databases (RDBs): Trends & Usage Environments
    287
More in PHP
  1. 32bits simple hash function in PHP
    39
  2. PHP Code Compression Tool by removing whitespace, strips comments - PHP Minifier/Compressor
    1,412
  3. Setup Apache+PHP+MySQL on Centos 6.7
    605
  4. mcrypt missing when using phpMyAdmin on Centos 6.7
    548
  5. PHP Code can know the current OS is windows or not
    584
  6. Checking similarity between two strings in PHP
    674
  7. Simple PHP calendar
    474
  8. Simple PHP code performance measuring example
    792
  9. Convert plain HTML to XHTML
    452
  10. GD library version in PHP
    505
  11. JSON format control in PHP
    692
  13. mysql optimization – if you are using Word Press, do not turn off persistent connection
    592
  14. File downloading function through PHP code
    532
  15. Image file resizing in PHP
    561
  16. Apache server unstable detection and the related server(mysql, apache) restart automatically
    537
  17. Function can extract file name in string having full path in PHP
    567
  18. How to create private URL on S3/CloudFront with time-limit ?
    919
  19. Parsing XML in PHP
    1,192
  20. Unzip a ZIP file in PHP
    503
  21. Uploading files to Amazon S3 with REST API in PHP
    842
  22. Human readable random string for captchas in PHP
    559
  23. How to get browser information in PHP?
    853
  24. How to get the duration between days in PHP
    423
  25. Date format validation in PHP
    571
  27. PHP function converts new line to BR tag
    560
  28. Email Validation Snipet in PHP
    379
  29. PHP socket programming to get content with post method
    410
  30. Get Remote IP Address in PHP
    498
  31. How to remove HTML tags in text string?
    405
  32. Directory listing in PHP
    512
Recently updated
  1. Why 100% SEO Guarantees Better User Engagement and How to Achieve It in Your Service
    40
  2. Why SPF and DKIM Are Essential for Linux Email Servers?
    34
  3. How do I create animated background for Google Meet?
    20,613
  4. MaxMind GeoLite2 vs. DB-IP Lite vs. ip-api.com: Choosing the Right Free IP Geolocation Solution
    244
  5. Meet Valkey: Why Redis Changed Its License, Why Valkey is Better, and How to Use It as a Drop-in Replacement
    94
  6. How Rogue Web Scrapers Are Stealing My Content and Destroying My Server
    157
  7. Array of arguments passed to script in PHP
    90
  8. Invalid Auction Storms in Ad Tech
    98
  9. Building MRC-Compliant Instrumentation in Ad Tech: Implementation Steps and Key Challenges
    202
  11. The Two Clocks of Ad Server Architecture
    70
  12. Frequency Cap Architecture Overview
    514
  13. Collecting Proof-of-Play from 100,000 Screens
    146
  14. Vector Search in Relational Databases (RDBs): Trends & Usage Environments
    287
  15. What is RedisVL?
    109
  16. Designing a Skill Registry Architecture: Minimize Token Usage and Maximize AI Performance
    230
  17. TPU & GPU Cluster Management Tools
    244
  18. The Concept of Scaffolding in AI Agents
    233
  19. Beyond Static Pipelines: Architecting LLM Multi-Agent Systems for Autonomous Workflow Orchestration
    583
  20. AI-DLC vs. AI-SDLC: Model-Centric vs. System-Centric AI Development
    258
  21. Fine-Tuning Open-Weight LLMs: Training, Licensing, and Deploying Custom Models with Ollama
    339
  23. Inside the Next-Generation Streaming Architecture: Ultra-Low Latency, SGAI, and AI Codecs
    202
  24. Machine Learning: Training vs. Ranking
    221
  25. The Continuous Learning Machine: Designing a Loop That Actually Turns
    222
  26. The Next-Gen Low-Latency Standards: LL-HLS & MoQ
    195
  27. Designing a Data Curation System Around a Vector Database
    220
  28. Extracting Context from Live Video: The Architecture Got Simpler When We Stopped Building Features
    256
  29. The New Ad Stack Behind Live Sports Streaming: Inside SGAI, EABN, and the Standards Race to Fix Live Monetization
    656
  30. Designing MLOps Architectures to Handle Seasonal Data Drift in EV Fleet Models
    195
  31. From 15 to 40+ FPS: Accelerating PyTorch Object Detection on Automotive ECUs
    217
  32. Understanding Data Lineage
    260