I'm using MySQL as database for online examination system. here Question No. is primary key so, when a question in middle is deleted that number is wasted,(just like in queue data structure).I want the next question numbers to be automatically decremented. is it possible by using PHP and MySQL. If yes, then please write the solution.
How can I automatically update primary key value in MySQL when an entry is deleted?
1.1k Views Asked by user2692583 At
1
There are 1 best solutions below
Related Questions in PHP
- php Variable name must change in for loop
- register_shutdown_function is not getting called
- Query returning zero rows despite entries existing
- Retrieving *number* pages by page id
- Automatically closing tags in form input?
- How to resize images with PHP PARSE SDK
- how to send email from localhost using codeigniter?
- Mariadb max Error while sending QUERY packet PID
- Multiusers login redirect different page in php
- Imaginary folder when I use "DirectoryIterator" in PHP?
- CodeIgniter + XDebug: debug only working in the main controller, index() function
- PHP script timeout when I use sleep()
- posting javascript populated form to another php page
- AJAX PHP - Reload div after submit
- PHP : How can I check Array in array?
Related Questions in MYSQL
- MySQL Select Rank
- When dealing with databases, does adding a different table when we can use a simple hash a good thing?
- Push mysql database script to server using git
- Why does mysql stop using indexes when date ranges are added to the query?
- Google Maps API Re-size
- store numpy array in mysql
- Whats wrong with this query? Using ands
- MySQL-Auto increment
- show duplicate values subquery mysql
- Java Web Application Query Is Not Working
- microsoft odbc driver manager data source name not found and no default driver specified
- Setting foreign key in phpMyAdmin
- No responses from google places text search api
- Adding to MAMP database in SQL/PHP
- I want to remove certain parent- and child-divs in all my wordpress posts with php or some other script
Related Questions in WEB
- What is the point of definnig Asp.net Intrinsic Objects In different places and what is the different betwen them?
- how to prepend www if the url string does not has www?
- @Value annotation not resolved in a class that belongs to dependency jar
- referral link isn't being locked to one ip
- Under what conditions does href="#" cause scrolling to the top of the page?
- Webpage - Font size of table items on mobile phone browsers changes
- Web Service Error path property must set before calling the send method
- Calling ASP webpage from C# application
- What is the best way to make two web pages communicate between each other back and forth?
- CSS Different screen resolution
- How can hide url value in php
- HTML Control Form with PHP - Errors
- How would I use an only for IE8 and not for any other browser
- Client side computation without exposing code?
- detecting a file downloaded in selenium java
Related Questions in SERVER-SIDE-SCRIPTING
- Compiling the apk file at web server
- php server-side application misunderstanding
- Is it possible to preserve the uploaded file in input type="file" tag
- Why is \n not working on one line of my PHP script, but is fine on all the others?
- dojo not getting loaded in rhino environmnet
- Is there a way to give HTML inputs some sort of namespace to avoid collisions?
- Get the filetype of a webpage
- How to develop 100% server-side applications?
- Alternate option for RegisterClientScriptBlock, Is going for 100% javascript good option?
- Serverside Google Analytics for Mobile - is there an async implementation?
- Generating Flex like graphics server side
- reading excel server-side
- Server-side COLLADA converter
- VPN Connection through PHP or some other server-side scripting?
- classic asp multiple server side asynchronous callings
Trending Questions
- UIImageView Frame Doesn't Reflect Constraints
- Is it possible to use adb commands to click on a view by finding its ID?
- How to create a new web character symbol recognizable by html/javascript?
- Why isn't my CSS3 animation smooth in Google Chrome (but very smooth on other browsers)?
- Heap Gives Page Fault
- Connect ffmpeg to Visual Studio 2008
- Both Object- and ValueAnimator jumps when Duration is set above API LvL 24
- How to avoid default initialization of objects in std::vector?
- second argument of the command line arguments in a format other than char** argv or char* argv[]
- How to improve efficiency of algorithm which generates next lexicographic permutation?
- Navigating to the another actvity app getting crash in android
- How to read the particular message format in android and store in sqlite database?
- Resetting inventory status after order is cancelled
- Efficiently compute powers of X in SSE/AVX
- Insert into an external database using ajax and php : POST 500 (Internal Server Error)
Popular Questions
- How do I undo the most recent local commits in Git?
- How can I remove a specific item from an array in JavaScript?
- How do I delete a Git branch locally and remotely?
- Find all files containing a specific text (string) on Linux?
- How do I revert a Git repository to a previous commit?
- How do I create an HTML button that acts like a link?
- How do I check out a remote Git branch?
- How do I force "git pull" to overwrite local files?
- How do I list all files of a directory?
- How to check whether a string contains a substring in JavaScript?
- How do I redirect to another webpage?
- How can I iterate over rows in a Pandas DataFrame?
- How do I convert a String to an int in Java?
- Does Python have a string 'contains' substring method?
- How do I check if a string contains a specific word?
Please do not do this!
The number of the primary key has only one function: Uniquely identifying a record. It does not matter what number it is and if there are gaps in between.
If you want to sort your data use another column like a datetime column or an extra ranking index.