MySQL Forums
Forum List  »  Newbie

Syntax
Posted by: imatus
Date: March 27, 2005 01:56AM

Hello,

I've got a syntax problem:

$query = "INSERT INTO banip (id, ip) SELECT remote_ip FROM gbook";

Something is missing in this statement and I even know what (VALUE (0) for id), i.e.:

id -> VALUE (0)
ip -> SELECT remote_ip FROM gbook

But I don't know how to stick these 2 together :S
Please drop me a hint
Thank you in advance

Options: ReplyQuote


Subject
Written By
Posted
Syntax
March 27, 2005 01:56AM
March 27, 2005 03:44AM
March 27, 2005 09:34AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.