If you want to know at any given time what is the next value of an AUTO_INCREMENT filed for a given table in your MySql database then you can get it by running the below query in your phpMyAdmin SQL tab.
Query : show table status like "your_table_name";
You would get a record with details about the queried table like,
Name, Engine, Version, Row_format, Rows, Avg_row_length, Data_length, Max_data_length, Index_length, Data_free, Auto_increment, Create_time, Update_time, Check_time, Collation, Checksum, Create_options, Comment.
The value of Auto_increment filed is the next value that will be used when some record is added to this table.
If you want to change this value, just edit the filed and apply the changes.
Post Date : January 21st 2015
Warning: include(../../php/comment.php) [function.include]:
failed to open stream: No such file or directory in
/home/reai46l46b55/public_html/pages/
how-to-find-auto_increment-fileds-value-in-mysql-table/index.php on line 69
Warning: include() [function.include]:
Failed opening '../../php/comment.php' for inclusion (
include_path='.:/usr/local/php5_3/lib/php') in /home/reai46l46b55/public_html/pages/
how-to-find-auto_increment-fileds-value-in-mysql-table/index.php on line 69Tags : #MySQL #AutoIncrement #Table #Sql
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- [Fix] MySQL Docker ERROR 1045 (28000): Access denied for user root@localhost (using password: YES/NO)
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL: Error Code: 1175 You are using safe update mode
- Connection Failed: 1130 PHP MySQL Error
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- Display List of Databases in mysql Command Line
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- How to query database table names [MySQL/Oracle/SQL Server]
- MySQL Query for Schema/Structure of a Table
- How to find AUTO_INCREMENT Fields value in MySQL table
- [fix] Loading class com.mysql.jdbc.Driver is deprecated
- Identify MySQL version in MySQL Command Line Prompt
- How to clear MySQL Console Screen
- Git Commit - Author identity unknown, Please tell me who you are email - Git
- 10 FTP SFTP Clients and Alternatives - FTP
- Make Android TextView Clickable like Buttons - Android
- W3 HTML validator warning Unable to Determine Parse Mode - Html
- SharePoint Server 2016 installation System Hardware requirements - SharePoint
- [Android Studio] Could not automatically detect an ADB binary - Android-Studio
- Failed to find provider info for com.facebook.katana.provider.PlatformProvider - Android
- How to Enable spellcheck Notepad++ - NotepadPlusPlus