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 1005 Error : SQLSTATE: HY000 (ER_CANT_CREATE_TABLE) Message: Can't create table '%s' (errno: 150)
- MySQL Error :1006 SQLSTATE: HY000 (ER_CANT_CREATE_DB) Message: Can't create database 'mydb' (errno: 28)
- MySQL : Error :1004 SQLSTATE: HY000 (ER_CANT_CREATE_FILE) Can't create file
- MySQL ERROR 1064 (42000): You have an error in your SQL syntax [fix]
- MySQL #6 - Error on delete of './my-database/db.opt' (Errcode: 13 - Permission denied)
- Connection Failed: 1130 PHP MySQL Error
- MySQL Error :1007 SQLSTATE: HY000 (ER_DB_CREATE_EXISTS) Message: Can't create database '%s'; database exists
- How to clear mysql console screen
- MySQL: Error Code: 1175 You are using safe update mode
- MySQL : Error :1000 SQLSTATE: HY000 (ER_HASHCHK) Message: hashchk Server Error
- How to find AUTO_INCREMENT Fields value in MySQL table
- Fix mySQL Error Cant connect to local MySQL server through socket /var/run/mysqld/mysqld.sock ERROR 2002 HY000
- [Fix] MySQL No database selected - ERROR 1046 (3D000)
- PHP drag and drop file upload tutorial using dropzone.js - PHP
- How to Word wrap eclipse console logs width - Eclipse
- How to ls command to output one entry per line [macOS/Linux/Bash] - Linux
- Sublime Text 3 spell check shortcut - Sublime
- Replace new line with comma in Sublime Text Editor - Sublime-Text
- How to write hello world different languages syntax - HowTos
- Graph API error when querying BookingBusinesses - ErrorExceededFindCountLimit, The GetBookingMailboxes request returned too many results - Microsoft
- Bash command to wait for seconds - Bash
