RE: RE: date column

-Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, September 30, 2002 6:21 PM To: Tewfic Kidess Subject: Re: RE: date column Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you

select from two different tables query

Hello, I have two different tables with similar fields (id, name, profession, hobbies) Some people might be listed in both tables. I need a write query to select count(*) from the tables group by name... i'd like it get something like this: Joe Smith. total 5 records . 3 records from

load data infile

Hi, I'm running the following query: Load data infile 'data.txt' into table records fields terminated by ';' IGNORE 1 LINES The field-order in my txt file is different than that in my table, can i rearrange the order of the data being loaded and load blank fields in between? Any help will be

RE: Adding new users

This problem happened to me when i first installed mysql, basically you need to add root to the user table of mysql. The first time you log in, password is not set so you log into the system with and hit 'enter', blank for a password, then you have to set password... -Original Message-

RE: Password=password('mypassword')

]] Sent: Monday, May 13, 2002 9:43 AM To: Tewfic Kidess; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Password=password('mypassword') Hi, access table it's your table or you make reference to the mysql.user table ? Regards, Gelu _ G.NET SOFTWARE

RE: Password=password('mypassword')

Hello, thanks for the suggestions so far but... mysql select * from access where UserID='myusername' and Password = password('mypassword'); Empty set (0.00 sec) mysql select * from access where UserID='myusername' and password('mypassword'); returns correct result... mysql select * from access

RE: Password=password('mypassword')

, 2002 10:04 AM To: Tewfic Kidess; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Password=password('mypassword') Hi, I think it's your problem it raise from type of field User from access table.You try to compare some 'char' with 'bin'. So...for this reason you must change type of the User field

Password=password('mypassword')

Why does select * from usertable where user=username and Password = password('passowrd') not worked? select * from usertable where user=username and password('password') does work, but that only checks if user exists and doesn't check for the correct password... Any help will be greatly

undefined function: mysql_connect()

Hello, i'm trying to use PHP4 and MySQL and i'm getting undefined function: mysql_connect() both PHP and MySQL are working on their own, but i have something missing form the PHP setup where it doesn't recognise MySQL. I'd really appreciate any help.

ERROR 1045: Access denied for user: 'root@localhost'

Hello, i'm having a problem accessing mysql database. I don't recall setting a password for root, but when i try to set that password. This is happening right after i run mysql_install_db [root@omsrh etc]# mysql -u root -p Enter password:** ERROR 1045: Access denied for user: