MySQL Forums
Forum List  »  Newbie

Re: How do I change this table to get it to load
Posted by: Alvaro Nuñez
Date: March 02, 2009 01:26PM

hi, if the id is auto_increment you should write:
VALUES (Null, 'admin','pass'); that why you use auto_increment
if you want to know which number iserted:
select last_insert_id()

you also should encrypt the password calling the password function:

VALUES (Null, 'admin',password('pass'));

i hope it could be usefull

Options: ReplyQuote


Subject
Written By
Posted
Re: How do I change this table to get it to load
March 02, 2009 01:26PM


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.