Re: select * into outfile

2002-09-08 Thread Tom Gao
you need to execute your query first you can avoid execute by using the just 'do' or else you'll need to execute your query before getting results Tom - Original Message - From: edatanew.com [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 09, 2002 12:35 AM Subject:

Re: generating random integer id

2002-08-17 Thread Tom Gao
hi guys, I'm trying to generate randomly a number as the primary key the key is to be an integer in mysql. So like auto_increment I can insert values and the pk can be generated automatically. could someone point me to the right direction please thanks Tom

Re: generating random integer id

2002-08-17 Thread Tom Gao
I wish to use mysql to do the rand id generation... Tom - Original Message - From: David Lloyd [EMAIL PROTECTED] To: Tom Gao [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Saturday, August 17, 2002 11:59 PM Subject: Re: generating random integer id [ mysql, query ] could

Re: MySQL vs. Oracle (not speed)

2002-08-16 Thread Tom Gao
what query was it may I ask ? Tom - Original Message - From: Mary Stickney [EMAIL PROTECTED] To: Francisco [EMAIL PROTECTED]; Elizabeth Bogner [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, August 16, 2002 11:52 PM Subject: RE: MySQL vs. Oracle (not speed) I have been doing speed

help: getting id when there're no unique values in record.

2001-07-28 Thread Tom Gao
Hi guys.. I've been thinking on something for a little while and I need some advice. I am inserting several fields into a table, however there's an 'id' (id integer not null auto_increment) column that I use as the primary key. the problem lies in the fact that I want to get the 'id' that was

Text how many characters

2001-07-22 Thread Tom Gao
Hi just out of curiosity how man chars does the type 'text' have ? I can't seem to find it on the mysql manual. Thanks Tom

Force password

2001-07-15 Thread Tom Gao
Hi guys could someone tell me how I could force people to their enter password otherwise deny entry. I've looked through the mysql manual but I can't seem to find anything on this. your help is greatly appreciated. Tom

mysqladmin

2001-05-07 Thread Tom Gao
Hi guys I wanted to setup password for mysql access so I typed 'mysqladmin mypasswordhere' but now I have problems even doing mysqlshow because it requires a password. How do I disable the password ? thanks Tom