Databases :: MySql :: INSERT a value at a specific point of the database? |
|||
By: Squibi  |
Date: 17/10/2002 00:00:00  |
Points: 50 | Status: Answered Quality : Excellent |
|
hi there, I wonder if it´s possible to insert a dataset at a specific point of the table? Is there something like INSERT AT or INSERT ON..? thnx in advance dennis |
|||
| By: monange | Date: 17/10/2002 00:14:00 | |
Type : Answer |
| This is not possible with ANY database product (except sequential-like products). mysql goes rather as rdbms product, which cannot guarantee at which point of the table the record will be. Anyway, this should not matter, simply use ORDER BY clause to get the results ordered... CHeers |
|||
| By: digitaltree | Date: 17/10/2002 12:53:00 | |
Type : Comment |
| i agree with angell, just make a field which will hold their sequential value and use ORDER BY .. |
|||
| By: VGR | Date: 31/10/2002 22:45:00 | |
Type : Assist |
| usually, this is the first firld of any well-built table : "ID smallint auto_increment" ;-)) You may OF COURSE insert a record/dataset precisely, in the place ID=43 (for example), provided you copy first record #43's contents to some other ID, by using UPDATE table WHERE ID=43; afterwards |
|||
|
Do register to be able to answer |
|||
©2010 These pages are served without commercial sponsorship. (No popup ads, etc...). Bandwidth abuse increases hosting cost forcing sponsorship or shutdown. This server aggressively defends against automated copying for any reason including offline viewing, duplication, etc... Please respect this requirement and DO NOT RIP THIS SITE.
Please DO link to this page!
Contact
- Privacy
- Contact us
- Member Agreement
- Jobs for our Experts
- our friend ActuLab
- Carcasherdotcom Seocontest
- Add Your Link
- Bee Web Directory
- Discover Directory
- FFind Directory
- Link Velocity Directory
- The Little Web Directory
- Red Links
- Tranix
- 2space Global Directory
Fully downloaded more than 1313 Million times
Copyright © 2003 - 2012 The IT European Experts Organization
last update on : 23/07/2008 09:41:27 GMT 0 (CEST)
