RE: copy from table to it again

I think, there is an error in your syntax. (i am not sure) After FROM, what do you want to call as a2 ?? INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` where a2.qid=0 Vaso -Original Message- From: [EMAIL PROTECTED]

mysql speed test

hi! i have 2 machines. both of them running mysql daemon. i want to check the speed difference, and i am looking for a method how can i do this ? is there an official tool for this thing ? Vaso -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

RE: Asking again... please help me!!!

HTTP 404 is an error code, when you try to reach a file, what is not exist. For example, if you have a webserver, http://mydomain.com and you have only an index.html nothing else, if you write http://mydomain.com/myfile.html then you will get this error, because myfile.html is not an existing

RE: How can I dump and empty a table?

Lets do this: mysqldump -u user -p [database_name] [tablename] ./thefilewhatyouwouldliketocreate.dmp Check that file. VAso -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:25 PM To: [EMAIL PROTECTED] Subject: How can I dump and

E_FAIL error.

Hi! I made a query like: str_q = desc mytable; calling ado, and writing to an excel sheet the Field, Type, Null, etc... Everithing is ok, while the rsADO.Movenext find a record, where the default value is NULL. /My Test table is below./ So, the first record like this is a1. At here i've got an

Structure copy...

Hi, i want to copy a table structure. I saw on the archive, there is a syntax like: create [newtable] select * from [sourcetable] where 1=2; This is not work on my MySQL server v.3.22 Is it a 3.23 feature, or am i do something wrong ? If you know the solution please tell me that. Thx Vaso

RE: Structure copy...

Yes, just i need to make it from code, and from a windows machine, so i cant use shell() or something like that... So i need to upgrade... Vaso -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: 2002. janur 30. 19:31 To: Vasoczki Ferenc; '[EMAIL PROTECTED]' Subject

RE: float/decimal ?

I need to store data like 12,213142124 where the decimal places can be 12. What column type should i use ? I tried float(4) but that is use only 2 decimal places, and i also tried decimal(12,12) but that is give me back 9. for 10,704704 ? vaso database,sql,query,table just to post :)

Storing word doc... 1000th..

I know this was in the list just i really can't found in the archive. I have about 20 tables, and every tables have a questionary in .doc format. I want to archive theese docs. How can i store theese doc files in table, and how can i get back in the same format what i stored ? Thx /replys can be

RE: Table Lock

Yes, i need this too but for a whole database. i just thought, if there is a power loss, and the database is get stuck, the users won't able to connect again ... Vaso -Original Message- From: Hayan Al Mamoun [mailto:[EMAIL PROTECTED]] Sent: 2002. janu?r 28. 9:48 To: MYSQL MAILING LIST

RE: Problem with Grant command

It's correct, just insert at the end of line: WITH GRANT OPTION; rtfm Vaso -Original Message- From: Andrew Dumaresq [mailto:[EMAIL PROTECTED]] Sent: 2002. janur 22. 19:31 To: [EMAIL PROTECTED] Subject: Problem with Grant command Hello, I have what I consider to be a very strange