Skip to content
Programming Tips
  • Home
  • Frameworks
    • Laravel
    • CakePHPCakePHP is a rapid development framework for PHP that provides an extensible architecture for developing, maintaining, and deploying applications. Using commonly known design patterns like MVC and ORM within the convention over configuration paradigm, CakePHP reduces development costs and helps developers write less code.
  • Magento
    • Magento 2
    • Magento 1
  • PHP
  • JavaScript
    • jQueryjQuery is a fast and concise JavaScript Library that simplifies HTML document traversing, event handling, animating, and Ajax interactions for rapid web development. jQuery is designed to change the way that you write JavaScript.
  • CSS
  • Other
    • htaccess
    • SSH
    • Server Management
  • Hosting
  • Toggle website search
Menu Close
  • Home
  • Frameworks
    • Laravel
    • CakePHP
  • Magento
    • Magento 2
    • Magento 1
  • PHP
  • JavaScript
    • jQuery
  • CSS
  • Other
    • htaccess
    • SSH
    • Server Management
  • Hosting
  • Toggle website search

MySQL

  1. Home>
  2. MySQL
Read more about the article How to reset AUTO_INCREMENT in MySQL and start counting from 1 again?

How to reset AUTO_INCREMENT in MySQL and start counting from 1 again?

  • Post published:November 13, 2019
  • Post category:MySQL
  • Post comments:0 Comments

Let say you have a table called "my_table" with an auto-increment column called "id" and you want the id column to start counting from 1,2,3,... then use the following SQL…

Continue ReadingHow to reset AUTO_INCREMENT in MySQL and start counting from 1 again?
Read more about the article MySQL: truncate foreign key constrained table

MySQL: truncate foreign key constrained table

  • Post published:April 28, 2013
  • Post category:MySQL
  • Post comments:0 Comments

Continue ReadingMySQL: truncate foreign key constrained table

Search

Categories

  • Cloudflare
  • CMS
    • Joomla
      • Joomla Templating
      • K2
      • T3 Framework
  • CSS
  • Excel
  • FaceBook
  • Frameworks
    • CakePHP
  • General
  • Git
  • JavaScript
    • AJAX
    • jQuery
    • MooTools
  • Magento 1
  • MySQL
  • PayPal
  • PHP
  • Security
    • htaccess
    • Server Management
    • SSH
  • Ubuntu
  • Uncategorized
  • WHMCS

Tag Cloud

AJAX CakePHP CakePHP 2 Cart Cloudflare CSS CSS3 Envato Error facebook facebook comments Git GoDaddy htaccess IP address IPv4 IPv6 JavaScript Joomla Joomla 1.5 JQuery K2 Magento 1 MySQL PHP Price Programmatically Rule Security Server Management Shopping SSH T3 Framework url warning

Recent Comments

  • Piter entity on Magento – How to create a special price (sale) page? (with new products first)
  • ILDaviz on Magento Dataflow Export/Import form the command line
  • ala on Warning: Parameter 2 to frontpage() expected to be a reference
  • Support PaceTech on Magento: Rating showing twice on product pages
  • Susanta Kumar Das on Magento Dataflow Export/Import form the command line
  • Privacy Policy
  • Terms of Use
Copyright - WordPress Theme by OceanWP