Re: How to adjust the row id after modifying the tabel

2005-11-21 Thread Michael Stassen
cted (0.00 sec) mysql> SELECT @i:= @i + 1 AS row, animals.* FROM animals; +--++-+ | row | id | name| +--++-+ |1 | 1 | dog | |2 | 2 | cat | |3 | 3 | penguin | |4 | 5 | whale | |5 | 6 | ostrich | +--++-+ 5 rows in set (0.00 sec) Michael -

How to adjust the row id after modifying the tabel

2005-11-21 Thread Xiaobo Chen
Hi, all I follow the example: CREATE TABLE animals ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO animals (name) VALUES ('dog'),('cat'),('penguin'), ('lax'),('whale'),('ostrich'); SELECT * FROM animals; The thing is that

Performance of using 2 columns as row ID

2003-09-15 Thread Russ
Hello, I am currently creating a multi-user system which has approximately 15 tables. Each table has a primaryID as well as the userID of who this record belongs to. Therefore, when I perform a SELECT I am checking (potentially) both the primaryID column as well as the userID. I'm using MyISAM ta

Using Row Id

2002-05-31 Thread Arul
Hi All How do i use RowId 's in MYSQL.. Can anyone throw some light on it Regards, -Arul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Re: row id

2002-04-23 Thread Benjamin Pflugmann
get the row id of a row in MySQL? AFAIK, there is no such concept like row id in MySQL. The usual way to is to add an AUTO_INCREMENT INT to the table and use that. Regards, Benjamin. -- [EMAIL PROTECTED] - Before post

row id

2002-04-23 Thread 龔惠樑(Borus.Kung)
Do anyone know how to select or get the row id of a row in MySQL? thank you Borus - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To

Re: ROW ID

2002-01-14 Thread Ing. Gustavo Edelstein
: [EMAIL PROTECTED] - Original Message - From: Peter Dunham <[EMAIL PROTECTED]> To: Ing. Gustavo Edelstein <[EMAIL PROTECTED]>; Rick Emery <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 2:30 PM Subject: RE: ROW ID > You need to specify a

RE: ROW ID

2002-01-14 Thread Peter Dunham
AIL PROTECTED]] Sent: 14 January 2002 16:58 To: Rick Emery; [EMAIL PROTECTED] Subject: Re: ROW ID What I mean is to get the internal id of every existing row in a table. Thanks. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line

Re: ROW ID

2002-01-14 Thread Ing. Gustavo Edelstein
] Technical: [EMAIL PROTECTED] Web related: [EMAIL PROTECTED] General: [EMAIL PROTECTED] - Original Message - From: Rick Emery <[EMAIL PROTECTED]> To: 'Ing. Gustavo Edelstein' <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Monday, January 14, 2002 1:27 PM Subject:

RE: ROW ID

2002-01-14 Thread Rick Emery
If the value was set with AUTO_INCREMENT, then immediately after inserting the row, do: SELECT last_insert_id() AS myvalue; -Original Message- From: Ing. Gustavo Edelstein [mailto:[EMAIL PROTECTED]] Sent: Monday, January 14, 2002 10:03 AM To: [EMAIL PROTECTED] Subject: ROW ID Hi list

ROW ID

2002-01-14 Thread Ing. Gustavo Edelstein
Hi list members, How to get the unique row id for a row in a table ? Thanks. Ing. Gustavo A. Edelstein Tech. Mgr. Equiplus Argentina S.A. __ Visit us On Line at www.equiplus.com Email addresses: Operations: [EMAIL PROTECTED] Consulting: [EMAIL PROTECTED