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] [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 10, 2003 3:14 PM To: [EMAIL PROTECTED] Subject: copy from table to it again i want to ask you a question i have a data in a table `answer` and i want to copy the data which have a specific value in a filed and inserted into it again but i will change the value i try to use this but it's give me an error === INSERT INTO `answer` ( `answer` , `correct`,`qid` ) SELECT a2.`answer` , a2.`correct` , 3 FROM `answer` as a2 where a2.qid=0 === -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[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:http://lists.mysql.com/[EMAIL PROTECTED]
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 file. It's also, if there is no WEBserver on that machine. So it's not MySql or PHP or Mac problem. Vaso -Original Message- From: Lost Idols [mailto:[EMAIL PROTECTED] Sent: Tuesday, December 09, 2003 5:15 PM To: [EMAIL PROTECTED] Subject: Asking again... please help me!!! I did ask this before, but haven't got any help yet. I'm trying this again... so please let me know if you know. Setting up MySQL and PHP on my Mac OS X 10.2 Just made it work... well, at least I now have a databse that I created and a table with two things inserted. I can also see them when I do a SELECT... So, since I know it's working, I started my DW MX to try to work from there, but I just get an error. I've been setting up the database with all the info and when I want to select from the list of databases I just get the following message: HTTP Error Code 404 File Not Found. Here are some possible reasons for the problem: 1) There is no testing server running on the server machine. What's wrong? Any clues here in this list? Staffan PS. I'm a newbie, so please write in newbie language ;-) _ Hitta rätt på nätet med MSN Sök http://search.msn.se/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
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 empty a table? Dear list: I apologize post this question, but I`m newbie with MySQL. I have a database called tacacs, it has many tables and one of them is called accounting. This table has many data stored since 2 month ago and it is very big and it increases frequently everyday. I`d like to know how can I dump (backup) the data from this table and left it empty periodically, because I have to do some queries from a Web UI? I`ll be very greateful if someone could give me some suggestions with this issue? Thank you, EDWIN LIMACHI N. DATACOM - Instalaciones Phone. 591-2-2123978 Movil: 591-715-29967 Fax: 591-2-2123975
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 error message: Data provider, or other service returned an E_FAIL status Can anybody explain me, how can i read all of my records from this recordset, instead of change all my columns to not null ??? Thx Vaso mysql desc test; +--+--+--+-+-+---+ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-+---+ | kerdezo | int(11) unsigned | | | 0 | | | instruk | smallint(6) unsigned | | | 0 | | | sorszam | smallint(6) unsigned | | | 0 | | | ev | smallint(6) unsigned | | | 0 | | | ho | smallint(6) unsigned | | | 0 | | | nap | smallint(6) | | | 0 | | | hanyperc | tinyint(4) unsigned | | | 0 | | | a1 | tinyint(4) unsigned | YES | | NULL| | | u1 | tinyint(4) unsigned | YES | | NULL| | | v6 | tinyint(4) unsigned | YES | | NULL| | | o1 | tinyint(4) unsigned | YES | | NULL| | | o2 | tinyint(4) unsigned | YES | | NULL| | | k4 | tinyint(4) unsigned | YES | | NULL| | | k5 | tinyint(4) unsigned | YES | | NULL| | | k6 | tinyint(4) unsigned | YES | | NULL| | | k7 | tinyint(4) unsigned | YES | | NULL| | | k8 | tinyint(4) unsigned | YES | | NULL| | | wave | tinyint(4) unsigned | | | 0 | | | testdemo | tinyint(4) unsigned | | | 0 | | +--+--+--+-+-+---+ 19 rows in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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: Structure copy... At 17:29 +0100 1/30/02, Vasoczki Ferenc wrote: 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 ? It's a 3.23 feature. If you know the solution please tell me that. Thx Vaso You may be able to use the output from mysqldump --no-data db_name tbl_name, which will produce the CREATE TABLE statement for the table. Do a substitution to change the name in the statement, then execute it. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 :) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 sent only to me to not disturb the list../ Vaso - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 (E-mail) Subject: Table Lock Hi, Is there a way to lock a table so that only one user can change it and then unlockit? I need to do this coz I want visitors to retrieve some values from a database but each value must be retrieved only by one user and then marked up to be expired, so I don't want two users to retrieve the same value Any suggestions Best Regards Hayan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
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 problem, I log in into mysql on my localhost I can select from and manually modify tables using insert select and delete, but I cannot do Grant. I typed the following command: GRANT ALL PRIVILEGES ON *.* TO root@localhost IDENTIFIED BY 'my password in here'; to this command the system responds: ERROR 1045: Access denied for user: 'root@localhost' (Using password: YES) I realize this command is redundant, but it proves my point. I am using a RedHat 7.2 server with RedHat kernel version 2.4.7 Any help would be greatly appreciated. Thanks Andrew Dumaresq Technician / Administrator Mathematics Computing Science Saint Mary's University Phone: (902)420-5893 Fax: (902)420-5035 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php