Hi,
You can see the table structure with the command:
> desc host;
after logging in to mysql using the table mysql
Greetings,
Richard
- Original Message -
From: "Gregory Norman" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, October 17, 2003 10:31 AM
Subject: error message
users and sometimes it happens that there are multiple
inserts before I can receive the last id.
Is it possible to stop inserts until I have finished both inserts?
Thank you,
Richard Brenner
-
Before posting, please chec
Hi.
I have two tables with the following structure:
Users:
+--+--+--+-+-+--
--+
| Field| Type | Null | Key | Default | Extra
|
+--+--+--+-+-+--
--+
| id
This is a known "problem", not a bug in mysql.
You can get the affected rows by entering this sql statement: "delete
from Sqs where 1>0"
Greetings, Richard
-Ursprüngliche Nachricht-
Von: Ralf Narozny [mailto:[EMAIL PROTECTED]]
Gesendet: Montag, 15. Juli 2002 16:16
An: Bhavin Vyas
Cc:
Try this query:
SELECT
yourcolumn+1
FROM yourtable
ORDER BY id desc
LIMIT 1;
greetings,
richard
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (t