Help with MYSQL INSERT statement?
-
I have 10 rows in a database. If I do another INSERT statement it will insert the values at the end of the database (row 11) like expected. However, I want to insert at the top of the database so it will be the first row. What do I need to include in my insert statement. INSERT INTO products VALUES ('', '$price', '$reward') ..........have it be the first row in database
-
Answer:
make a datetime column and then SELECT the data from there and order by (datime Column).. easy way to do that.. bro
pkjm17 at Yahoo! Answers Visit the source
Other answers
Did you read about key? Always it is not possible if you are taking about physical storage. As records are ordered based on primary key.
James Bond
Related Q & A:
- how to insert multiple rows from MySQL with checkbox?Best solution by Stack Overflow
- Can someone help me out with my personal statement for job?Best solution by jobs.ac.uk
- I have to write a personal statement. Any help?Best solution by ucas.com
- I really need some help writing my personal statement for a nursing program.Best solution by cmu.edu
- Can anyone help me out to correct my statement letter?Best solution by Yahoo! Answers
Just Added Q & A:
- How many active mobile subscribers are there in China?Best solution by Quora
- How to find the right vacation?Best solution by bookit.com
- How To Make Your Own Primer?Best solution by thekrazycouponlady.com
- How do you get the domain & range?Best solution by ChaCha
- How do you open pop up blockers?Best solution by Yahoo! Answers
For every problem there is a solution! Proved by Solucija.
-
Got an issue and looking for advice?
-
Ask Solucija to search every corner of the Web for help.
-
Get workable solutions and helpful tips in a moment.
Just ask Solucija about an issue you face and immediately get a list of ready solutions, answers and tips from other Internet users. We always provide the most suitable and complete answer to your question at the top, along with a few good alternatives below.