RE: transitioning from ms sql
Hi, There is a white paper on that cery subject available at http://www.mysql.com/why-mysql/white-papers/mysql_wp_mssql2mysql.php -Original Message- From: Arjun Bhandari [mailto:[EMAIL PROTECTED] Sent: Wednesday, 27 September 2006 4:11 p.m. To: mysql@lists.mysql.com Subject: transitioning from ms sql Hi, I have been using MS SQL for the last one year, however would not like to transition to mysql. At the first glance it looks very different from ms sql and the tools are also different. can someone tell me if there is any document which explains the equivalence and how i could port a lot of my queries, tables, views and stored procedures to my sql from ms sql. Best Regards, Arjun ** This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. Any unauthorized use of the information contained in this email or its attachments is prohibited. If this email is received in error, please contact the sender and delete the material from your computer systems. Do not use, copy, or disclose the contents of this email or any attachments. Abu Dhabi Investment Authority (ADIA) accepts no responsibility for the content of this email to the extent that the same consists of statements and opinions made which are the senders own and not made on behalf of ADIA. Nor does ADIA accept any liability for any errors or omissions in the content of this email caused by electronic and technical failures. Although ADIA has taken reasonable precautions to ensure that no viruses are present in this email, ADIA accepts no responsibility for any loss or damage arising from the use of this email or its attachments. ** The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Question about LOTS of indexes on a table
If the combination of fields that will be subject to 'where' is unknown, and will be unknown forever, then I think you have no choice but to index each one individually and let MySQL make the choice as to which one to use. If, however, you know, or can establish, that certain combinations of 'f' will be used more often then others, then adding indices for those combination will be useful. If the table is read-intensive, then having multiple indices will improve performance (up to a point), but if its write-intensive, then adding indices will slow things down. HTH Quentin -Original Message- From: Peter Van Dijck [mailto:[EMAIL PROTECTED] Sent: Thursday, 21 September 2006 3:14 p.m. To: MYSQL General List Subject: Question about LOTS of indexes on a table Hi, I've been trying to figure this out for a while.. I have a table ITEMS with about 15 fields that can be used in any combination in where queries, let me call these fields f1 to f15. There are also 3 fields used for ordering, let's call them o1 to o3. So the table is: tablename (id, title, f1, f2, f3, f4, ..., f15, o1, o2, o3) f1 to f15 are all int(11). The table contains, let's say, 50,000 rows. The queries sent against this table can combine up to 4 f-fields, and 1 ordering field. So it could be: - SELECT * FROM table WHERE f3=x AND f7=x AND f12=x ORDER BY o3 DESC and so on.. you get the idea. The question is: we need indexes to make this go fast. How many indexes do we need? It doesn't seem like it would make sense to make an index for every possible combination... but there must be a way to do this intelligently? Any input is very welcome! I hope I explained the problem clearly? Thanks, Peter -- find videoblogs: http://mefeedia.com my blog: http://poorbuthappy.com/ease/ my job: http://petervandijck.net -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: how can I access to mysql fro moutside?
Does it mean the port 3306 is blocked? Not necessarily - it could mean that MySQL didn't respond as your telnet client expected (which is not surprising!). The Access denied for [EMAIL PROTECTED] message comes from the server, so there will be something wrong with your mysql.user or mysql.db tables that results in another entry being used before this one. Do a 'select user, host, password from user' and go through each entry in the order that they come out and see if another entry can match your login - the manual has a good section on how the MySQL server does this. As another tip, I've found that $ mysqladmin flush-privileges is more reliable than mysql FLUSH PRIVILEGES; I know that they should both result in the same thing, but my experience is not so. HTH Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 4:30 a.m. To: Praj Cc: mysql@lists.mysql.com Subject: Re: how can I access to mysql fro moutside? I can connect using Putty to the server using port 22. When I try to connect to the server using port 3306 and got Connection timed out? Does it mean the port 3306 is blocked? -afan U can chk firewall by doing a telnet to the remote host on 3306 ( default ) port . Error message looks like username/password might be wrong . [EMAIL PROTECTED] wrote: hi, I'm trying to access to mysql on dedicated web server (hosted by hosting company) using MySQL Administrator. Right now I'm getting error message 2003 (Can't connect to the server...). On users table I can see in user column 'root' and 'admin' as users and both have for host 'localhost' (root has tough localhost.localdomains too) After some googling I think I have to create a user (e.g. 'admin2') and grant: mysql GRANT ALL PRIVILEGES ON *.* TO 'admin2'@'123.123.123.%' - IDENTIFIED BY 'some_pass' WITH GRANT OPTION; (123.123.123.% means I'll access from IPs that start with 123.123.123 right?) mysql FLUSH PRIVILEGES; Is this all? Do I have to do something else? I do have to restart mysql server, right? Back to top: right now, when I try to access, I'm getting error message 2003. Since I didn't get error Access denied for [EMAIL PROTECTED], I think, even I have correct user/pass, someting else will stop me (firewall, 3306 is blocked,...), right? How can I check this? Thanks for any help. -afan -- 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] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SUM in WHERE
No, I don't think it is. I think you want to have a query that will return 'n' rows where the sum of Total is = 100 If your table is ID Total 1 10 2 20 3 30 4 40 5 50 it would return 1 10 2 20 3 30 4 40 (sum total = 100) but if your table was ID Total 1 100 2 20 3 30 4 40 5 50 it would return 1 100 only. Have I got it right. Using only SQL, your best bet would be a stored procedure, otherwise its really application logic to select the rows one at a time and keep a running total. HTH Quentin -Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 2:24 a.m. To: Price, Randall Cc: Edward Macnaghten; mysql@lists.mysql.com Subject: Re: SUM in WHERE Actually is this possible with simple SQL command in Mysql ? On 9/19/06, Price, Randall [EMAIL PROTECTED] wrote: I tried it also with 5.0.24-community-nt and it still didn't work! Randall Price Microsoft Implementation Group Secure Enterprise Computing Initiatives Virginia Tech Information Technology 1700 Pratt Drive Blacksburg, VA 24060 Email: [EMAIL PROTECTED] Phone: (540) 231-4396 -Original Message- From: Ahmad Al-Twaijiry [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:06 AM To: Edward Macnaghten Cc: mysql@lists.mysql.com Subject: Re: SUM in WHERE I tried it also with 4.1.21-log and still didn't work ! On 9/19/06, Ahmad Al-Twaijiry [EMAIL PROTECTED] wrote: I tried that before and it also doesn't work, is it because I'm using mysql version 4.1.19 ? On 9/19/06, Edward Macnaghten [EMAIL PROTECTED] wrote: Ahmad Al-Twaijiry wrote: Hi everyone snip SELECT * FROM tbl_name WHERE SUM(Total)=100 ORDER BY ID SELECT ID FROM tbl_name GROUP BY ID HAVING SUM(Total)=100 ORDER BY ID -- Ahmad Fahad AlTwaijiry -- Ahmad Fahad AlTwaijiry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- Ahmad Fahad AlTwaijiry -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: phpinfo() Client API version 3.23.49
Hi, The 3.23.49 is the version of the client that php is using. This may been what it was compiled with, or what it is getting from an external library. If it is compiled that way, you'll need a new compile of php including the newer client library. If its a runtime load, you may get away with replacing the .so or .dll file (I'm not sure). The 3.23 client will connect to the 4.1.1 server, but you may have to read up on the new password formats. HTH Quentin -Original Message- From: Muthu [mailto:[EMAIL PROTECTED] Sent: Wednesday, 20 September 2006 1:16 a.m. To: mysql@lists.mysql.com Subject: phpinfo() Client API version 3.23.49 Hi, I am using apache2.0+php4.3.4+mysql 4.1.1 in windows. If I type phpinfo(); , in mysql section it is coming as Client API version 3.23.49 . Is the installation correct?. Will the php connect to the mysql 4.1.1 server?. If i need to see Client API version 4.1.1 in mysql section, what should I do. Can someone help me on this. Thanks, Muthu. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Outputting text in a
If you are running a script from the command line, try mysql -BNe select 'some text to print' -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Friday, 25 August 2006 2:39 a.m. To: Wai-Sun Chia; Dan Buettner Cc: MySQL List Subject: Re: Outputting text in a You still get two lines, it's just that one of the lines is blank, and the other says, text to the screen. Jesse - Original Message - From: Wai-Sun Chia [EMAIL PROTECTED] To: Dan Buettner [EMAIL PROTECTED] Cc: Jesse [EMAIL PROTECTED]; MySQL List mysql@lists.mysql.com Sent: Thursday, August 24, 2006 2:14 AM Subject: Re: Outputting text in a On 8/24/06, Dan Buettner [EMAIL PROTECTED] wrote: Sure - in your sql script, put in SELECT text to the screen; Then you'll get 2 copies... Try this: SELECT text to the screen AS ''; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Group by base on latest time field, possible?
Try select thread, subject, max(time) from jos_sb_messages group by thread order by 3 -Original Message- From: The Nice Spider [mailto:[EMAIL PROTECTED] Sent: Thursday, 10 August 2006 4:10 p.m. To: mysql@lists.mysql.com Subject: Group by base on latest time field, possible? I want the group by result take the latest field, but my query result look like get the random row. Here I described: Thread SubjectTime - 5 Re:test 33 1155203794 5 test 33 1155203772 8 test 4441155203882 8 Re:test 444 1155203897 note: time field is INT(11) to store datetime in integer value QUERY - select thread, subject, time from jos_sb_messages group by thread order by time RESULT -- 5 Re:test 33 1155203794 8 test 4441155203882 What do I need is: -- 5 Re:test 33 1155203794 8 Re:test 4441155203897 I am using 3.23.58 for Windows. How to get the result as I expected? __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: select random ids from list
If you know the list of Ids, try select id, title from content where id in (100, 106, 109); If you want the list to be random, then you can use the RAND() function. Quentin -Original Message- From: kalin mintchev [mailto:[EMAIL PROTECTED] Sent: Tuesday, 1 August 2006 2:10 p.m. To: mysql@lists.mysql.com Subject: select random ids from list hi all... how can i do a query on a list of ids without doing individual queries for each one of them? something like: select id,title from content where id = 100,106,109; of course this doesn't work... is it possible somehow? thanks -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: change a empty value for 0
Isn't this over-complicated select id_ingenio, sum(cantidad) from ingenio, detalle_transaccion where ingenio.id_ingenio = detalle_transaccion.id_ingenio group by ingenio.id_ingenio or select id_ingenio, sum(cantidad) from ingenio left join detalle_transaccion on ingenio.id_ingenio = detalle_transaccion.id_ingenio group by ingenio.id_ingenio or select id_ingenio, sum(ifnull(cantidad,0)) from ingenio left join detalle_transaccion on ingenio.id_ingenio = detalle_transaccion.id_ingenio group by ingenio.id_ingenio or am I missing something? Quentin -Original Message- From: obed [mailto:[EMAIL PROTECTED] Sent: Wednesday, 26 July 2006 11:12 a.m. To: João Cândido de Souza Neto Cc: mysql@lists.mysql.com Subject: Re: change a empty value for 0 Hi. thanks ! but nop... SELECT id_ingenio,cantidad FROM detalle_transaccion WHERE cantidad IS NULL; Empty set (0.00 sec) and with coalesce nop :-( it's the same problem mysql select id_ingenio, (select case when sum( coalesce(cantidad,NULL) ) is null then 0 else sum(cantidad) end from detalle_transaccion where id_ingenio=ingenio.id_ingenio group by id_ingenio) as cantidad from ingenio LIMIT 5; ++--+ | id_ingenio | cantidad | ++--+ | 1 | NULL | | 2 | NULL | | 3 | NULL | | 4 | 2622.77 | | 5 | NULL | ++--+ 5 rows in set (0.00 sec) the problem is that my sub select returns a empty result, it isn't a null value, but somthing straing is happening if i make only the sub select look mysql select case when sum(cantidad) is null then 0 else sum(cantidad) end as a from detalle_transaccion where id_ingenio=1 group by id_ingenio; Empty set (0.00 sec) i think that the group by is doing this... becouse look select case when sum(cantidad) is null then 0 else sum(cantidad) end as a from detalle_transaccion where id_ingenio=1; +--+ | a| +--+ |0 | +--+ 1 row in set (0.01 sec) what can i do ? thanks -- http://www.obed.org.mx --- blog -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Searching through an alphabetical range
Hi, Tim's point is that you have someone with a last name of 'zebra', they won't be included in your results. Quentin -Original Message- From: Paul Nowosielski [mailto:[EMAIL PROTECTED] Sent: Saturday, 22 July 2006 7:19 a.m. To: mysql@lists.mysql.com Cc: Tim Lucia Subject: Re: Searching through an alphabetical range Its working fine for me: mysql SELECT DISTINCT email_address FROM mailing_list WHERE marketing_list LIKE 'Y' AND last_name = 'm' AND last_name = 'z'; 26371 rows in set (1.00 sec) Thank You, -- Paul Nowosielski Webmaster On Friday 21 July 2006 12:46, Tim Lucia wrote: Not quite... mysql select 'zebra' = 'm' AND 'zebra' = 'z'; +---+ | 'zebra' = 'm' AND 'zebra' = 'z' | +---+ | 0 | +---+ 1 row in set (0.00 sec) mysql select 'seal' = 'm' AND 'seal' = 'z'; +-+ | 'seal' = 'm' AND 'seal' = 'z' | +-+ | 1 | +-+ 1 row in set (0.00 sec) mysql 'zz' will probably do the trick, though. Tim -Original Message- From: Paul Nowosielski [mailto:[EMAIL PROTECTED] Sent: Friday, July 21, 2006 2:10 PM To: mysql@lists.mysql.com Subject: Re: Searching through an alphabetical range I have the solution: SELECT DISTINCT email_address FROM mailing_list WHERE last_name = 'm' AND last_name = 'z' Thank you, -- Paul Nowosielski Webmaster On Friday 21 July 2006 11:03, Paul Nowosielski wrote: Dear All, I need to write a query that searches last names between the ranges of m through z. Is there a way to do this in the query? Thank You, -- Paul Nowosielski Webmaster office: 303.440.0666 ext 219 cel: 303.827.4257 -- 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] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Backup questions
GVIM is a great transition from vi to more 'modern' (read slower and cumbersome!) editors. It allows all the normal vi commands, but also 'standard' Windoze features like Ctrl-C Ctrl-V for copy and paste, drag and drop selection etc. Like all good editors, it takes time to get the most out of it, but at least it is usable out of the box (unlike vi!) Another one I like is ConTEXT, from www.context.cx. Not sure if its got a max line length, though. Quentin -Original Message- From: Jesse [mailto:[EMAIL PROTECTED] Sent: Tuesday, 4 July 2006 8:44 a.m. To: mysql@lists.mysql.com Subject: Re: Backup questions There's GVIM for Windows, its the same program of Linux, I use it when there's no way but using Windows. Get it at www.vim.org ! Its a blast having the same (powerful, easy, fast and reliable) tool in windows and linux. But you'll find it kinda hard to learn at first, because of the command mode. If it's anything like the VI editor in Linux, then I don't even want to think about it. I've used the VI editor several times, and I HATE IT! VIM sounds like the same sort of thing if it's got a command mode. I've found a way to backup so that it wraps the lines correctly now, so I can use my old editor, which I'm used to. I may look into GVIM, though, just for grins-and-giggles. Thanks, Jesse -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Alter table command don't work
I don't think you can do it prior to 4.1: http://dev.mysql.com/doc/refman/4.1/en/charset-general.html MySQL 4.1 can do these things for you: * Store strings using a variety of character sets * Compare strings using a variety of collations * Mix strings with different character sets or collations in the same server, the same database, or even the same table * Allow specification of character set and collation at any level In these respects, not only is MySQL 4.1 far more flexible than MySQL 4.0, it also is far ahead of most other database management systems. However, to use these features effectively, you need to know what character sets and collations are available, how to change the defaults, and how they affect the behavior of string operators and functions. -Original Message- From: David Logan [mailto:[EMAIL PROTECTED] Sent: Monday, 19 June 2006 10:36 a.m. To: Graham Reeds Cc: mysql@lists.mysql.com Subject: Re: Alter table command don't work Graham Reeds wrote: Quentin Bennett wrote: http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name; That is the syntax I used. What about prior to 4.1.2? Perhaps it was not available? See http://www.dev.mysql.com/doc/refman/4.1/en/charset-table.htm You may have to dump the data and then reload into a new table with the correct charset. You may be able to copy it using an INSERT SELECT (not sure though, haven't had to do it) Regards -- David Logan South Australia when in trouble, or in doubt run in circles, scream and shout -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Re: Alter table command don't work
http://dev.mysql.com/doc/refman/4.1/en/alter-table.html From MySQL 4.1.2 on, if you want to change the table default character set and all character columns (CHAR, VARCHAR, TEXT) to a new character set, use a statement like this: ALTER TABLE tbl_name CONVERT TO CHARACTER SET charset_name; -Original Message- From: news [mailto:[EMAIL PROTECTED] Behalf Of Graham Reeds Sent: Monday, 19 June 2006 8:53 a.m. To: mysql@lists.mysql.com Subject: Re: Alter table command don't work Graham Reeds wrote: Using the text mode mysql client program I tried to alter a table - but received a syntax error. Why? This is using MySQL 4.0.25 btw. mysql alter table blog convert to character set utf8; ERROR 1064: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'convert to character set utf8' at line 1 G -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Unknown tables
but I assume you mean to check the information_schema database and the schemata table? No, Rich meant check the mysql data directory for a karate directory. MySQL databases (for MyISAM tables) are stored in their own directory, and each table is a set of 3 files, so its easy to check for file existance, permissions etc. I can't comment on InnoDB tables. Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Can I have multiple sockets?
AFAIK, no, you can't do that, but you can have multiple servers on one server, so long as they don't try and control the same data files. Each server could use a different socket. -Original Message- From: Patrick Ben Koetter [mailto:[EMAIL PROTECTED] Sent: Thursday, 15 June 2006 3:04 a.m. To: mysql@lists.mysql.com Subject: Can I have multiple sockets? I have an application (Postfix) I want to run chrooted. When I do run it chrooted it will not be able to see the MySQL UNIX domain socket at it's default location. (I could use a TCP socket, but I don't want to...) Is there a way I can tell MySQL to establish multiple sockets e.g. a socket per database or would I have to run several instances of a MySQL server giving each instance a different (socket) configuration? I tried to figure that out myself and read the manual etc. but I couldn't come up with an answer. Did I miss some documentation? Thanks, Patrick -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?
Most likely, MySQL has done a 'DELETE' followed by an 'INSERT' - i.e. two rows. Quentin -Original Message- From: Richard Dale [mailto:[EMAIL PROTECTED] Sent: Friday, 19 May 2006 11:23 a.m. To: mysql@lists.mysql.com Subject: INESRT ... ON DUPLICATE KEY - rows affected incorrect? Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables I have a table called which has a (combined) primary key of assetid and date plus several data fields (open, high, low, close - all doubles, and voume - a bigint). See the bottom of the email for the table definition. INSERT INTO price (assetid,date,open,high,low,close,volume) VALUES (202690,'2006-05-18','334.25','334.25','334.25','334.25','1') ON DUPLICATE KEY UPDATE open='334.25',high='334.25',low='334.25',close='334.25',volume='1'; The first time around, the insert works fine: Query OK, 1 row affected (0.03 sec); The second time around, when there should be neither an insert nor an update that affects any rows I get: Query OK, 2 rows affected (0.05 sec) To check that the update wasn't in fact updating any rows, I tried: UPDATE price SET open='334.25',high='334.25',low='334.25',close='334.25',volume='1' WHERE assetid=202690 AND date='2006-05-18'; Query OK, 0 rows affected (0.02 sec) Rows matched: 1 Changed: 0 Warnings: 0 So, it appears that the rows affected returned by an INSERT ... ON DUPLICATE KEY is incorrect. Can anyone else confirm that this is the correct behaviour? Thanks, Richard. - Table definition: CREATE TABLE `price` ( `assetid` int(11) NOT NULL default '0', `date` date NOT NULL default '-00-00', `open` double default NULL, `high` double default NULL, `low` double default NULL, `close` double default NULL, `volume` bigint(20) default NULL, PRIMARY KEY (`assetid`,`date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect?
Its not a problem with precision is it - 332.25 looks OK to you and me, but who knows what it looks like to the CPU? Maybe it sees one of the doubles as slightly different and updates? -Original Message- From: Richard Dale [mailto:[EMAIL PROTECTED] Sent: Friday, 19 May 2006 11:48 a.m. To: mysql@lists.mysql.com Subject: RE: INESRT ... ON DUPLICATE KEY - rows affected incorrect? Most likely, MySQL has done a 'DELETE' followed by an 'INSERT' - i.e. two rows. According to: http://dev.mysql.com/doc/refman/4.1/en/insert-on-duplicate.html The rows-affected value is 1 if the row is inserted as a new record and 2 if an existing record is updated. But what happens if the row is neither inserted nor updated? Right now it appears to returns '2'. I think it should return '0'. Cheers, Richard. -Original Message- From: Richard Dale [mailto:[EMAIL PROTECTED] Sent: Friday, 19 May 2006 11:23 a.m. To: mysql@lists.mysql.com Subject: INESRT ... ON DUPLICATE KEY - rows affected incorrect? Mysql 4.1.16 running on Fedora Core 4 (Linu) X86_64 with InnoDB tables I have a table called which has a (combined) primary key of assetid and date plus several data fields (open, high, low, close - all doubles, and voume - a bigint). See the bottom of the email for the table definition. INSERT INTO price (assetid,date,open,high,low,close,volume) VALUES (202690,'2006-05-18','334.25','334.25','334.25','334.25','1') ON DUPLICATE KEY UPDATE open='334.25',high='334.25',low='334.25',close='334.25',volume='1'; The first time around, the insert works fine: Query OK, 1 row affected (0.03 sec); The second time around, when there should be neither an insert nor an update that affects any rows I get: Query OK, 2 rows affected (0.05 sec) To check that the update wasn't in fact updating any rows, I tried: UPDATE price SET open='334.25',high='334.25',low='334.25',close='334.25',volume='1' WHERE assetid=202690 AND date='2006-05-18'; Query OK, 0 rows affected (0.02 sec) Rows matched: 1 Changed: 0 Warnings: 0 So, it appears that the rows affected returned by an INSERT ... ON DUPLICATE KEY is incorrect. Can anyone else confirm that this is the correct behaviour? Thanks, Richard. - Table definition: CREATE TABLE `price` ( `assetid` int(11) NOT NULL default '0', `date` date NOT NULL default '-00-00', `open` double default NULL, `high` double default NULL, `low` double default NULL, `close` double default NULL, `volume` bigint(20) default NULL, PRIMARY KEY (`assetid`,`date`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Need help with triggers
I've never written a trigger, but the error implies that you can't update the stores table when in a trigger ON the stores table. This makes sense, especially if you consider an 'UPDATE' trigger - the trigger would become recursive. So, rather than deciding which combination are recursive and which aren't, maybe there's a general rule that you can't change the table on which the trigger is placed? Hopefully someone will let you (and me) know if I don't know what I'm talking about! Quentin -Original Message- From: Daevid Vincent [mailto:[EMAIL PROTECTED] Sent: Tuesday, 16 May 2006 2:41 p.m. To: 'Martijn Tonies'; mysql@lists.mysql.com Subject: RE: Need help with triggers This is my first trigger I'm trying to write. I have two tables. 'stores' and 'zipcodes'. I want to automatically set the latitude and longitude of the store using it's zipcode lookup in the zipcode table. DELIMITER $$; DROP TRIGGER `store_coord`$$ create trigger `store_coord` BEFORE INSERT on `stores` for each row BEGIN UPDATE stores AS s, zipcodes AS z SET s.latitude = z.latitude, s.longitude = z.longitude WHERE s.zip = z.zip AND s.id = NEW.id; END; $$ First things first ... Updating a row that doesn't exist yet (BEFORE INSERT trigger) doesn't make sense :-) Why not simply adjust it like this: new.latitude := your looked up latitude new.longitude := your looked up longitude Given that it's a before insert, modifying the NEW.column values, these will be stored in the table. So when I do this: insert into `stores` (id, name, zip) values (10,'test company', 14526); I get this error Error Code : 1442 Can't update table 'stores' in stored function/trigger because it is already used by statement which invoked this stored function/trigger. I must not be doing something right, I've tried all these combinations and ALL give that same error message: DELIMITER $$; DROP TRIGGER `store_coord`$$ create trigger `store_coord` BEFORE INSERT on `stores` for each row BEGIN UPDATE stores AS s, zipcodes AS z SET NEW.latitude = z.latitude, NEW.longitude = z.longitude WHERE s.zip = z.zip AND s.id = NEW.id; END; $$ DELIMITER $$; DROP TRIGGER `store_coord`$$ create trigger `store_coord` BEFORE INSERT on `stores` for each row BEGIN UPDATE stores AS s, zipcodes AS z SET NEW.latitude := z.latitude, NEW.longitude := z.longitude WHERE s.zip = z.zip AND s.id = NEW.id; END; $$ DELIMITER $$; DROP TRIGGER `store_coord`$$ create trigger `store_coord` AFTER INSERT on `stores` for each row BEGIN UPDATE stores AS s, zipcodes AS z SET s.latitude = z.latitude, s.longitude = z.longitude WHERE s.zip = z.zip AND s.id = NEW.id; END; $$ What am I doing wrong? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: PRINT statement?
From Transact-SQL Help file: PRINT Returns a user-defined message to the client. Syntax PRINT 'any ASCII text' | @local_variable | @@FUNCTION | string_expr Arguments 'any ASCII text' Is a string of text. @local_variable Is a variable of any valid character data type. @local_variable must be char or varchar, or be able to be implicitly converted to those data types. @@FUNCTION Is a function that returns string results. @@FUNCTION must be char or varchar, or be able to be implicitly converted to those data types. string_expr Is an expression that returns a string. Can include concatenated literal values and variables. The message string can be up to 8,000 characters long; any characters after 8,000 are truncated. -Original Message- From: Rhino [mailto:[EMAIL PROTECTED] Sent: Thursday, 11 May 2006 3:51 p.m. To: Stephen Cook Cc: MySQL List Subject: Re: PRINT statement? I am not familiar with the PRINT command so I don't know what it does. I played with MS SQL Server once for a couple of days a few years back and that is the only contact I've ever had with SQL Server. If you can tell me what PRINT does, in detail, maybe I can suggest another alternative. -- Rhino - Original Message - From: Stephen Cook [EMAIL PROTECTED] To: Rhino [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Wednesday, May 10, 2006 8:09 PM Subject: Re: PRINT statement? I've started using the SELECT with no other clauses but I am still curious about a PRINT-like command. It is for SQL scripts. Rhino wrote: - Original Message - From: Stephen Cook [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Sunday, May 07, 2006 3:53 AM Subject: PRINT statement? Is there a statement similar to PRINT in T-SQL (MicroSoft SQL Server)? It would be handy to debug some scripts. If you're talking about a script that is running SQL, you can simply use the SELECT statement without any FROM, WHERE, ORDER BY, GROUP BY or HAVING clauses. For example: select Creating Foo table as Action; will produce the following output: +--+ | Action | +--+ | Creating Foo table | +--+ 1 row in set (0.00 sec) If you're talking about an OS script, you can use OS commands to display things. For example, I have some BASH scripts on our Linux server so I can use the BASH echo command, like this: #!/bin/bash report_date=`/bin/date` echo Report Date: $report_date; to produce this output: Report Date: Sun May 7 09:42:57 EDT 2006 -- Rhino -- No virus found in this incoming message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 09/05/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.392 / Virus Database: 268.5.5/335 - Release Date: 09/05/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: HELP --- Slow SP
The THEORY behind both statements is fine 1. Have a primary, single column integer index, auto incrementing (probably) for every record 2. Have a primary index that uniquely identifies your data. The advantage of 2 is that it is (usually) obvious what the unique characteristics of your data are, and so a natural PK emerges. The advantages of 1 are based on two premises: a. Indices are all about efficiency, and it the efficiency of comparing 4-byte integers is greater than the efficiency of comparing 51 characters of a combined key. b. Relationships need to be simple to allow point a. to work - if the author wishes, some time in the future, to create a relationship to this table, s/he has two choices - create the child table with a foreign key containing all three elements of the original primary key or add a new auto-increment primary key to his_msisdn_imei_activ_hist at that stage. If, at that time, the table is involved in a 24x7x52 system with 100s millions of records, then adding a new column and index may not be practical. So, if your system is a small, stable one and will remain that way, index efficiency is less of an issue, and the use of a 51-byte multi column index is not a problem. However, if you want to design in future proofing, get in to the habit of putting a single column integer, auto_increment primary key on every table (or at least considering doing so!) The speed of MySQL can lead to some bad habits that don't transfer well to other DBMS products, and good practice is good practice anywhere. Have an awesome day. Quentin P.S. 51 bytes assumes DATETIME is 8 bytes, but it may be 6? -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, 28 April 2006 8:56 p.m. To: mysql@lists.mysql.com Subject: Re: HELP --- Slow SP CREATE TABLE `his_msisdn_imei_activ_hist` ( `MSISDN` varchar(23) NOT NULL, `ACTIV_IMEI` varchar(20) NOT NULL, `ACTIV_PHONE_TYPE` varchar(100) NOT NULL, `PREV_IMEI` varchar(20) default NULL, `PREV_PHONE_TYPE` varchar(100) default NULL, `ACTIV_TIME` datetime NOT NULL, PRIMARY KEY (`MSISDN`,`ACTIV_IMEI`,`ACTIV_TIME`) ) ENGINE=InnoDB DEFAULT CHARSET=latin1; This primary key is a bad idea. A VERY VERY bad idea. For starters, a primary key should have ONE field, not THREE. While it is allowed, it's not going to help performance at all. Next is that the primary key Care for a fight over this one? :-) A primary key should be the primary key. If this is 3 columns, or 1 varchar column, it's all fine. I agree with your point of the ACTIV_TIME being a bad candidate for being part of a PK though. Oh, and having multiple columns in a PK does not mean you cannot create additional indices as/if required. All in all, your statement about multiple columns in a PK is a very very bad statement ;-) should be a numeric field. You've got varchars and datetimes! Yuck! If you want to enforce a rule such as restricting duplicate values, then start by creating yourself a sane primary key ( an unsigned int, for example ), and *THEN* put an index ( with your don't allow duplicates rule ) across your (`MSISDN`,`ACTIV_IMEI`,`ACTIV_TIME`) fields. Martijn Tonies Database Workbench - development tool for MySQL, and more! Upscene Productions http://www.upscene.com My thoughts: http://blog.upscene.com/martijn/ Database development questions? Check the forum! http://www.databasedevelopmentforum.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: HELP --- Slow SP
[snip] Next point is that MySQL will only make use of an index in a join or a where clause if ONLY that field is included in the index. If you pack 3 fields into an index and then try to join on ONLY ONE field, the index can't be used. So look at your joins and where clauses and make sure your indexes match. [\snip] I think that you can use the left most columns of the index, without including the remainder. So a join on MSISDN or MSIISDN and ACTIV_IMEI may use the index (depending on whatever else is going on) but a join on ACTIV_IMEI only or MSISDN and ACTIV_TIME won't. Quentin -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: HELP --- Slow SP
Hi Hardi, You may need to supply a bit more information - table formats, query string, output from EXPLAIN - to allow more detailed diagnosis. Quentin -Original Message- From: Hardi OK [mailto:[EMAIL PROTECTED] Sent: Friday, 28 April 2006 1:14 p.m. To: Daniel Kasak Cc: Quentin Bennett; mysql@lists.mysql.com Subject: Re: HELP --- Slow SP Hi, When I used the EXPLAIN command, i see that all of my query are using the correct index. That's why i was quite sure that index won't be the cause of my slow query problem. So, i now should alter the table: remove primary key and recreate index? Many thanks, Hardi On 4/28/06, Daniel Kasak [EMAIL PROTECTED] wrote: Quentin Bennett wrote: I think that you can use the left most columns of the index, without including the remainder. That's wasn't my understanding of how things work, but I've just checked the documentation, and it looks like you're right: docs MySQL cannot use a partial index if the columns do not form a leftmost prefix of the index. Suppose that you have the |SELECT| statements shown here: SELECT * FROM /|tbl_name|/ WHERE col1=/|val1|/; SELECT * FROM /|tbl_name|/ WHERE col1=/|val1|/ AND col2=/|val2|/; SELECT * FROM /|tbl_name|/ WHERE col2=/|val2|/; SELECT * FROM /|tbl_name|/ WHERE col2=/|val2|/ AND col3=/|val3|/; If an index exists on |(col1, col2, col3)|, only the first two queries use the index. The third and fourth queries do involve indexed columns, but |(col2)| and |(col2, col3)| are not leftmost prefixes of |(col1, col2, col3)|. /docs That's pretty strange. Anyway, what output do you get if you put 'explain ' in front of your queries? Are the indexes being used? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.
RE: WHERE doesn'r works
Hi Tom, Have you tried turning on the logging on the MySQL server, and seeing exactly what command the server is receiving - it may be different from the one (you think) you are sending. Quentin -Original Message- From: Tom Lobato [mailto:[EMAIL PROTECTED] Sent: Monday, 24 April 2006 5:00 a.m. To: mysql@lists.mysql.com Subject: Re: WHERE doesn'r works From: Jay Blanchard [EMAIL PROTECTED] Post the line of PHP where this query exists. Well, I think that show $result = mysql_query($command); won't help us, because the $command indeed begins to be constructed 120 lines before this. Only looking the code =( Tom -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Compiling 5.0.20 on Tru64
Hi, I'm trying to compile on Tru64 using the configure from the reference guide for using the HP/Compaq compiler (corrected for 'inline') CC=cc -pthread CFLAGS=-O4 -ansi_alias -ansi_args -fast -inline all -arch host CXX=cxx -pthread CXXFLAGS=-O4 -ansi_alias -ansi_args -fast -inline all \ -arch host -noexceptions -nortti export CC CFLAGS CXX CXXFLAGS ./configure \ --prefix=/usr/local/mysql \ --with-low-memory \ --enable-large-files \ --enable-shared=yes \ --with-named-thread-libs=-lpthread -lmach -lexc -lc However, when it comes time to link, 'ld' throws the error: /usr/bin/ld: -pthread: Unknown flag /usr/bin/ld: Usage: /usr/bin/ld [options] file [...] gmake[2]: *** [libz.la] Error 1 gmake[2]: Leaving directory `/data/src/mysql/mysql-5.0.20/zlib' gmake[1]: *** [all-recursive] Error 1 gmake[1]: Leaving directory `/data/src/mysql/mysql-5.0.20' gmake: *** [all] Error 2 I've tried moving the -pthread to CFLAGS with no effect. Has anybody gotten around this problem? Thanks in advance Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Tru64 cluster
Hi, Is MySQL Cluster Aware? Thanks Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.
FW: 2 SELECTS in 1
Hi, Can you use IF? SELECT iu.time as time, INET_NTOA(iu.ip) as ip, concat(usc.scheme,://,us.server,up.path, if(uq.query= ,,concat(?,uq.query))) as url,uc.category as HTH Quentin From: J S [mailto:[EMAIL PROTECTED] Sent: Tue 6/07/2004 8:22 a.m. To: [EMAIL PROTECTED] Subject: 2 SELECTS in 1 Hi, I have the following tables in my database for proxy logs. I have broken down the URL for each line into the following 4 tables: url_schemes e.g. http url_serverse.g. www.google.com url_paths e.g. /search url_queriese.g q=searchstring To get a list of the websites a user has surfed I run the following SQL: SELECT iu.time as time, INET_NTOA(iu.ip) as ip, concat(usc.scheme,://,us.server,up.path) as url,uc.category as category,ua.useragent as useragent FROM internet_usage iu INNER JOIN url_visit uv ON iu.urlid=uv.urlid INNER JOIN url_servers us ON us.id=uv.url_server_ID INNER JOIN url_paths up ON up.id=uv.url_path_ID INNER JOIN url_queries uq ON uq.id=uv.url_query_ID INNER JOIN url_schemes usc ON usc.id=uv.url_scheme_ID INNER JOIN url_categories uc ON uc.id=uv.url_category_ID INNER JOIN user_agents ua ON iu.useragent_ID=ua.ID WHERE iu.uid=u11 ORDER BY iu.time This works fine but the problem is that some URLs have queries so I need to do SELECT iu.time as time, INET_NTOA(iu.ip) as ip concat(usc.scheme,://,us.server,up.path) as url OR concat(usc.scheme,://,us.server,up.path,?,uq.query) as url, ua.useragent as useragent FROM WHERE iu.uid=u11 AND uq.query ; Can anyone tell me how to do this please? Or if this doesn't make sense, let me know and I'll send some more information. Thanks to the list as always. js. _ Want to block unwanted pop-ups? Download the free MSN Toolbar now! http://toolbar.msn.co.uk/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.
Problem Starting mysqld on Tru64
Hi, A previously stable of Ver 4.0.13-max for dec-osf5.1 on alphaev67 install on Tru64 today decided not to restart, with the error: 040705 9:31:52 Can't start server: Bind on TCP/IP port: Address already in use 040705 9:31:52 Do you already have another mysqld server running on port: 3306 ? 040705 9:31:52 Aborting The server was rebooted to ensure no stray processes were holding 3306 open. netstat -a showed nothing on that port. We changed the port to be 3307, and the server is working OK. Does anyone have any method for finding out why port 3306 would not bind. Quentin Bennett The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.
RE: mysql sql question
Hi,
You've already specified some values, so you can't then add a 'select' clause as well.
Try
mysql insert into dept (name,collegeid)
- select 'tom', id from test where name=sammy;
HTH
Quentin
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Monday, 5 July 2004 10:41 a.m.
To: 'Emmett Bishop'; [EMAIL PROTECTED]
Subject: RE: mysql sql question
i created the following as a simple test...
mysql describe test;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| name | char(20) | YES | MUL | NULL||
| id| int(10) | | PRI | NULL| auto_increment |
+---+--+--+-+-++
2 rows in set (0.00 sec)
mysql describe dept;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| name | char(20) | YES | MUL | NULL||
| collegeid | int(10) | YES | | NULL||
| nameid| int(10) | | PRI | NULL| auto_increment |
+---+--+--+-+-++
3 rows in set (0.00 sec)
mysql select * from test;
+++
| name | id |
+++
| sa | 1 |
| be | 2 |
| sam1ss | 3 |
| sammy | 4 |
+++
4 rows in set (0.00 sec)
mysql select * from dept;
Empty set (0.00 sec)
i tried...
mysql insert into dept (name,collegeid) values ('tom',test.id)
- select id from test where name=sammy;
and got the following error...
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'select id from test where name=sammy' at line 2
i've tried a number of different iterations.. any ideas as to why this
doesn't seem to work...
thanks
-bruce
ps. also, if i do/can manage to get this to work, shouldn't it be possible
to extend the basic approach to multiple tables, using FROM tbl1, tbl2,
tbl3..
-
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 3:26 PM
To: 'Emmett Bishop'; [EMAIL PROTECTED]
Subject: RE: mysql sql question
what you provided would almost do it... but i want to insert into the dog
table the name that i submit...
i'd like to do something like
if i submit dogname, ownername
insert into dog (name, ownerid) values ($dogname, owner.id)
select ownerid from owner where owner.name = $ownername;
-bruce
-Original Message-
From: Emmett Bishop [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: mysql sql question
Bruce,
what you want it the insert into ... select statement.
It's like this:
insert into dog (name, ownerid)
select name, ownerid from owner where ownerid = 8;
Does that sound like what you need?
-- Tripp
--- bruce [EMAIL PROTECTED] wrote:
hi...
i have two hypothetical tables
create table owner (
- name char(20) ,
- ownerid int(10) auto_increment primary key);
create table dog (
- name char(20) ,
- ownerid int(10),
- dogid int(10) auto_increment primary key);
i'm curious as to how i'd go about inserting a name
and the id of the owner,
in table dog, in a single sql statement.
something like this psuedo sql..
insert table (name, ownerid) values ($name,
$ownerid)
where owner.owner = owner
in other words, an app would supply the values for
the dog name, and the
owner. the sql would be able to derive the
ownerid for the owner from
the owner table, and then be able to insert the
ownerid, and dogname
into the dog table...
searching through google gets me to being able to
write a php/perl script
where i can do this using multiple sql statements..
but i'm trying to see
how to do it in a single statement...
any comments/criticisms would be helpful...
thanks...
-bruce
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
__
Do you Yahoo!?
New and Improved Yahoo! Mail - 100MB free storage!
http://promotions.yahoo.com/new_mail
--
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]
The information contained in this email is privileged and confidential and
intended for the addressee only. If you are not the intended recipient, you
are asked to respect that confidentiality and not disclose, copy or make use
of its contents. If received in error you are asked to destroy this email
and contact the
RE: mysql sql question
Hi,
The insert says 'insert data in to two columns, name and collegeid'.
The select says get two columns, 'tom' and id - 'tom' is a fixed value, the same for
each row, and id is taken from the test table.
If you want the name from test, then use
mysql insert into dept (name,collegeid)
- select name, id from test where name=sammy;
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Monday, 5 July 2004 10:50 a.m.
To: Quentin Bennett
Subject: RE: mysql sql question
i can't see how this would work at all...
unless you're saying the select will return tom and stuff that into the dept table
as the name value.
and where/how would the collegeid of the insert be derived from..
-bruce
-Original Message-
From: Quentin Bennett [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 3:41 PM
To: [EMAIL PROTECTED]; Emmett Bishop; [EMAIL PROTECTED]
Subject: RE: mysql sql question
Hi,
You've already specified some values, so you can't then add a 'select' clause as well.
Try
mysql insert into dept (name,collegeid)
- select 'tom', id from test where name=sammy;
HTH
Quentin
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Monday, 5 July 2004 10:41 a.m.
To: 'Emmett Bishop'; [EMAIL PROTECTED]
Subject: RE: mysql sql question
i created the following as a simple test...
mysql describe test;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| name | char(20) | YES | MUL | NULL||
| id| int(10) | | PRI | NULL| auto_increment |
+---+--+--+-+-++
2 rows in set (0.00 sec)
mysql describe dept;
+---+--+--+-+-++
| Field | Type | Null | Key | Default | Extra |
+---+--+--+-+-++
| name | char(20) | YES | MUL | NULL||
| collegeid | int(10) | YES | | NULL||
| nameid| int(10) | | PRI | NULL| auto_increment |
+---+--+--+-+-++
3 rows in set (0.00 sec)
mysql select * from test;
+++
| name | id |
+++
| sa | 1 |
| be | 2 |
| sam1ss | 3 |
| sammy | 4 |
+++
4 rows in set (0.00 sec)
mysql select * from dept;
Empty set (0.00 sec)
i tried...
mysql insert into dept (name,collegeid) values ('tom',test.id)
- select id from test where name=sammy;
and got the following error...
ERROR 1064: You have an error in your SQL syntax. Check the manual that
corresponds to your MySQL server version for the right syntax to use near
'select id from test where name=sammy' at line 2
i've tried a number of different iterations.. any ideas as to why this
doesn't seem to work...
thanks
-bruce
ps. also, if i do/can manage to get this to work, shouldn't it be possible
to extend the basic approach to multiple tables, using FROM tbl1, tbl2,
tbl3..
-
-Original Message-
From: bruce [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 3:26 PM
To: 'Emmett Bishop'; [EMAIL PROTECTED]
Subject: RE: mysql sql question
what you provided would almost do it... but i want to insert into the dog
table the name that i submit...
i'd like to do something like
if i submit dogname, ownername
insert into dog (name, ownerid) values ($dogname, owner.id)
select ownerid from owner where owner.name = $ownername;
-bruce
-Original Message-
From: Emmett Bishop [mailto:[EMAIL PROTECTED]
Sent: Sunday, July 04, 2004 12:59 PM
To: [EMAIL PROTECTED]
Subject: Re: mysql sql question
Bruce,
what you want it the insert into ... select statement.
It's like this:
insert into dog (name, ownerid)
select name, ownerid from owner where ownerid = 8;
Does that sound like what you need?
-- Tripp
--- bruce [EMAIL PROTECTED] wrote:
hi...
i have two hypothetical tables
create table owner (
- name char(20) ,
- ownerid int(10) auto_increment primary key);
create table dog (
- name char(20) ,
- ownerid int(10),
- dogid int(10) auto_increment primary key);
i'm curious as to how i'd go about inserting a name
and the id of the owner,
in table dog, in a single sql statement.
something like this psuedo sql..
insert table (name, ownerid) values ($name,
$ownerid)
where owner.owner = owner
in other words, an app would supply the values for
the dog name, and the
owner. the sql would be able to derive the
ownerid for the owner from
the owner table, and then be able to insert the
ownerid, and dogname
into the dog table...
searching through google gets me to being able to
write a php/perl script
where i can do this using multiple sql statements..
but i'm trying to see
how to do it in a single statement...
any comments
RE: Problem Starting mysqld on Tru64
Hi, Customer has found that port 3306 was open on another server in the cluster, and that seems to be what was causing it. Thanks for listening. Quentin -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED] Sent: Monday, 5 July 2004 9:52 a.m. To: MySQL (E-mail) Subject: Problem Starting mysqld on Tru64 Hi, A previously stable of Ver 4.0.13-max for dec-osf5.1 on alphaev67 install on Tru64 today decided not to restart, with the error: 040705 9:31:52 Can't start server: Bind on TCP/IP port: Address already in use 040705 9:31:52 Do you already have another mysqld server running on port: 3306 ? 040705 9:31:52 Aborting The server was rebooted to ensure no stray processes were holding 3306 open. netstat -a showed nothing on that port. We changed the port to be 3307, and the server is working OK. Does anyone have any method for finding out why port 3306 would not bind. Quentin Bennett The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Repeated table corruptions
Hi, Repost - its happened again. Anyone any ideas PLEASE! Hi, Advice on the cause of the following table corruption would be much appreciated. Some background: This customer has been running MySQL for 3 or more years, and, for back up purposes, shuts MySQL down each night, takes a snapshot of the tables for backup, and restarts. We have suffered a table corruption before, of the same table, when the table was an ISAM table under version 3.23.40. We have since upgraded to 4.0.13, and changed the table to MyISAM type. Searching the list archive for 'Wrong bytesec' on mysql.com returns no results. Google returns some, but mainly old ones. Maybe an appendix to the manual giving some information about the possible things that myisamchk can find/repair would be useful? Are there any known problems with shutting down and re-starting so regularly? Would a flush-tables followed by a check that there are no open tables achieve the same result. Is there a way of stopping new connections to a running server? mysql REPAIR TABLE tt_tickets_bck and # myisamchk -r tt_tickets_bck both fixed the issue, but I'm being asked why the corruption happened in the first place. Myisamchk -vvv resulted in 212424 lines of information. Thanks in advance Quentin Bennett # mysqladmin version mysqladmin Ver 8.40 Distrib 4.0.13, for dec-osf5.1 on alphaev67 (-- Binaries from mysql.com --) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.13-max-log Protocol version 10 Connection Localhost via UNIX socket UNIX socket /data/mysql/mysql.sock Uptime: 1 hour 21 min 23 sec Threads: 37 Questions: 42387 Slow queries: 16 Opens: 258 Flush tables: 2 Open tables: 113 Queries per second avg: 8.681 mysql check table tt_tickets_bck; ++---+--+--- + | Table | Op | Msg_type | Msg_text | ++---+--+--- + | mercury.tt_tickets_bck | check | warning | Table is marked as crashed | | mercury.tt_tickets_bck | check | warning | 2 clients is using or hasn't closed the table properly | | mercury.tt_tickets_bck | check | warning | Size of datafile is: 290516700 Should be: 285712092 | | mercury.tt_tickets_bck | check | error | Unexpected byte: 5 at link: 285506400 | | mercury.tt_tickets_bck | check | error | Corrupt | ++---+--+--- + 5 rows in set (58.28 sec) # myisamchk -vvv -r tt_tickets_bck - recovering (with sort) MyISAM-table 'tt_tickets_bck' Data records: 5641601 - Fixing index 1 - Searching for keys, allocating buffer for 46268 keys Wrong bytesec: 31- 0- 0 at 304; Skipped Wrong bytesec: 49- 55- 53 at 320; Skipped Wrong bytesec: 5- 87- 50 at 328; Skipped Wrong bytesec: 48- 53- 55 at 285506420; Skipped . . . Wrong bytesec: 4- 49- 53 at 692; Skipped Wrong bytesec: 5- 87- 50 at 700; Skipped Found block with impossible length 3289448 at 285506560; Skipped Wrong bytesec: 27- 0- 0 at 1080; Skipped Wrong bytesec: 56- 54- 48 at 1096; Skipped Wrong bytesec: 87- 50- 29 at 1108; Skipped . . . Wrong bytesec: 27- 0- 0 at 5080; Skipped Wrong bytesec: 53- 53- 55 at 5096; Skipped Wrong bytesec: 87- 50- 29 at 5108; Skipped Found block with too small length at 5116; Skipped Wrong bytesec: 27- 0- 0 at 5120; Skipped Wrong bytesec: 53- 53- 55 at 5136; Skipped . . . Wrong bytesec: 56- 50- 56 at 5762080; Skipped Wrong bytesec: 87- 50- 29 at 5762092; Skipped Delete link points outside datafile at 285512060 Wrong bytesec: 27- 0- 0 at 5762148; Skipped Wrong bytesec: 54- 57- 57 at 5762164; Skipped . . Wrong bytesec: 200- 3- 1 at 290516684; Skipped - Merging 5621599 keys - Last merge and dumping keys - Fixing index 2 - Searching for keys, allocating buffer for 139678 keys - Merging 5621599 keys - Last merge and dumping keys - Fixing index 3 - Searching for keys, allocating buffer for 104727 keys - Merging 5621599 keys - Last merge and dumping keys Data records: 5621599 # Quentin Bennett The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated.
RE: Repeated table corruptions
Hi, No problems there: 031113 1:18:33 /applic/mysql-max-4.0.13-dec-osf5.1-alphaev67/bin/mysqld: Normal shutdown 031113 1:18:34 InnoDB: Starting shutdown... 031113 1:18:36 InnoDB: Shutdown completed 031113 1:18:36 /applic/mysql-max-4.0.13-dec-osf5.1-alphaev67/bin/mysqld: Shutdown Complete 031113 01:18:37 mysqld ended Unix isn't being shutdown, only the Mysql Server program. Thanks Quentin Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Stephen Brownlow [mailto:[EMAIL PROTECTED] Sent: Thursday, 13 November 2003 3:11 p.m. To: Quentin Bennett; Dathan Vance Pattishall Cc: [EMAIL PROTECTED] Subject: Re: Repeated table corruptions Have a look at the MySQL server error log. It should show messages about Shutting down. If it does not report the shutdowns, Unix would just be killing it, and that could be causing, not solving the problems. MySQL shutdowns might not happen when Unix is shutdown, because sometimes the rc.d scripts are not installed or are wrong. Stephen - Original Message - From: Quentin Bennett [EMAIL PROTECTED] To: Dathan Vance Pattishall [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Thursday, November 13, 2003 7:17 AM Subject: RE: Repeated table corruptions Hi, Thanks - the tables were converted to MyISAM a while ago, and have run with no problem. Because they have been repaired before, following a previous crash, I believe that prior to the shut down last night all was well. I have run in to the issue of trying to repair a 'live' table, with subsequent disaster, but that is not the issue here - the issue is why does the table get corrupted in the first place. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Database corruption
Hi, Advice on the cause of the following table corruption would be much appreciated. Some background: This customer has been running MySQL for 3 or more years, and, for back up purposes, shuts MySQL down each night, takes a snapshot of the tables for backup, and restarts. We have sufferred a table corruption before, of the same table, when the table was an ISAM table under version 3.23.40. We have since upgraded to 4.0.13, and changed the table to MyISAM type. Searching the list archive for 'Wrong bytesec' on mysql.com returns no results. Google returns some, but mainly old ones. Maybe an appendix to the manual giving some information about the possible things that myisamchk can find/repair would be useful? Are there any known problems with shutting down and re-starting so regularly? Would a flush-tables followed by a check that there are no open tables achieve the same result. Is there a way of stopping new connections to a running server? mysql REPAIR TABLE tt_tickets_bck and # myisamchk -r tt_tickets_bck both fixed the issue, but I'm being asked why the corruption happened in the first place. Myisamchk -vvv resulted in 212424 lines of information. Thanks in advance Quentin Bennett # mysqladmin version mysqladmin Ver 8.40 Distrib 4.0.13, for dec-osf5.1 on alphaev67 (-- Binaries from mysql.com --) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.13-max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /data/mysql/mysql.sock Uptime: 1 hour 21 min 23 sec Threads: 37 Questions: 42387 Slow queries: 16 Opens: 258 Flush tables: 2 Open tables: 113 Queries per second avg: 8.681 mysql check table tt_tickets_bck; ++---+--+--- + | Table | Op| Msg_type | Msg_text | ++---+--+--- + | mercury.tt_tickets_bck | check | warning | Table is marked as crashed | | mercury.tt_tickets_bck | check | warning | 2 clients is using or hasn't closed the table properly| | mercury.tt_tickets_bck | check | warning | Size of datafile is: 290516700 Should be: 285712092 | | mercury.tt_tickets_bck | check | error| Unexpected byte: 5 at link: 285506400 | | mercury.tt_tickets_bck | check | error| Corrupt | ++---+--+--- + 5 rows in set (58.28 sec) # myisamchk -vvv -r tt_tickets_bck - recovering (with sort) MyISAM-table 'tt_tickets_bck' Data records: 5641601 - Fixing index 1 - Searching for keys, allocating buffer for 46268 keys Wrong bytesec: 31- 0- 0 at304; Skipped Wrong bytesec: 49- 55- 53 at320; Skipped Wrong bytesec: 5- 87- 50 at328; Skipped Wrong bytesec: 48- 53- 55 at 285506420; Skipped . . . Wrong bytesec: 4- 49- 53 at692; Skipped Wrong bytesec: 5- 87- 50 at700; Skipped Found block with impossible length 3289448 at 285506560; Skipped Wrong bytesec: 27- 0- 0 at 1080; Skipped Wrong bytesec: 56- 54- 48 at 1096; Skipped Wrong bytesec: 87- 50- 29 at 1108; Skipped . . . Wrong bytesec: 27- 0- 0 at 5080; Skipped Wrong bytesec: 53- 53- 55 at 5096; Skipped Wrong bytesec: 87- 50- 29 at 5108; Skipped Found block with too small length at 5116; Skipped Wrong bytesec: 27- 0- 0 at 5120; Skipped Wrong bytesec: 53- 53- 55 at 5136; Skipped . . . Wrong bytesec: 56- 50- 56 at5762080; Skipped Wrong bytesec: 87- 50- 29 at5762092; Skipped Delete link points outside datafile at 285512060 Wrong bytesec: 27- 0- 0 at5762148; Skipped Wrong bytesec: 54- 57- 57 at5762164; Skipped . . Wrong bytesec: 200- 3- 1 at 290516684; Skipped - Merging 5621599 keys - Last merge and dumping keys - Fixing index 2 - Searching for keys, allocating buffer for 139678 keys - Merging 5621599 keys - Last merge and dumping keys - Fixing index 3 - Searching for keys, allocating buffer for 104727 keys - Merging 5621599 keys - Last merge and dumping keys Data records: 5621599 # Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives
RE: Database corruption
Hi, Compaq Tru64 UNIX V5.1 (Rev. 732) so possibly not the same issue! Thanks Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Terence [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 September 2003 2:05 p.m. To: [EMAIL PROTECTED] Subject: Re: Database corruption We had the same problem when running on linux with the 2.4.18 kernel. Upgraded to the 2.4.20 and no problems since. Don't know if that's your problem, since you didnt mention kernel versions. Cheers Terence - Original Message - From: Quentin Bennett [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, September 25, 2003 6:21 AM Subject: Database corruption Hi, Advice on the cause of the following table corruption would be much appreciated. Some background: This customer has been running MySQL for 3 or more years, and, for back up purposes, shuts MySQL down each night, takes a snapshot of the tables for backup, and restarts. We have sufferred a table corruption before, of the same table, when the table was an ISAM table under version 3.23.40. We have since upgraded to 4.0.13, and changed the table to MyISAM type. Searching the list archive for 'Wrong bytesec' on mysql.com returns no results. Google returns some, but mainly old ones. Maybe an appendix to the manual giving some information about the possible things that myisamchk can find/repair would be useful? Are there any known problems with shutting down and re-starting so regularly? Would a flush-tables followed by a check that there are no open tables achieve the same result. Is there a way of stopping new connections to a running server? mysql REPAIR TABLE tt_tickets_bck and # myisamchk -r tt_tickets_bck both fixed the issue, but I'm being asked why the corruption happened in the first place. Myisamchk -vvv resulted in 212424 lines of information. Thanks in advance Quentin Bennett # mysqladmin version mysqladmin Ver 8.40 Distrib 4.0.13, for dec-osf5.1 on alphaev67 (-- Binaries from mysql.com --) Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 4.0.13-max-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /data/mysql/mysql.sock Uptime: 1 hour 21 min 23 sec Threads: 37 Questions: 42387 Slow queries: 16 Opens: 258 Flush tables: 2 Open tables: 113 Queries per second avg: 8.681 mysql check table tt_tickets_bck; ++---+--+- -- + | Table | Op| Msg_type | Msg_text | ++---+--+- -- + | mercury.tt_tickets_bck | check | warning | Table is marked as crashed | | mercury.tt_tickets_bck | check | warning | 2 clients is using or hasn't closed the table properly| | mercury.tt_tickets_bck | check | warning | Size of datafile is: 290516700 Should be: 285712092 | | mercury.tt_tickets_bck | check | error| Unexpected byte: 5 at link: 285506400 | | mercury.tt_tickets_bck | check | error| Corrupt | ++---+--+- -- + 5 rows in set (58.28 sec) # myisamchk -vvv -r tt_tickets_bck - recovering (with sort) MyISAM-table 'tt_tickets_bck' Data records: 5641601 - Fixing index 1 - Searching for keys, allocating buffer for 46268 keys Wrong bytesec: 31- 0- 0 at304; Skipped Wrong bytesec: 49- 55- 53 at320; Skipped Wrong bytesec: 5- 87- 50 at328; Skipped Wrong bytesec: 48- 53- 55 at 285506420; Skipped . . . Wrong bytesec: 4- 49- 53 at692; Skipped Wrong bytesec: 5- 87- 50 at700; Skipped Found block with impossible length 3289448 at 285506560; Skipped Wrong bytesec: 27- 0- 0 at 1080; Skipped Wrong bytesec: 56- 54- 48 at 1096; Skipped Wrong bytesec: 87- 50- 29 at 1108; Skipped . . . Wrong bytesec: 27- 0- 0 at 5080; Skipped Wrong bytesec: 53- 53- 55 at 5096; Skipped Wrong bytesec: 87- 50- 29 at 5108; Skipped Found block with too small length at 5116; Skipped Wrong bytesec: 27- 0- 0 at 5120; Skipped Wrong bytesec: 53- 53- 55 at 5136; Skipped . . . Wrong bytesec: 56- 50- 56 at5762080; Skipped Wrong bytesec: 87- 50- 29 at5762092; Skipped Delete link points outside datafile at 285512060 Wrong bytesec: 27- 0- 0 at5762148; Skipped Wrong bytesec: 54- 57- 57 at5762164; Skipped . . Wrong bytesec: 200- 3- 1
RE: auto increment
Hi, Check the behaviour of auto_increment in the change logs - it changed from using the highest available number to carrying on from where it left off some time ago, but I believe there is a was to reset it manually. Hope this helps. Quentin Bennett Senior Analyst Infinity Solutions Ltd PO Box 3323, Auckland Ph: 09 921 8146 Fx: 09 309 4142 www.infinitytransport.net -Original Message- From: Louie Miranda [mailto:[EMAIL PROTECTED] Sent: Thursday, 25 September 2003 2:58 p.m. To: [EMAIL PROTECTED] Subject: auto increment I have a id_entry field that is doing auto increment on that field. Now, when i try to delete the numbers it still continues to count from where it left. ex: i have entrys 1|one 2|two once i deleted 1|one on the field or even 2|two it still counts to 3|three and so on And is it also possible to change the values, to 2003-01 and so on.. Im tired just using the numbers from 1 and so on.. - Louie http://www.axishift.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql? [EMAIL PROTECTED] The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: command mysql -u $user without typing it - getting shafted and annoyed now.
Hi Again I just did this to check what you did: SKYROAD#mercury1:/mercury/home/quentin:mysql --user=mercury -p mysql Enter password: mysql grant all privileges on mysql.* to matt@%; Query OK, 0 rows affected (0.05 sec) mysql flush privileges; Query OK, 0 rows affected (0.19 sec) mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt mysql Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353315 to server version: 3.23.40-log mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt -p mysql Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353316 to server version: 3.23.40-log mysql quit Bye SKYROAD#mercury1:/mercury/home/quentin:mysql --user=matt -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 353317 to server version: 3.23.40-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql quit Bye As you can see, it all works fine - when prompted for a password, just pressing return lets me in. Can you post the results of: select user, name, host from user; It may help. Quentin -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 11:10 p.m. To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it - getting shafted and annoyed now. I must be going so wrong here. I deleted the users and started again. added 2 users dba and matt. Both of these have the host of % (connect from anything yes ?) I then do a grant all privileges on *.* to dba@% flush privileges and grant all privileges on *.* to matt@% flush privileges then mysql -u matt -p gives me ERROR 1045: Access denied for user: 'dba@localhost' (Using password: YES) and I am on the local host ??? what the hell is going on I thougth I understood and was getting somewhere. obviously not. Sorry to drag this up again. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread,
RE: 2 GB limit reached
Hi, I had this too - in the documentation, although maybe not highlighted enough, there are instructions for overcoming 4G - you have to set MAX_ROWS for you table to a 'large' number to tell mysqld to use 4 byte pointers for the file. Regards Quentin -Original Message- From: Chris Wilson [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 7:07 a.m. To: Johnny Withers Cc: [EMAIL PROTECTED] Subject: Re: 2 GB limit reached As I said in my message (although I've still not had time to look further into this) this will not solve your problem completely. My 2.4.17 testbox will happily create 4gig flies - but as soon as my mysql myisam table reached 4gig I got a Table full error when trying to insert. Going InnoDB is probably the best solution, from what I've seen so far - will mysql switch to make that the default table type at some point in the future? Enable large file support: [root@xxx array0]# du -h bigfile 2.9Gbigfile [root@xxx array0]# ls -al bigfile -rw-rw-r--1 root root 30 Jan 9 11:06 bigfile [root@xxx array0]# uname -a Linux [hidden] 2.4.8 #3 SMP Tue Aug 14 09:47:47 CDT 2001 i686 unknown - Johnny Withers [EMAIL PROTECTED] p. 601.853.0211 c. 601.209.4985 -Original Message- From: Dennis [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 10:52 AM To: [EMAIL PROTECTED] Subject: Re: 2 GB limit reached At 11:26 PM 01/08/2002, you wrote: On Tue, Jan 08, 2002 at 08:03:07PM -0500, Dennis wrote: At 07:07 PM 01/08/2002, you wrote: Dennis, You may want to look into using InnoDB tables. I believe InnoDB tables are immune to the 2gb limit (which usually comes from the filesystem). Also, InnoDB claims that the innodb tables are faster than MyISAM tables in some cases. See www.innodb.com or http://www.mysql.com/doc/I/n/InnoDB_overview.html for further detail. thanks, but that doesnt tell me how to recover THIS filethe right answer is use a different OS, but thats out of my control here. Can you at least mysqldump the data out to a file? No, but that might be cumbersome with 4 million records. :-) db - 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 -- Chris Wilson [EMAIL PROTECTED] http://www.wapmx.com - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: MYSQL : XML storage
Hi, MySQL, being a relational database (quiet, you guys from other camps), is good at storing relational data. To store purely XML data, you may be better off using an XML database e.g. Tomino from Software AG. The line is a fine one, though. If your XML is purely a representation of relational data, you may like to look at mysql -X in the latest client, which, I believe, will produce the results in XML - I haven't tried this. Regards Quentin -Original Message- From: Clive Bredenkamp [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 2:52 a.m. To: '[EMAIL PROTECTED]' Subject: MYSQL : XML storage Hi All, I have about 15GB of xml files each ranging from about 400bytes to 4k (some exceptions being up to a few MB, but mainly small), and am planning to stick these files in a database for better mainteance. Does anyone have advice on the best way in which to import so many files or any advice on storage structure. Thanks, Clive. CLIVE BREDENKAMP IT Dev Consultant L@wyers Access Web (031) 502 7630 082 3223 988 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Error 13
Hi Error 13 is from the OS - nothing to do with locks or whatever. However, when you add a new field (or change the table structure in (nearly) any way), mysqld will create a temporary table in the database directory - are you sure that the permissions on the directory are correct? Remember, it is the user running mysqld that needs the permissions, not the user running the command. HTH Quentin -Original Message- From: P.Agenbag [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 6:14 a.m. To: mysql Subject: Error 13 Hi I have a table that I want to add a new field to while running on the server, however, when I try to add a new field, it comes up with the error13 message, saying it doesn't have permission, yet the files and folder are all chmod 777. Can it be due to the fact that there is a permanent connection to this table from another server and that mysql is preventing any major changes? Should I just try to make a copy of the table and make the changes to it and then overwrite the old one? Is there a cleaner way of managing your tables and to make changes without having to resort to this manual way? Thanks - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: command mysql -u $user without typing it ????
Are you doing 'flush privileges' are documented? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Thursday, 10 January 2002 8:26 a.m. To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it query ok I would expect to see, but no rows affected ??? this must mean it has not altered the database at all ?? I created a 2 new users, dba and matt I did grant all privileges to *.* to dba@% I cannot conntect from anything host as dba. I then did grant all privileges to *.* to matt@jaguar.no-dns.co.uk (my laptop) I got the no rows affected message and I cannot connect from the machine jaguar. something must be wrong. I used stand the pricinpals of the grant command but I cannot understand why no rows are affected. It does not surprise me that I cannot connect when no rows are affected. any other suggestions. Thanks for going into detail on this I am learning. Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:57 To: '[EMAIL PROTECTED]'; Ho, Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it The Query OK, 0 rows affected indicate that the user table is updated so test2 on localhost can access the mysql databases. Do you still get the access is denyed for user @localhostto database mysql message? -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:51 AM To: Ho Kam; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it tired that but I am getting Query OK, 0 rows affected (0.00 sec) don't understand why it is not granting to the user ? Matt. -Original Message- From: Ho, Kam [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 16:10 To: '[EMAIL PROTECTED]'; Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it Try this: mysql grant all privileges on *.* to test2@localhost also read manual about the grant command. -Original Message- From: Matthew Darcy [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 09, 2002 11:04 AM To: Gerald Clark Cc: MySql List Subject: RE: command mysql -u $user without typing it I read similar notes on this in the manual, saying that invoking mysql without the username will try to take the unix username if it exists in the database. I tried this with test2, it opened an mysql session no problem, but when I did a connect mysql it said access is denyed for user @localhostto database mysql to me this looks like it is trying to connect with no user instead of test2@localhost can you explain this ? Thanks, Matt. -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: 09 January 2002 15:56 To: [EMAIL PROTECTED] Cc: MySql List Subject: Re: command mysql -u $user without typing it Matthew Darcy wrote: I have 3 UNIX users on my server. test1, test2, and test3. I have created 3 users for mysql test1, test2, and test3 (shock horror) If I want to connect to the database as root then I understand I must do mysql -u root -p but I would like test1 2 and 3 to be able to type mysql and be either logged in as their unix username, ie test2 types mysql and connects to the database as test2 (mysql account) or at least be prompted for the password for test2. The only way I can think of doing this is by setting up an alias ie alias mysql_connect=`mysql -u $username -p` there must be some sort of autologin from username like in oracle. Thanks, Matt. The user defaults to the unix user. You can put a .my.cnf file in their home directory with [client] password=whatever to make it even easier. - 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 - 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)
RE: Replication and thread priority
Hi, I don't think that you are missing anything. If there is a select in progress, then an insert will block until it has been completed. If there are several selects pending, then the insert will take its place in the queue, unless you are using low-priority-updates, in which case is will wait until all selects have been completed (including ones that haven't arrived yet, but arrive whilst another select is already processing). I don't _think_ that there is an option to make inserts higher priority than selects. InnoDB tables may be better for you, if the delay in inserting is causing problems. Regards Quentin -Original Message- From: James Montebello [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 9 January 2002 1:49 p.m. To: [EMAIL PROTECTED] Subject: Replication and thread priority We have a box that is primarily read at a rate high enough that a particular table has a SELECT outstanding about 99.9% of time 24x7. This box is set up as a replication slave, and the table in question is replicated from another box. It appears as though the slave thread doing the writes has a lower priority than threads doing reads. I see the slave thread in the process list blocked for long periods of time (hours), waiting for access to this one busy table. I can't see any config option (except perhaps --skip-thread-priority) that would alleviate this problem. I'm not even certain this is the actual problem at this point, since the docs are unclear about the relative priority of the slave thread. Empirically, it appears to be lower, but I'd like some confirmation if anyone can offer any. It certainly makes sense that the slave thread would be lower priority than any other thread, except in cases like this, where it would be better for the slave thread to have the same priority as non-slave writes (i.e., higher than reads). Is there some option I'm overlooking? james montebello - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
MySQLd Crash
Hi, Doing a mysqldump of a large table to /tmp, I filled up /tmp, which caused mysqld to reset. This is while using 3.23.40 on Solaris 2.6 What additional information should I provide to help address this problem? From: Quentin Bennett To: [EMAIL PROTECTED] Subject: [Mysql crash] Description: Crash with full /tmp How-To-Repeat: Fill up /tmp and allow mysqld to continue running Fix: Don't fill up /tmp Submitter-Id: submitter ID Originator:Mercury Admin Organization: Infinity Solutions MySQL support: [none at the moment Synopsis: mysqld crash on full /tmp Severity: critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.40 (Source distribution) Server: /usr/local/mysql/bin/mysqladmin Ver 8.21 Distrib 3.23.40, for pc-solaris2.6 on i386 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.40-log Protocol version10 Connection Localhost via UNIX socket UNIX socket /tmp/mysql.sock Uptime: 8 min 51 sec Threads: 29 Questions: 5332 Slow queries: 1 Opens: 42 Flush tables: 1 Open tables: 36 Queries per second avg: 10.041 Environment: machine, os, target, libraries (multiple lines) System: SunOS AKLDB 5.8 Generic_108529-03 i86pc i386 i86pc Architecture: i86pc Some paths: /usr/bin/perl Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /lib/libc.so.1 -rw-r--r-- 1 root bin 1574456 Jul 21 2000 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 28 14:48 /usr/lib/libc.so - ./libc.so.1 -rwxr-xr-x 1 root bin 933380 Jul 21 2000 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --with-innodb Perl: This is perl, version 5.005_03 built for i86pc-solaris The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: load data local infile
Hi, Not quite sure what you mean, but you can use load data infile 'file' into table mytab (col1, col3, col2) to specify in to which columns the data should go. HTH Quentin -Original Message- From: Douglas Potter [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 12:27 p.m. To: [EMAIL PROTECTED] Subject: load data local infile I want to set a field for all of the records I import while importing using load data local infile. The field is not specified in the file I am importing. Is there a way to do it? Mysql database importing tab delimited file. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Command Line Editing Mode
Hi, Using the mysql CLI, I have discovered that ESC-Return Return will put the CLI editor in to 'vi' mode, and allow me to use my 'normal' ksh editing keys, available in ksh after set -o vi. Because I am more familiar with the vi editing keys, and they are more powerful than the standard MySQL CLI keys (including the ability to search through the history), I would prefer to use these all the time without having to remember the Esc Return Return sequence. Is there a way of doing this, or is this an un-documented feature? 3.23.40 on Solaris 2.6 x86 Thanks Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: 3.23.47 compile problems with sun's forte compiler
Hi, From the cc(1) man page for Forte Developer 6.2 These predefinitions are valid in all modes: __sun __unix __SUNPRO_C=0x530 __`uname -s`_`uname -r` __sparc (SPARC) __sparcv9 (SPARC with -xarch=v9|v9a) __i386 (x86) __BUILTIN_VA_ARG_INCR __SVR4 __SUNPRO_C looks like it might be a good one to try for. Version 5.2 had __SUNPRO_C=0x500 HTH Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 4 January 2002 3:31 p.m. To: Shakeel Sorathia Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: 3.23.47 compile problems with sun's forte compiler Hi! Shakeel == Shakeel Sorathia [EMAIL PROTECTED] writes: Shakeel Thanks for the help on this, it seems to be working now. One question Shakeel though, wouldn't configure be able to take of this? The problem is that as I don't have access to a Forte compiler, so I haven't been able patch configure to detect this case.. Do you know if Forte defines some unique define we can trigger on ? Regards, Monty -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland ___/ www.mysql.com - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: configure problems on Solaris 2.6
A link from .a.2.10.0 to just '.a'?
so that e.g.
{root}blinky:~ ls -l /usr/local/lib/libstdc++.a
-rw-r--r-- 1 root root 2153936 Dec 30 16:57
/usr/local/lib/libstdc++.a - libstdc++.a.2.10.0{root}blinky:~ ls -l
/usr/local/lib/libstdc++.a.2.10.0
-rw-r--r-- 1 root root 2153936 Dec 30 16:57
/usr/local/lib/libstdc++.a.2.10.0
-Original Message-
From: Fil Krohnengold [mailto:[EMAIL PROTECTED]]
Sent: Thursday, 3 January 2002 11:17 a.m.
To: [EMAIL PROTECTED]
Subject: configure problems on Solaris 2.6
configure:1592: checking whether the C++ compiler (c++ ) works
configure:1608: c++ -o conftest conftest.C 15
ld: fatal: library -lstdc++: not found
ld: fatal: File processing errors. No output written to conftest
{root}blinky:~ ls -l /usr/local/lib/libstdc++.a.2.10.0
-rw-r--r-- 1 root root 2153936 Dec 30 16:57
/usr/local/lib/libstdc++.a.2.10.0
{root}blinky:~
{root}blinky:/usr/local/src/mysql-3.23.47 export | grep LD
declare -x LD_LIBRARY_PATH=/usr/local/lib:/usr/lib
{root}blinky:/usr/local/src/mysql-3.23.47
What am I missing?
__
fil krohnengold
network systems administrator
american museum of natural history
[EMAIL PROTECTED]
-
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
-
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
Windows 95 winsock version
Hi, From the manual: Note that if you are using an old Win95 release (for example OSR2), it's likely that you have an old Winsock package; MySQL requires Winsock 2! You can get the newest Winsock from http://www.microsoft.com/. Win98 has the new Winsock 2 library, so the above doesn't apply for Win98. Can anyone provide a more definitive link for the upgrade, and also how to establish if a win 95 PC is running winsock 1, 2 or whatever. TIA. Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: mysql.sock??
Hi, mysqld will create it when it runs - have you started the server? Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 December 2001 2:07 p.m. To: [EMAIL PROTECTED] Subject: mysql.sock?? I just recently installed MySQL from source. Trying to set the root password and keep getting this error: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! How do I create mysql.sock? Thanks, Mike - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: mysql.sock??
Error 13 is permission denied - check the permissions of host.frm. The user running mysqld must be able to read/write to it. Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 December 2001 4:02 p.m. To: Cal Evans Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: mysql.sock?? yup -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 6:05 PM To: [EMAIL PROTECTED] Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: mysql.sock?? did you run install_db before trying to fire it up? On Wed, 2001-12-19 at 21:52, Mike Blain wrote: error file says: 011219 18:24:58 mysqld started 011219 18:24:58 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011219 18:24:58 mysqld ended -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:50 PM To: [EMAIL PROTECTED] Cc: Quentin Bennett; [EMAIL PROTECTED] Subject: RE: mysql.sock?? Check your error log. What does it say? There is a reason that it won't start. Cal On Wed, 2001-12-19 at 21:19, Mike Blain wrote: I keep trying to start it and get this: [root@linuxdev1 mysql-3.23.46]# /usr/local/mysql/bin/safe_mysqld --user=mysql [1] 1822 [root@linuxdev1 mysql-3.23.46]# Starting mysqld daemon with databases from /usr/local/mysql/var 011219 18:21:40 mysqld ended It stats and immediately stops. Been combing forums and install instructions for info on this and haven't had much luck. keep trying this to no avail as well: [root@linuxdev1 mysql-3.23.46]# /etc/init.d/mysqld start bash: /etc/init.d/mysqld: No such file or directory -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 19, 2001 5:44 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: mysql.sock?? Hi, mysqld will create it when it runs - have you started the server? Quentin -Original Message- From: Mike Blain [mailto:[EMAIL PROTECTED]] Sent: Thursday, 20 December 2001 2:07 p.m. To: [EMAIL PROTECTED] Subject: mysql.sock?? I just recently installed MySQL from source. Trying to set the root password and keep getting this error: /usr/local/mysql/bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! How do I create mysql.sock? Thanks, Mike - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 -- * * Cal Evans * Techno-Mage * http://www.calevans.com * - 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 -- * * Cal Evans * Techno-Mage * http://www.calevans.com * The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender
RE: Default 1 == Default 16777216?
For those that silently follow these more unusual threads, what was the cause? Quentin -Original Message- From: Michael Widenius [mailto:[EMAIL PROTECTED]] Sent: Friday, 14 December 2001 8:07 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216? Hi! Sinisa == Sinisa Milivojevic [EMAIL PROTECTED] writes: Sinisa Philip Molter writes: Yeah, let me amend this. It's not happening with MyISAM tables, only with InnoDB tables, and it is happening with the pre-compiled binaries from the web site. It's definitely an endian issue. cut Sinisa Thanks for your bug report. Sinisa Now that you have cleared out that this is not happening with MyISAM, Sinisa it will be easier for us to fix it. I have now fixed this; It will be in MySQL 3.23.47 and 4.0.1. Thanks! Regards, Monty - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Anti-SPAM (was: A News Group Perhaps)
Hi, The TurboPower new groups (news://news.turbopower.com) seem to work fine, with little spam. Because they host the news groups themselves, there is no problem with them not being hosted by a particular ISP. It would be really nice to have a new group, but the ground has been covered so many times before, it obviously isn't going to happen. m2cw QB -Original Message- From: Thrill [mailto:[EMAIL PROTECTED]] Sent: Thursday, 13 December 2001 2:39 a.m. To: [EMAIL PROTECTED] Subject: Re: Anti-SPAM (was: A News Group Perhaps) On Wed, 2001-12-12 at 06:49, Carl Troein wrote: Tony Buckley writes: I am not a great fan of Newsgroups - they get spammed too much and messages get lost or archived. Some ISPs carry them, some don't. All too hit and miss for a resource on which I rely and am very grateful for. I agree, but sadly enough the spam part is true for this list as well. I completely agree with whomever proposed to have this list modified to accept mails from subscribed people only An alternative that has just been implemented on the PHP lists is to keep an approved list of addresses in addition to a subscribed list. If mail is sent from either approved or subscribed addresses, then it is sent on to the list. Otherwise, an automated reply is sent to the sending address that requires a reply to allow the post to go through - this eliminates 99%+ of spam I'd bet - at least from examining my Shred folder (I file the, uh, stuff there and feed it to an anti-spam system called Razor once a day). Anyway, if a reply is made to the automated message, then the address is added to the approve pile for future posts. Billy -- database,sql,query,table - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Feature Requests
Hi, I would like to request the addition of the following features to the command line client: Shell escape mysql !rm /tmp/data.txt mysql select col into outfile '/tmp/data.txt' from table; The command is run on the client. It would all SQL scripts to be run more simply that constructing a shell script with the same function. Maybe there would need to be an extra user permission to avoid abuse (like FILE)? Because the command is run on the client, this leads to the second feature request: mysql select col into local outfile '/tmp/data.txt' from table Before submitting to the server, the client checks, with the server, that the user has FILE privileges, and that the user has OS level permission to create the file. The results of the query are then put in to the file in the same format as they would have been in the existing select .. into outfile command - if that is too difficult, because the client then needs all the separator and terminator options, then simply tab separated using the platform's standard end of line would be fine for me! Would these options prove useful to others? Regards Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Default 1 == Default 16777216 ?
Hi, The output of mysqlbug might be useful, so we can see what platform etc you are on. Quentin -Original Message- From: Philip Molter [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 9:08 a.m. To: Nathan Cc: [EMAIL PROTECTED] Subject: Re: Default 1 == Default 16777216 ? On Mon, Dec 10, 2001 at 02:55:04PM -0700, Nathan wrote: : Dave Burgess had a good suggestion; I suppose you could specify the default in hex... : (default = 0x1) - as long as this is NOT in quotes it will input the hex value 1. I compiled a 3.23.46 last night and I have the same problem. I tried using 0x1, and the default is still set to 16777216 (and values get input with that value as well). Can anyone else verify that this is the case? I'm seeing it both with MyISAM tables and InnoDB tables, so I doubt it's a table handler. * Philip Molter * Texas.net Internet * http://www.texas.net/ * [EMAIL PROTECTED] - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 in using in keyword
Hi, It would help if you can post the statement and the error message that you get. Regards Quentin -Original Message- From: TH Leung [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 12 December 2001 4:26 p.m. To: '[EMAIL PROTECTED]' Subject: Problem in using in keyword Hi, I use the MySQLManager and enter a SQL statement with a in keyword, but an error message of syntax error occurs, I verify the SQL by plugging it to MS SQL Server 2000, it works without error, so I would like to know if the in keyword only functions on the Linux platform but not on the Windows platform? The MySQL version I am now using is 4.0-Max alpha and the MyODBC version is 2.5. Moreover, currently I come across another problem of using MySQL on Windows platform. The MySQL database contains several tables which have Chinese (BIG5) characters as data value, and I have constructed some programs in PowerBuilder to capture these Chinese data. The programs seem function normally and the data is really captured into the tables. However, when I try to use the mysqlcheck or myisamchk on these tables, a message saying that the XXX.MYD needs to be recreate is appeared. I think the indexes of these tables are corrupted. So, do you have any experiences that can share with me in capturing Chinese data? Thank you very much for your help. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: running MySQL on WinXP
Hi, You need to be running the server (mysqld.exe) before you can connect to it from the command line. 10061 means that the TCP/IP service cannot be contacted, either because the IP address isn't correct or that there is no service on the requested port. HTH Quentin -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 11:49 a.m. To: G r e g L a w r i e Cc: MySQL List Subject: Re: running MySQL on WinXP I have installed the necessary MySQL files onto the hard drive (under the folders inetpub -- wwwroot -- mysql. Next, I set up a cnf file and called it my.cnf with the path C:\Inetpub\wwwroot\mysql in it. Then, using the command prompt, I keyed in the path to the mysql directory and keyed in mysql.exe. The error I get is: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) I've tried this with my firewall (giving permission to MySQL and without it. Both have resulted in the same error message. Any ideas? -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - Original Message - From: G r e g L a w r i e To: Curt Kliewer ; MySQL List Sent: Sunday, December 09, 2001 1:04 PM Subject: RE: running MySQL on WinXP Haven't tried it myself, but can't see why it shouldn't. How about you try telling us the process you have been through so far and any messages / errors that you may be getting. -Original Message- From: Curt Kliewer [mailto:[EMAIL PROTECTED]] Sent: Monday, 10 December 2001 5:16 To: MySQL List Subject: running MySQL on WinXP Hi. I am new to PHP/MySQL and this list. Can I run MySQL on WinXP? I haven't been able to get it to work so far. Any help would be appreciated. -- Best regards, Curt Kliewer ** ** Sol Interactive Development Applications Programmer/Analyst Internet Solutions/Server-Side Programmer ** ** Contact Information: ICQ:1835597 MSN Messenger: [EMAIL PROTECTED] Email:[EMAIL PROTECTED] Website: http://www.sol-interactive.com ** ** - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Creating MySQL table w/2 primary keys
Hi, That may have the desired effect of two unique keys, but you stil only have one primary key (probably id1,id2). PRI is listed against each column involved in the Primary key. Regards Quentin -Original Message- From: Etienne Marcotte [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 December 2001 9:42 a.m. To: sherzodR Cc: Demirchyan Oganes-AOD098; '[EMAIL PROTECTED]' Subject: Re: Creating MySQL table w/2 primary keys I found a way to have two primary key, if those keys relate on many columns. mysql create table keytest( - col1 int not null, - col2 int not null, - unique index (id1,id2), - unique index (id2,id1) Query OK, 0 rows affected (0.01 sec) mysql describe keytest; +---+-+--+-+-+---+ | Field | Type| Null | Key | Default | Extra | +---+-+--+-+-+---+ | id1 | int(11) | | PRI | 0 | | | id2 | int(11) | | PRI | 0 | | +---+-+--+-+-+---+ 2 rows in set (0.00 sec) here ya go, two primary key. in my app, it's very useful for the tables linking two other tables (two tables are N:N so the middle one links) +-+ +---+ +--+ | users | | userdepts | | depts| +-+ +---+ +--+ | usrID || usrID || deptID | | usrDept | | deptID| | deptName | | usrName | +---+ +--+ +-+ (do you like my relational DB ascii figure? Then when selecting all linked entried, it uses only the index! Since it's only numbers and the indexes for search in each directions are there.. HTH Etienne sherzodR wrote: As far as I know, you can't do tht. What you could do instead is have one Primary Key col and make another one UNIQUE. I did that several times, and it does work! -- What they need to teach in school is for people to think for themselves. :-) -- Larry Wall in [EMAIL PROTECTED] Demirchyan Oganes-AOD098 wrote: DO: Hello everyone, DO: DO: I have this create table statement, DO: DO: drop table IF EXISTS GROUP_CONCLUSION_GROUPING CASCADE; DO: DO: CREATE TABLE IF NOT EXISTS GROUP_CONCLUSION_GROUPING( DO: ANALYSIS_RESULT_ID MEDIUMINT(20) PRIMARY KEY REFERENCES PAD_ANALYSIS_RESULT(ANALYSIS_RESULT_ID), DO: GROUP_CONCLUSION_IDMEDIUMINT(20) PRIMARY KEY REFERENCES GROUP_CONCLUSION(GROUP_CONCLUSION_ID) DO: ) Type=InnoDB; DO: DO: where I want to create table with 2 primary keys, but it won't let me. DO: DO: How could I do it. DO: DO: Regards, DO: DO: Oganes Demirchyan DO: Motorola Life Science DO: 757 S.Raymond DO: Pasadena, CA 91105 DO: Tel: 626-584-5900 DO: email: [EMAIL PROTECTED] DO: DO: DO: - DO: Before posting, please check: DO:http://www.mysql.com/manual.php (the manual) DO:http://lists.mysql.com/ (the list archive) DO: DO: To request this thread, e-mail [EMAIL PROTECTED] DO: To unsubscribe, e-mail [EMAIL PROTECTED] DO: Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php DO: - 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 -- Etienne Marcotte Specifications Management - Quality Control Imperial Tobacco Ltd. - Montreal (Qc) Canada 514.932.6161 x.4001 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Symbolically linked database, unknown database problem.
Hi, Try ls -Ll cc, to check that the link is valid and to see the permissions on the destination. HTH Quentin -Original Message- From: Peter Campbell [mailto:[EMAIL PROTECTED]] Sent: Friday, 7 December 2001 12:57 p.m. To: [EMAIL PROTECTED] Subject: Symbolically linked database, unknown database problem. I've created databases on a partition without problems, now I come to create a new database on a different partition and I can't access the database at all. At this stage I have the following in the mysql data directory (among others): lrwxrwxrwx1 mysqlmysql 17 Sep 3 11:56 candi - /asp/mysql/candi/ lrwxrwxrwx1 mysqlmysql 24 Dec 7 12:40 cc - /home/fastbase/cc/mysql/ The first database (candi) is fine (along with others in the /asp/mysql path) but the cc database is not accessible. If I log-in as user mysql I can access that directory fine so I thought it may be another problem but I guess rights may still be an issue. Any ideas? What are the rules/requirements for mysql to recognise the database directory? I haven't created any tables yet (as I can't access the database). Peter Campbell http://www.fastbase.co.nz Phone NZ 04 385 2230, Fax 04 385 2224. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: SHOW TABLES; show nothing
Hi, Try myisamchk'ing you mysql tables. Regards Quentin -Original Message- From: Gill, Vern [mailto:[EMAIL PROTECTED]] Sent: Monday, 3 December 2001 5:40 p.m. To: [EMAIL PROTECTED] Subject: SHOW TABLES; show nothing mysql CREATE TABLE faxblast (company VARCHAR(100), phone VARCHAR(12), fax TINYINT (10) UNSIGNED, state CHAR(2), description VARCHAR(80), sic VARCHAR(7)); Query OK, 0 rows affected (0.09 sec) mysql SHOW TABLES; Empty set (0.00 sec) mysql DESCRIBE faxblast - ; +-+--+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | +-+--+--+-+-+---+--- --+ | company | varchar(100) | YES | | NULL| | select,insert,update,references | | phone | varchar(12) | YES | | NULL| | select,insert,update,references | | fax | tinyint(10) unsigned | YES | | NULL| | select,insert,update,references | | state | char(2) | YES | | NULL| | select,insert,update,references | | description | varchar(80) | YES | | NULL| | select,insert,update,references | | sic | varchar(7) | YES | | NULL| | select,insert,update,references | +-+--+--+-+-+---+--- --+ 6 rows in set (0.01 sec) mysql use mysql Database changed mysql use pcdocrx Database changed mysql DESCRIBE faxblast; +-+--+--+-+-+---+--- --+ | Field | Type | Null | Key | Default | Extra | Privileges | +-+--+--+-+-+---+--- --+ | company | varchar(100) | YES | | NULL| | select,insert,update,references | | phone | varchar(12) | YES | | NULL| | select,insert,update,references | | fax | tinyint(10) unsigned | YES | | NULL| | select,insert,update,references | | state | char(2) | YES | | NULL| | select,insert,update,references | | description | varchar(80) | YES | | NULL| | select,insert,update,references | | sic | varchar(7) | YES | | NULL| | select,insert,update,references | +-+--+--+-+-+---+--- --+ 6 rows in set (0.00 sec) mysql SHOW TABLES; Empty set (0.00 sec) Someone please explain to my why this is happening? In fact, could someone explain this too?; # mysql -p Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 66 to server version: 3.23.28-gamma Type 'help;' or '\h' for help. Type '\c' to clear the buffer mysql SHOW DATABASES; +--+ | Database | +--+ | | | | | | | | | | | | | | +--+ 7 rows in set (0.00 sec) mysql SHOW TABLES; ERROR 1046: No Database Selected mysql use mysql Database changed mysql SHOW TABLES; Empty set (0.00 sec) mysql quit Bye [root@localhost /tmp]# ls /usr/local/var/ total 20k 4.0k drwx--2 root root 4.0k Dec 2 20:20 PC_Doctor_RX.orig/ 4.0k drwx--2 root root 4.0k Dec 2 11:02 mysql/ 4.0k -rw-r--r--1 root root5 Nov 29 16:26 mysqld.pid 4.0k drwx--2 root root 4.0k Dec 2 20:29 pcdocrx/ 4.0k drwx--2 root root 4.0k Nov 30 12:01 ulog/ Vern H. Gill State Director Director of Marketing Conejo Valley Jaycees http://www.conejovalleyjaycees.org - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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:
Solaris, JDBC and MySQL
Hi, Can anyone point me, a humble C programmer, to a tutorial for setting up and using JDBC and MySQL. We are having the following problem, which boils down to libobdcinst.so.1 not being found - where can I find it? SKYROAD#mercury1:/mercury/home/morgan/javatrial:java SimpleSelect DriverManager.getConnection(jdbc:odbc:mercury1) trying driver[className=sun.jdbc.odbc.JdbcOdbcDriver,context=null,sun.jdbc.odbc.Jdb cOdbcDriver@1bccd4ba] *Driver.connect (jdbc:odbc:mercury1) JDBC to ODBC Bridge: Checking security No SecurityManager present, assuming trusted application/applet JDBC to ODBC Bridge 1.1001 Current Date/Time: Fri Nov 30 12:30:09 GMT+12:00 2001 Loading JdbcOdbc library ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/i386/native_threads/libJdbcOdbc.so) ld.so.1: /usr/bin/../java/bin/../bin/i386/native_threads/java: fatal: libodbcinst.so.1: open failed: No such file or directory (/usr/bin/../java/bin/../lib/libJdbcOdbc.so) Unable to load JdbcOdbc library java.sql.SQLException: Unable to load JdbcOdbc library at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbc.init(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.initialize(Compiled Code) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) Unable to load JdbcOdbc library Unable to allocate environment getConnection: no suitable driver java.sql.SQLException: No suitable driver at java.lang.Throwable.init(Compiled Code) at java.lang.Exception.init(Compiled Code) at java.sql.SQLException.init(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at java.sql.DriverManager.getConnection(Compiled Code) at SimpleSelect.main(Compiled Code) SQLException: SQLState(08001) *** SSQLException caught *** SQLState: 08001 Message : No suitable driver Vendor : 0 Thanks in advance Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
SELECT INTO LCOAL OUTFILE
Hi, Is there a reason why, if I can LOAD DATA LOCAL INFILE 'file' INTO TABLE fred; why I can't SELECT * INTO LOCAL OUTFILE '/tmp/file.txt' FROM fred I know the data has to travel to the client, but it would make scripting easier! Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: API documentation issue : inconsistency in mysql_real_connect documentation
So, if you pass NULL in as the first parameter to mysql_real_connect, a possibility opened up by the manual, what is the return. If it is a MYSQL* connection handle if the connection was successful, where did the space for that handle come from. I agree with Mario - if someone is going to go through the documentation, as recommended on every post, the least that can be expected is that the documentation should be un-ambiguous. Regards Quentin -Original Message- From: Sinisa Milivojevic [mailto:[EMAIL PROTECTED]] Sent: Sunday, 25 November 2001 2:20 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Subject: Re: API documentation issue : inconsistency in mysql_real_connect documentation M. A. Alves writes: What is the semantics of passing a NULL mysql connection to mysql_real_connect()? Does it create a new handler? This is the only possible interpretation of the result value as documented. However it is also (abundantly) documented that the handle must be created with mysql_init(). So what stands? (I transcribe below the relevant part of the manual. The last sentence of the excerpt is the crux of the problem.) This is not a pressing issue, just one of correctness. I find it a bit surprising that such an inconsistency, or incompletness, still exists in the documentation of such a very important part of mysql as the only API means of making connections. 8.4.3.171 mysql_real_connect() . . . The first parameter should be the address of an existing MYSQL structure. Before calling mysql_real_connect() you must call mysql_init() to initialize the MYSQL structure. . . . 8.4.3.173 Return Values A MYSQL* connection handle if the connection was successful, NULL if the connection was unsuccessful. For a successful connection, the return value is the same as the value of the first parameter, unless you pass NULL for that parameter. (http://www.mysql.com/documentation/mysql/bychapter/manual_toc.html) -- , M A R I O data miner, LIACC, room 221 tel 351+226078830, ext 121 A M A D O Rua Campo Alegre, 823 fax 351+226003654 A L V E S P-4150-180 PORTO, Portugalmob 351+939354002 Hi! I think that our documentation is quite clear on that issue. First parameter should be a pointer returned by mysql_init, while a return value from mysql_real_connect is used for testing purposes. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Fulltime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: does each database connect cause mysqld to fork?
Hi, From previous message (I don't run linux), I believe that linux ps lists all threads, and mysqld does create a thread for each connection. Regards Quentin -Original Message- From: Bennett Haselton [mailto:[EMAIL PROTECTED]] Sent: Thursday, 22 November 2001 4:15 p.m. To: [EMAIL PROTECTED] Subject: does each database connect cause mysqld to fork? Each time I open a database handle (in perl code), does that cause a new process to run, a new instance of mysqld? And each time I disconnect the database handle ($dbh-disconnect() in perl code), does that cause the number of running instances of mysqld to go down by one? The process list on my Linux server includes several instances of mysqld: server1:/home/bhaselto/web/html$ ps auwx | grep mysqld root 1014 0.0 0.0 16720 ?SW Nov05 0:00 [safe_mysqld] mysql 1037 0.0 3.6 15172 9484 ?SNov05 22:10 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 1039 0.0 3.6 15172 9484 ?RNov05 19:02 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 1040 0.0 3.6 15172 9484 ?SNov05 0:04 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- mysql 4518 0.0 0.0 00 ?Z21:07 0:00 [mysqld defunct] mysql 4519 0.0 3.6 15172 9484 ?R21:07 0:00 /usr/sbin/mysqld --basedir=/ --datadir=/var/lib/mysql --user=mysql -- so I was wondering if that was the explanation -- I know I have multiple running scripts that use the database at the same time, although I thought they generally didn't leave the handles open that long. -Bennett [EMAIL PROTECTED] http://www.peacefire.org (425) 649 9024 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: File privileges?!
Hi, error 13 is permission denied Remember that the full paths to files are for the server, and the 'user' running the server must have permission to read/write the file as required, not (necessarily) the user running the client. Quentin -Original Message- From: Venugopal Allavatam [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 12:57 p.m. To: [EMAIL PROTECTED] Subject: File privileges?! Hello all, I am trying to insert the contents of a binary file into a blob data type using simple insert statement and the load_file(filename) function. Initially, the function was returning a NULL value. But eventually, I changed the 'File_priv' in the user table of mysql database to 'Y'. Now I am getting a new error... the Errcode : 13 and a message which says.. can't find stat file '/directory/file_name' I am using RH 7.1, and 3.23.36 version of mysql. I am running the server on this machine itself and I am the only user. All suggestions are welcome. I must solve this problem. regards venu = Venugopal Allavatam Ph: (res.): 949-361-6604 1100 Calle Del Cerro, (mobile): 949-842-1767 Apt.# 123-J, San Clemente, CA-92672 E-mail: [EMAIL PROTECTED] [EMAIL PROTECTED] __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Introducing hidden row having duplicated primary key
Hi, Yes - REPLACE is just INSERT with the ability to pre-delete if a UNIQUE key clash is found. This means that you would have to specify all the columns (even if they already had values in them). Update will update records that match the where, changing only the specified columns. HTH Quentin -Original Message- From: Martin MOKREJ [mailto:[EMAIL PROTECTED]] Sent: Wednesday, 14 November 2001 10:04 a.m. To: Gerald Clark Cc: [EMAIL PROTECTED] Subject: Re: Introducing hidden row having duplicated primary key On Tue, 13 Nov 2001, Gerald Clark wrote: Looks correct to me. What do you think is the problem? 2 rows were affected by the replace. One row was deleted, and one was inserted, Both rows had a value of 'test' for column 'Tab'. Cool, thanks to Jeremy Zawodny and you, now I know even more that I do not know sql. Well, I told you that. ;) I thought that REPLACE replaces only fields which are different, so if a line is missing, behaves as an insert, if the line is present, behaves as an updates on columns which differ. This means that I was hoping that UPDATE updates/rewrites all specified columns on line; REPLACE has some logic to figure out that we do not have to rewrite a column with the same data and so we do not have to recreate an index for such column. If I guess right, deleting a row means marking it as deleted, right, so the REPLACE in my case marked the old line/row deleted and appended a new row to the table? That would mean it's better to use UPDATE then REPLACE, right? ;) -- Martin Mokrejs - PGP5.0i key is at http://www.natur.cuni.cz/~mmokrejs MIPS / Institute for Bioinformatics http://mips.gsf.de GSF - National Research Center for Environment and Health Ingolstaedter Landstrasse 1, D-85764 Neuherberg, Germany tel.: +49-89-3187 3616 , fax:+49-89-3187 3585 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Storing returned string into variable in C
Hi,
Don't you mean
strcpy(reseller_prompts, row[0]);
not
strcpy(row[0], reseller_prompts);
Quentin
-Original Message-
From: Matthew Blacklow [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, 14 November 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: Storing returned string into variable in C
I am having trouble storing the result of a query into a variable when the
query returns a string.
Using phpmyadmin I test the query and it definitely works. So knowing that
the problem does not lie in the query.
My code contains several other queries all of which work, the only
difference is that they obtain their data from integer fields instead of
varchar fields. This is what it stores into the string (Ø. This is because
it seems that this is the value returned by the query as when i print row[0]
that is what it prints.
Included below is the problem code:
sprintf(query_string, SELECT this FROM that WHERE something = %d,
var_something);
if (debug) printf(%s\n, query_string);
if (mysql_query(mysql, query_string)){
if (debug) printf(ERROR);
return 1;
}
result = mysql_store_result(mysql);
if (mysql_num_rows(result) == 0){
printf(Error Occured\n);
return 1;
}
row = mysql_fetch_row(result);
/*here is where I attempt to copy the string returned from the query into
the variable, some of the code below is only there for debugging purposes*/
strcpy(row[0], reseller_prompts);
printf(--%s--\n, row[0]);
printf(--%s--\n, reseller_prompts);
mysql_free_result(result);
All help appreciated,
Matthew
-
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
-
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
Update Log and Load Data in file
Hi, I just updated a new database with the update log from another server, and the script failed on the LOAD DATA INFILE commands that I have to import data overnight from other sources, because, of course, those files didn't exist. Now, I know I can use --force to allow the script to complete, but the questions are: 1. Does the binlog log the LOAD DATA INFILE command in the same way? 2. How do those of you using replication handle load data infile commands on the slave? If the source file is not available on the slave, won't your slave no longer match the master? 3. Is it possible (if it doesn't already in the binlog) to have a load data infile to be logged as a series of INSERTs Quentin The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Repair with keycache state while ALTERing TABLE
Hi, When doing an Alter Table, what does state Repair with keycache Mean, and should it take 27 hours (so far) on a 26,000,000 record table. And another issue: When searching the archives, I'll get something like 4. Re: Repair with keycache http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79389[4] ... * http://lists.mysql.com/cgi-ez/ezmlm-cgi?1:mss:79389 As a result. Does the [4] indicate that there should be 4 messages in the thread, 'cos I can only see 2. TIA Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Quick Question - quick reply please!
Hi, Assuming that a 'table' has been defined with MAX_ROWS high enough to allow the table to be 4Gbytes, does the same size limit apply to the index as the data file, or is the index file subject to a different limit? Thanks for a speedy response Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Quick Question - quick reply please!
Hi, I found a discussion about the index file not being able to be RAIDed, and know that the OS Limit will apply in any case, but this is Solaris 8, so that isn't a problem, but can't find anything that explicitly states it. Even SHOW TABLE STATUS: mysql show table status like 'tt_tickets'\G *** 1. row *** Name: tt_tickets Type: MyISAM Row_format: Dynamic Rows: 176206 Avg_row_length: 38 Data_length: 6713540 Max_data_length: 1099511627775 Index_length: 4264960 Data_free: 0 Auto_increment: NULL Create_time: 2001-10-02 11:06:03 Update_time: 2001-10-31 15:53:03 Check_time: 2001-10-02 11:08:10 Create_options: max_rows=4294967295 pack_keys=1 Comment: 1 row in set (0.03 sec) Shows Max_data_length - does the same limit apply to the index? Quentin -Original Message- From: Carsten H. Pedersen [mailto:[EMAIL PROTECTED]] Sent: Saturday, 3 November 2001 11:47 p.m. To: Quentin Bennett Subject: RE: Quick Question - quick reply please! I seem to remember some discussion about this, and that the index *is* subject to filesystem limits i.e., it can't be split. It has been discussed rather extensively at some time in the near past; check the list archives. / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq -Original Message- From: Quentin Bennett [mailto:[EMAIL PROTECTED]] Sent: Saturday, November 03, 2001 10:28 AM To: MySQL (E-mail) Subject: Quick Question - quick reply please! Hi, Assuming that a 'table' has been defined with MAX_ROWS high enough to allow the table to be 4Gbytes, does the same size limit apply to the index as the data file, or is the index file subject to a different limit? Thanks for a speedy response Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Query speed
Hi, Check the section about How MySQL Optimizes queries for you version - there is a bit about how indices are not used when calling a function that may be relevant. Hope it helps Quentin -Original Message- From: Leon Noble [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 11:26 p.m. To: [EMAIL PROTECTED] Subject: Query speed Hi All, Tried the following three statements and they are wither too slow or do not give me what I want. Basically what I want is to search for records for a whole month and display totals for that month for each individual day. The date field is indexed. Tried.. select count(num) as mycount from table_name where month(date) = 08 and year(date) = 2001 and action = 1 group by dayofmonth(date); this one takes too long As does this one. select dayofmonth(date) as mydate, count(num) as mycount from table_name where month(date)=08 and year(date)=2001 and action=1 group by dayofmonth(date); and this one just outputs the total figure for the month select dayofmonth(date) as mydate, count(num) as mycount from table_name where date='TO_DAYS(2001-08-01) - TO_DAYS(2001-08-31)' and action=1 group by dayofmonth(date); can anyone help to point me in the right direction. many thanks Leon. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Editing Forms
Hi, If your Paradox Apps are written in a reasonably DB-independent way using Delphi Components, and not expoiting and Paradox-only features (are there any?), then porting those same applications to MySQL via ODBC should be a manageable task. If you do need to start from scratch, and the functionality is simple, then an Access Forms app, using MySQL Linked tables would be an option. M2CW Quentin -Original Message- From: Rick Emery [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:38 a.m. To: [EMAIL PROTECTED] Subject: RE: Editing Forms MySQL provides a rich list of APIs with which scripts and programs perform data management. Other than directly entering INSERT and UPDATE commands directly at the mySQL command line, there is not built-in data entry functionality. Data entry (including, verification, validation, limit-checking) is performed by scripts (PERL, PHP) or programs, such as those written in C. SUBJECTIVE_OPINION The easiest method to create data entry is browser-enabled forms using a PHP script front-end. The API is quite extensive and easily handles tasks I've had to write hundreds of lines of code in years past. Since everyone has a browser on their desktop, this prevents you from developing thick-client interface. If some client-side calculations are required (thin-client technology), these can be easily handled in JAVA or JAVASCRIPT. Finally, having started from a browser-based application, migrating your application and database to the internet is far less costly and time-consuming /SUBJECTIVE_OPINION The lack of data-entry and programming functionality is a fact-of-life of the SQL-family of relational databases. Like you, I, too, come from a dBase/FoxPro/Access development world where these capabilities were built-in to the database engine itself. The SQL-family simply provides an API access to your data and leaves insertion, update, retrieval, and display to your own devices. -Original Message- From: Robert A. Smith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 01, 2001 12:46 PM To: [EMAIL PROTECTED] Subject: Editing Forms I have been looking at MySQL with the assumption that I could move up to an enterprise level database from a desktop database without the prodigious cost normally incurred. I usually work for small business's and my choice of database has been Paradox. I have been using Delphi as a front end tool but am unsure of where Paradox is going and my customers are tired of the lost indexes and val files that come with Paradox even though I feel that it has served them very well. On to the question. I cannot get a sense of what a MySQL database would look like. In Paul Dubois's book and Sams Teach Yourself the references in the index have a paucity of references to data entry. The favoured version being to dump the data in from another file. I must write a data-entry front end for a large amount of data for a small business. Half of the code I usually write is meant to present the user with a fast, secure, set of customized data entry forms. I can find almost no code for this outside of the browser interface. Am I barking up the wrong tree with MySQL asking it to be something that its not or am I simply too myopic in my search. Can I put together a database that will function in a small office that may eventually, and I say this with some hesitation, move access of the data to the web. My problem is trying to envision the end product and am I am having great difficultly. Would Delphi and/or Kylix make this a viable operation. Thank You Robert Smith - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
RE: Installing Calendar 0.9.33 on Mac OS X
First pointer - what errors are you getting! -Original Message- From: Greg [mailto:[EMAIL PROTECTED]] Sent: Friday, 2 November 2001 9:32 a.m. To: [EMAIL PROTECTED] Subject: Installing Calendar 0.9.33 on Mac OS X Newbie here who has PHP and MySQL going, but can't figure out how to install calendar. I suspect this is because I don't understand UNIX and permissions and which account I'm in. Here are the instructions edited: Unpack the calendar software in its own directory somewhere where your web server will find it. Where might this be? I'm not at all clear on where the webserver will find it. I tried putting it my Sites folder. MySQL (from command line): mysqladmin create intranet (This will create a database named intranet.) I get an error when I try this from the command line. I went into mysql and created the database, but then the next command baffles me. Create the calendar tables using the supplied tables.sql file: MySQL (from command line): mysql intranet tables-mysql.sql (where intranet is the name of your database) I get an error. thanks for any help or pointers. - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: a bug or intentional? -- problem with multiple table query
Hi,
You need to read up on Left Joins, which will insert a 'NULL' row in the
results for B where there isn't a real one.
Regards
Quentin
-Original Message-
From: Q [mailto:[EMAIL PROTECTED]]
Sent: Friday, 2 November 2001 4:40 p.m.
To: [EMAIL PROTECTED]
Subject: a bug or intentional? -- problem with multiple table query
I am having a problem with a query and I don't know if it is a bug or
intentional. Anyway any input is greatly appreciated. Here is a basic
query
that is simpler than what I am dealing with but should demonstrate my
problem.
Lets say:
SELECT A.1, A.2 FROM A
yeilds:
test1 test2
then:
SELECT A.1, A.2 FROM A, B
yeilds nothing, unless B has something in it. my problem is that b does not
always have something in it. I need to have B in the FROM list because I
use
it in the WHERE statement.
I am curious if this is intentional, but mainly I would like to know if
there
is a way around it other than putting a dummy entry in the tables.
If anyone cares here is the real query:
SELECT DISTINCT services.serviceid, services.name from admin_permissions,
pop_permissions, admin_pops, services WHERE
(concat('service_',services.serviceid)=admin_permissions.object AND
(admin_permissions.can_change=1 OR admin_permissions.can_grant=1) AND
admin_permissions.userid=1) OR (concat('service_',services.serviceid)=
pop_permissions.object AND (pop_permissions.can_change=1 OR
pop_permissions.can_grant=1) AND pop_permissions.popid=admin_pops.popid AND
admin_pops.userid=1) ORDER BY services.name
-
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
-
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: key question
Hi, In the first key, the combination of key1 and key2 must be unique, in the second, key1 must be unique on its own, but key2 does not need to be. Also, using the first primary key a select col1, col2, ... where key2=value cannot use the index but select col1, col2, ... where key1=value can In the second example, either query may use an index. You can search on any column - makeing the column and index (or the left-most part of an index) allows the index to be used to make the search faster. MySQL Doesn't allow you to specifiy which index to use - it chooses (sometimes badly) whether or not to use one. Hope this helps. Quentin -Original Message- From: Federico Schwindt [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 10:57 a.m. To: [EMAIL PROTECTED] Subject: key question hi, i'm not sure if this belongs here, but i cannot seem to find the answer anywhere else. first, what's the difference between: PRIMARY KEY (key1, key2) PRIMARY KEY (key1), KEY (key2) second, let's suppose the following table: owner_id int(11), customer_id int(11), customer_info varchar(100) and i want to search either by owner_id and customer_id. can i do this w/o creating the indexes by hand? or do i have to create'em explicity and specify which one i'm gonna use before performing a query? if anyone can help me or point me to where i can find this kind of stuff i'd appreciate it. thanks, f.- - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Can't connect to new databases
Hi, What error message do you get. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 1:22 p.m. To: [EMAIL PROTECTED] Subject: Can't connect to new databases I have recently installed mySQL 3.23.43. I will be using it to run a website (php/mysql). Using my php scripts I can connect to the server and the default test database and select information from the table I created in the test database. However, if I create a new database, not matter what it's called, I can not connect to it from the php. I can however connect to it directly in mysql and perform any actions on it (eg create tables, insert rows, select data). Any help would be greatly appreciated. Thanks in advance, Ryan - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Can't connect to new databases
Hi, I'm not a PHPer, but in 'C', there is an API that can give you the MySQL error message, which I am sure would explain the problem some more. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 3:30 p.m. To: Quentin Bennett Subject: Re: Can't connect to new databases In mysql directly I have no problem. In php, when I run mysql_select_db(database) or die(Failed to connect to database); I simply get the failed error - Original Message - From: Quentin Bennett [EMAIL PROTECTED] To: 'Ryan Booker' [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Thursday, November 01, 2001 12:09 PM Subject: RE: Can't connect to new databases Hi, What error message do you get. Quentin -Original Message- From: Ryan Booker [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 1:22 p.m. To: [EMAIL PROTECTED] Subject: Can't connect to new databases I have recently installed mySQL 3.23.43. I will be using it to run a website (php/mysql). Using my php scripts I can connect to the server and the default test database and select information from the table I created in the test database. However, if I create a new database, not matter what it's called, I can not connect to it from the php. I can however connect to it directly in mysql and perform any actions on it (eg create tables, insert rows, select data). Any help would be greatly appreciated. Thanks in advance, Ryan - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Need query help
Hi, You need to self-join payhistory along the lines of select p1.* from payhistory p1, payhistory.p2 where p1.payid = p2.payid and p1.paydate = max(p2.paydate) Something like that, anyway - I know I had to fiddle around a bit to get a similar think going. Hope this help Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, 1 November 2001 4:22 p.m. To: [EMAIL PROTECTED] Subject: Need query help Hello all, I have 3 tables I need to join to extract certain data base on the acct_days in the active table '6' days. QUERY: SELECT CONCAT(m.fname,' ',m.lname) AS name, m.email,m.zip,p.paytype,p.event,p.paydate FROM members m LEFT JOIN payhistory p ON p.memid = m.memid LEFT JOIN active a ON a.memid = m.memid WHERE a.acct_days = '6' GROUP BY p.memid ORDER BY p.paydate DESC QUERY RESULTS: +-+---+---+-+--- ++ | name| email | zip | paytype | event | paydate| +-+---+---+-+--- ++ | Charge Schwartz | [EMAIL PROTECTED] | 33308 | Charge | Quarterly New | 2001-10-30 | | Check Schwartz | [EMAIL PROTECTED] | 33308 | Check | Quarterly New | 2001-10-30 | +-+---+---+-+--- ++ But what I need it to do is pull the most recent date and related payhistory data in those columns that match the memid from the members table that only has the 6 days left on their account. RESULTS DESIRED: +-+---+---+-+--- ++ | name| email | zip | paytype | event | paydate| +-+---+---+-+--- ++ | Charge Schwartz | [EMAIL PROTECTED] | 33308 | Check | Quarterly New | 2001-10-31 | | Check Schwartz | [EMAIL PROTECTED] | 33308 | Charge | Quarterly New | 2001-10-31 | +-+---+---+-+--- ++ Below are snips for the tables being joined. Any help would be much appreciated. Been at this for almost good part of the day! :) TIA - active table +---+---+ | memid | acct_days | +---+---+ |21 | 6 | |22 | 6 | +---+---+ payhistory +---+---+++-+ | payid | memid | event | paydate| paytype | +---+---+++-+ |83 |21 | Quarterly New | 2001-10-30 | Charge | |84 |22 | Quarterly New | 2001-10-30 | Check | |85 |21 | Quarterly Renew| 2001-10-31 | Check | |86 |22 | Quarterly Renew| 2001-10-31 | Charge | +---+---+++-+ members +---+-+---+---+ | memid | name| email | zip | +---+-+---+---+ |21 | Charge Schwartz | [EMAIL PROTECTED] | 33308 | |22 | Check Schwartz | [EMAIL PROTECTED] | 33308 | +---+-+---+---+ mysql database Mike(mickalo)Blezien =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= Thunder Rain Internet Publishing Providing Internet Solutions that work! http://www.thunder-rain.com Tel: 1(225)686-2002 =-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-= - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Please...... mysql error! please reply~ here is South Korea.
Hi, errno 13 is permission denied. Possibly you installed mysql as root, and are trying to run as a normal user? Change the permissions in you data directory so the user running the mysqld server can read/write the files. Quentin Here is New Zealand! -Original Message- From: BungyJump [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 30 October 2001 1:29 p.m. To: [EMAIL PROTECTED] Subject: Please.. mysql error! please reply~ here is South Korea. I'am not english speak. sorry~ ^^;; [error] # ./bin/safe_mysqld --user=mysql Starting mysqld daemon with databases from /usr/local/mysql/data 011030 09:04:16 mysqld ended # [./mysql/data/host_name.err] -- 011030 09:04:15 mysqld started 011030 9:04:16 /usr/local/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 011030 9:04:16 /usr/local/mysql/bin/mysqld: Normal shutdown 011030 09:04:16 mysqld ended -- exist /usr/local/mysql/data exist /usr/local/mysql/data/mysql/host.frm [For reference] # pwd /usr/local/mysql # ls COPYING INSTALL-BINARY configurelib manual.txt scripts support-files COPYING.LIB README data man manual_toc.html sharetests ChangeLogbin include manual.html mysql- test sql-bench # # pwd /usr/local/mysql/data # ls host_name.err mysql test # # pwd /usr/local/mysql/data/mysql # ls columns_priv.MYD db.MYDfunc.MYD host.MYD tables_priv.MYD user.MYD columns_priv.MYI db.MYI func.MYI host.MYI tables_priv.MYI user.MYI columns_priv.frm db.frm func.frmhost.frm tables_priv.frm user.frm # Please REPLY~~ Please ~~~ T_T;; ToT;; my e-mail address:[EMAIL PROTECTED] or [EMAIL PROTECTED] === ¿ì¸® ÀÎÅͳÝ, Daum http://www.daum.net ¼Û±Ý, 1/nû±¸, ȸºñ°È±â! À̸ÞÀÏ ÇÑÅëÀ¸·Î ÇØ°áÇÑ´Ù ¢Ñ ¸ÞÀϹðÅ· http://mailbank.daum.net/ - 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 mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: SELECT Query in PHP
Congrats on getting to 48 hours - let us know which platform you prefer when you reach the number of hours that it took to get the 'Must Consult Some Else' tag! :-) QB -Original Message- From: Todd Williamsen [mailto:[EMAIL PROTECTED]] Sent: Saturday, 27 October 2001 5:48 p.m. To: 'Mike'; 'Woolsey, Fred' Cc: [EMAIL PROTECTED] Subject: RE: SELECT Query in PHP Yes, I think HTML, mySQL and PHP is a marriage made in heaven but... Online docs is like reading stereo instructions in a foreign language most of the time. I tried the webmonkey.com tutorial and it was ok.. Funny thing is that the script they used, I couldn't get to work... Go figure... Just my luck! Granted I am so new to PHP I think I just eclipsed the 48 hour mark... So am I still a rookie? Lol!! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 -Original Message- From: Mike [mailto:[EMAIL PROTECTED]] Sent: Friday, October 26, 2001 9:33 PM To: Woolsey, Fred Cc: '[EMAIL PROTECTED] ' Subject: Re: SELECT Query in PHP I think the worst part about the books is that with things like PHP, Apache and MySQL, by the time you find (i.e. from browsing at the local library) and sit down to learn, it's talking about MySQL 3.22, Apache 1.2, and PHP3. Nothing beats the online documentation.. amen to that. :) You might try some sites like webmonkey.com for php tutorials. I think that's where I went when I decided to learn php about.. oh about a year ago. Mike Woolsey, Fred wrote: Funny... I find the PHP, HTML and MySQL combo to be a marriage made in heaven. Also, I have not yet seen a book (and I've bought a few of them) that beats the PHP and MySQL documentation available for free on the web. Follow the URLs in the other e-mails and you will find the truth... OK, maybe I exaggerate, but at least you'll find the info you need. Cheers (and remember, wer immer streibend sich bemueht, den koennen wir erloesen.- apologies to Goethe) Fred Woolsey -Original Message- From: Todd Williamsen To: [EMAIL PROTECTED] Sent: 10/26/2001 8:25 PM Subject: SELECT Query in PHP I am a newbie at this and I cannot find the damn answer to it! I want to display the table in an html format with PHP but I cannot get it to work! With MS SQL Server it was sooo easy! With PHP and mySQL it's a pain in the butt! I cannot find any documentation on this and I order 3 books on this stuff, but they won't be here till at least Monday. HELP! Thank you, Todd Williamsen, MCSE home: 847.265.4692 Cell: 847.867.9427 - 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 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: MySQL Security w/ PHP
Have you tried something like SELECT User,Password from user where (User=$ID AND Password($PW)=password); ie. equate the result of password(string) to the stored, encrypted, password Regards Quentin -Original Message- From: Kevin Maynard [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 11:52 a.m. To: [EMAIL PROTECTED] Subject: MySQL Security w/ PHP I have been building an extensive dB with MySQL for a large Insurance Company and am nearing the completion stage. I have build several PHP forms to show the preliminary pages to the various groups who will be using this dB. I have created the sign-in page where each user has types in their ID and PW. From then on each query uses those variables for credentials. To avoid duplication, I would like to use the USER form from the MySQL dB. Since that uses the Password(PW) function, I can't seem to get my validation query to work properly. For example: SELECT User,Password from user where (User=$ID AND Password=$PW); Result: Empty Set. SELECT User,Password from user where (User=$ID AND Password($PW)); Result: Will match User only, will accept ANY PW. Does anyone know how to properly check off the PW from the User table in the MySQL db? Thanks, Kevin - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: PHP Tutorial for total beginner??
http://www.devshed.com/Server_Side/PHP/PHP101 -Original Message- From: Chip Rose. [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 12:31 p.m. To: [EMAIL PROTECTED] Subject: PHP Tutorial for total beginner?? Can someone suggest a link to a total beginner PHP/MySQL tutorial? I've got MySQL set up and running (finally!) on Linux, and really need an interface for forms inputting of data. So far, I'm setting up a database as a contact manager/sales transaction history manager on steroids, and I'm extremely happy with where this is going. It's a learning curve, but if I could only learn what PHP was, and how to set it up to work with MySQL, I'd really be in business. Manually inputting data with MySQL commands or loading via text files is just not going to be the way for me to go. I don't mind studying up, if someone can help me get a clue. Thanks a lot. Chip. [EMAIL PROTECTED] - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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 update
Hi, You'll need to post your query and the error message to get a meaningful response. Quentin -Original Message- From: Prachi Shroff [mailto:[EMAIL PROTECTED]] Sent: Monday, 29 October 2001 1:36 p.m. To: [EMAIL PROTECTED] Subject: problem with update Hi all! I am new to MySQl and am having trouble executing an UPDATE statement in a perl script. The same UPDATE statement works fine when used on the prompt. Also, the same perl script executes other statements like SELECT. I am running mysql 3.23.42, perl 5.6.1 on a Windows2000 system. Has anyone had a similar problem? Any help would be highly appreciated. Please do reply to me straight, as I have not subscribed to the mailing list. thanks, Prachi _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Compile on 3.23.40 OSF1 Digital UNIX 4.0D - HELP PLEASE
Hi, Using $ gcc -v Reading specs from /usr/local/lib/gcc-lib/alphaev56-dec-osf4.0d/3.0/specs Configured with: /misc/gcc-3.0/configure Thread model: single gcc version 3.0 on $ uname -a OSF1 unix V4.0 878 alpha I get this: Making all in mysys make[2]: Entering directory `/applic/mysql.src/mysql-3.23.40/mysys' /bin/sh ../libtool --mode=link gcc -O3 -DDBUG_OFF -D_PTHREAD_USE_D4 -DHAVE_SIGWAIT -o test_charset -DDEFAULT_BASEDIR=\/applic/mysql-3.23.40a\ -DDATADIR=\/applic/mysql-3.23.40a/var\ -DDEFAULT_CHARSET_HOME=\/applic/mysql-3.23.40a\ -DDATADIR=\/applic/mysql-3.23.40a/var\ -DSHAREDIR=\/applic/mysql-3.23.40a/share/mysql\ -DHAVE_CONFIG_H -I./../include -I../include -I.. -I. -O3 -DDBUG_OFF -D_PTHREAD_USE_D4 -DHAVE_SIGWAIT -DMAIN ./test_charset.c libmysys.a ../dbug/libdbug.a../strings/libmystrings.a -lpthread -lmach -lexc -lm -lpthread -lmach -lexc gcc -O3 -DDBUG_OFF -D_PTHREAD_USE_D4 -DHAVE_SIGWAIT -o test_charset -DDEFAULT_BASEDIR=\/applic/mysql-3.23.40a\ -DDATADIR=\/applic/mysql-3.23.40a/var\ -DDEFAULT_CHARSET_HOME=\/applic/mysql-3.23.40a\ -DDATADIR=\/applic/mysql-3.23.40a/var\ -DSHAREDIR=\/applic/mysql-3.23.40a/share/mysql\ -DHAVE_CONFIG_H -I./../include -I../include -I.. -I. -O3 -DDBUG_OFF -D_PTHREAD_USE_D4 -DHAVE_SIGWAIT -DMAIN ./test_charset.c libmysys.a ../dbug/libdbug.a ../strings/libmystrings.a -lpthread -lmach -lexc -lm -lpthread -lmach -lexc /usr/bin/ld: Unresolved: pthread_mutex_destroy pthread_mutex_lock pthread_mutex_unlock pthread_setspecific pthread_cond_destroy pthread_mutexattr_default pthread_mutex_init pthread_condattr_default pthread_cond_init pthread_getspecific collect2: ld returned 1 exit status make[2]: *** [test_charset] Error 1 make[2]: Leaving directory `/applic/mysql.src/mysql-3.23.40/mysys' make[1]: *** [all-recursive] Error 1 make[1]: Leaving directory `/applic/mysql.src/mysql-3.23.40' Please can someone tell me if there is a compile option to get around this. Can I safely use MIT Threads on OSF? Do I need to update the thread libraries? I have read and re-read the OSF section of the manual, but it is very vague as to what will work and what won't. I have successfully compiled 3.23.40 on Solaris Intel and also compiled 3.22.27 on the OSF1 - that version has recently taken to not responding, which is why I am now desparate to get the (what was) latest version up and running. Help!! Quentin Bennett Transport Systems Division Infinity Solutions www: http://www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone: +64 9 358 9720 Fax: +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: mysql CLI: executing SQL from a file
Hi, Check section 4.8.2 of the (4.0.0-alpha) manual, or type help at the MySQL Command line. Quentin -Original Message- From: Neil Zanella [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 23 October 2001 11:49 a.m. To: MySQL Mailing List Subject: mysql CLI: executing SQL from a file Hello, I would like to know if it is possible to issue a command from the mysql command line interface which will read SQL commands contained in a file and execute them immediately without having to cut and paste them one gpm buffer size at a time. Thanks, Neil - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Escape in a shell script
Hi,
I want to escape single quotes in the result of a query run in a shell
script. I think REPLACE is the right function to use.
If, at the mysql prompt, I enter
mysql select replace(name, '\'', '\\\'') from cust_details where name like
'%\'%' limit 10;
I get
+-+
| replace(name, '\'', '\\\'') |
+-+
| WELLINGTON ASM\'S |
| MAGS N\' MOVIES (TRACK TRAC |
| M/C\'TRACT:CAMPAIGN PALACE |
| ANDERSON O\'LEARY LTD |
| CHESTER\'S PLUMBING BATHROOM |
| BENNETT\'S GOVERNMENT BOOK SHO |
| *CHRISTIAN CHILDREN\'S FUND (NZ |
| NATURE\'S SUNSHINE PRODUCTS |
| HILL\'S FLOORINGS LTD |
| *O\'NEALE WOODCRAFTS LTD|
+-+
Which is perfect - the strings can be sent back in to a mysql session
correctly.
If, however, I put the exact same command in to a file , myfile.sql, and go
$ mysql mydb myfile.sql
I get
replace(name, '\'', '\\\'')
WELLINGTON ASM\\'S
MAGS N\\' MOVIES (TRACK TRAC
M/C\\'TRACT:CAMPAIGN PALACE
ANDERSON O\\'LEARY LTD
CHESTER\\'S PLUMBING BATHROOM
BENNETT\\'S GOVERNMENT BOOK SHO
*CHRISTIAN CHILDREN\\'S FUND (NZ
NATURE\\'S SUNSHINE PRODUCTS
HILL\\'S FLOORINGS LTD
*O\\'NEALE WOODCRAFTS LTD
Using these as the input to another mysql session doesn't work, as the first
\ escapes the second, the ' terminates the string, and the rest of the
string is a syntax error.
I have used various numbers of \'s, and even char(92), but nothing gives me
the correct result.
I am sure this wheel must have been invented before - anyone out there done
it, or am I on the wrong track?
For info, the full command I am trying to run is:
mysql mydb !
SELECT concat(concat('update crm_cust set name = \'',
replace(name, ', \\\')), '\','),
concat('bill_to = \'', billto_account, '\','),
concat('repcode = \'', repcode, '\','),
concat('rpt_to = \'', ifnull(rpt_master, cust_details.account), '\','),
'priority = ', priority,
concat('where account = \'', cust_details.account, '\';')
from crm_update_cust,
cust_details left join report_masters
on cust_details.account = report_masters.account
where cust_details.account = crm_update_cust.account
and cust_details.name like '%\'%' limit 10;
!
with the result being piped in to another mysql (either directly or via a
file)
TIA
Quentin Bennett
Transport Systems Division
Infinity Solutions
www: http://www.infinity.co.nz
mailto:[EMAIL PROTECTED]
Phone: +64 9 358 9720
Fax: +64 9 309 4142
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
-
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
Altering a big table
Hi, If I have a large table ( 70million rows, nearly 4 GB Index, 2.5G Data), and I want to ALTER TABLE mytable TYPE=MYISAM; ALTER TABLE mytable change column col1 col1 tinyint unsigned not null; ALTER TABLE mytable DROP INDEX index_1; ALTER TABLE mytable ADD INDEX index_1(col2, col1); ALTER TABLE mytable ADD INDEX index_2(other_cols..) ALTER TABLE mytable ADD INDEX index_3(more_cols..) am I going to be any better off doing it by: 1. Drop all indexes, change table type, recreate indexes, and run other alters 2. Create a new table with required structures, and insert into select ... 3 Create a new table, and mysqldump db mytable | mysql db newtable 4 2 or 3, but create the indexes (5 indexes) after doing the import 5. Run all the alter tables at once 6 Run the alter tables one after the other. In this respect, and as a matter of general interest, if I issue the command ALTER TABLE mytable add index i1(c1, c2), add index i2(c3, c4), change column c1 c1 column_definition what does the server do - all in one hit, sequentially, with/without indexes for the 'temporary table'? Thanks P.S. I am subscribed to the digest, but not the list, so copy replies to me please. Thanks again Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: MySQL or MS SQL?
Hi, Agreed Just because software is developed on a 'Free' platform, doesn't mean that the customer expects the application to be free, or even cheap. Our experience is that if you give something away, then people expect the support/upgrades/customisations to be free to. If you charge, even a nominal amount, it puts in to the mind of the customer that nothing comes for free. Regards Quentin -Original Message- From: Michael Bacarella [mailto:[EMAIL PROTECTED]] Sent: Thursday, 19 July 2001 7:47 a.m. To: Chris Cameron Cc: [EMAIL PROTECTED] Subject: Re: MySQL or MS SQL? On Wed, Jul 18, 2001 at 12:38:29PM -0600, Chris Cameron wrote: I think people who use proprietary software systems are just accustomed to being gouged by ridiculous software costs. Not to mention that it also costs us more to accomodate them. Basically, distorting the argument a little, you could be saying Our proprietary software customers make us more money because their platforms require far more support, and we make them pay dearly for it. If that works for you, great. Personally, you couldn't pay me enough to maintain proprietary systems. :) I'm sorry to say that your experiences do not coincide with mine. We've seen cheapskates of all flavors and colors. Also, just what are your clients doing dictating the software platform you should be using? You're the technical consultant, you should be choosing the platform! In my experience, customers don't ask for applications developed on free software. They just ask for applications. The fact that they're developed using free software matters not one bit to them. -MB I'm sure if done right, MySQL could do whatever you want satisfactorily. Same with MS SQL (ignoring cost). However, something few people seem to know, but I've realized from experience is that when you offer people services based off free software, you get a different kind of customer. And not the good kind. Where I work (http://www.advantcomp.com (free plug!)) we offer both Windows and UNIX (usually OpenBSD) solutions. When people come to us looking for something to be done in free unix (Linux, OpenBSD, PHP, MySQL, etc), they expect to pay crappy prices. And frankly they're crappy clients. They don't know what they want, they're only available to talk after hours, etc. While there are a few people who are looking for serious applications done in free software, they are few and far between. On the other side of the coin is people looking for enterprise solutions. These are people expecting to pay a lot, so they give you a lot. These people usually look for MS SQL/ColdFusion sort of deal. The Windows side of our company gets -WAY- more money than the free-UNIX side. So if you're looking to make money, and have some capital to burn to start, I'd say use non-free software. That can be UNIX still, but not free-unix. Sybase, DB2 or Oracle for a database, and JSP seem to be the only enterprise solutions around for UNIX. But judging by your question you don't seem to be stuck with UNIX for a platform. If you're going NT I'd be careful with Microsoft software. IIS and MS -- Michael Bacarella [EMAIL PROTECTED] Technical Staff / System Development, New York Connect.Net, Ltd. The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Strange queries
Hi,
You can't use aliases in a where, but you can in a HAVING clause.
Regards
Quentin
-Original Message-
From: Brad Barnett [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, 10 April 2001 8:44 a.m.
To: [EMAIL PROTECTED]
Subject: Strange queries
SELECT
url,newwebsites.description,newwebsites.title,newwebsites.catid,category.ful
lname,MATCH
newwebsites.description AGAINST ('aliens') as GOO from newwebsites,category
LEFT
JOIN userrestrictions ON userrestrictions.name REGEXP
'[[::]]username|GLOBALAUTHADMIN[[::]]' AND
newwebsites.catid=userrestrictions.catid where
category.catid=newwebsites.catid
AND userrestrictions.catid IS NULL AND category.groupid='1' ORDER BY
newwebsites.groupid DESC limit 10;
Can anyone tell me why the above query works, and responds with a column
labelled "GOO", but if I take the exact same query, and add "AND GOO 0" to
it,
it complains that there is :
ERROR 1054: Unknown column 'GOO' in 'where clause'
What gives? If the column GOO exists when MYSQL does an output from that
query,
why can't I address it in the query?
Thanks for any help anyone may have!
Quoting Andrew Schmidt [EMAIL PROTECTED]:
Have you tried this under a 'stable' version of freebsd?
In FreeBSD 4.2 beta, mysql would crash with user locks. Not mysql's
fault.
now, I understand RC's are generally stable; but I would still make sure
that this bug doesn't show up in a stable os.
regards,
-- Andrew
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Monday, April 09, 2001 3:34 PM
Subject: mysql uses 99% cpu under freebsd 4.3
Description:
mysql uses 99% cpu and becomes extremely unresponsive under high load
How-To-Repeat:
send about 300 simultaneous visitors to www.chicagobusiness.com and
tell
them to click around.
Fix:
restart mysql. this usally helps, at least for a few minutes.
sometimes
it climbs back to 99% though.
Submitter-Id: submitter ID
Originator: Jon Nathan
Organization:
Chaffee Interactive
MySQL support: extended email support
Synopsis: mysql uses 99% cpu and becomes unresponsive
Severity: serious
Priority: high
Category: mysql
Class: support
Release: mysql-3.23.36 (Source distribution) from freebsd ports
Environment:
System: FreeBSD d1.crain.com 4.3-RC FreeBSD 4.3-RC #1: Tue Apr 3
16:17:52
GMT 2001 [EMAIL PROTECTED]:/usr/obj/usr/src/sys/CHAFFEE i386
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc
GCC: Using builtin specs.
gcc version 2.95.2 19991024 (release)
Compilation info: CC='cc' CFLAGS='-O2 -pipe -mpentiumpro ' CXX='c++'
CXXFLAGS='-O2 -pipe -mpentiumpro -felide-constructors -fno-rtti
-fno-except
ions' LDFLAGS=''
LIBC:
-r--r--r-- 1 root wheel 1170734 Apr 3 12:24 /usr/lib/libc.a
lrwxr-xr-x 1 root wheel 9 Apr 3 12:24 /usr/lib/libc.so -
libc.so.4
-r--r--r-- 1 root wheel 559764 Apr 3 12:24 /usr/lib/libc.so.4
Configure command:
./configure --localstatedir=/data/db --without-perl --without-debug
--witho
ut-readline --without-bench --with-mit-threads=no --with-libwrap
--with-low-
memory --enable-assembler --with-berkeley-db --with-charset=latin1
--prefix=
/usr/local i386--freebsd4.3
Perl: This is perl, version 5.005_03 built for i386-freebsd
-
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
---
Dynamic Hosting
HTTP://www.L8R.net/
"We Provide Static Hostnames for Dynamic IP's"
-
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your
RE: REXEXP in select only works with short expressions on Alpha
Hi,
Just a guess, but I expect that the first response will be to use gcc 2.95.2
or later
Quentin
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, 9 April 2001 1:30 p.m.
To: [EMAIL PROTECTED]
Subject: REXEXP in select only works with short expressions on Alpha
Description:
When transfering a database application to use an Alpha Linux server
rather than intel Linux previously working regular expressions fail to work.
It appears to be due to a length limit. This effects both binary downloads
and home compiled distributions.
How-To-Repeat:
Simple test case (with results)
mysql create table test (xxx char(128));
Query OK, 0 rows affected (0.00 sec)
mysql insert into test (xxx) values('this is a test of some long text to
see what happens');
Query OK, 1 row affected (0.00 sec)
mysql select * from test where xxx regexp('is a test of some long text
to'); +--+
| xxx |
+--+
| this is a test of some long text to see what happens |
+--+
1 row in set (0.00 sec)
mysql select * from test where xxx regexp('is a test of some long text to
');
Empty set (0.00 sec)
mysql select * from test where xxx regexp('is a test of some long text to
s');
Empty set (0.00 sec)
mysql select * from test where xxx regexp('is a test of some long text to
se');
Empty set (0.00 sec)
mysql select * from test where xxx regexp('test of some long text to se');
+--+
| xxx |
+--+
| this is a test of some long text to see what happens |
+--+
1 row in set (0.00 sec)
Fix:
Unknown - I have revererted to the working Intel system - hopefully this a
fix
will be found soon since the original move was due to capacity problems on
the
intel hardware !
Submitter-Id: submitter ID
Originator:[EMAIL PROTECTED]
Organization:
MySQL support: [none]
Synopsis: on linux Alpha regexp does not work with long expressions
Severity: critical
Priority: high
Category: mysql
Class: sw-bug
Release: mysql-3.23.36 (Source distribution)
Environment:
System: Linux rossem.octopus-technologies.co.uk 2.2.14-6.0 #1 Tue Mar 28
16:56:56 EST 2000 alpha unknown
Architecture: alpha
Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc
/usr/bin/cc
GCC: Reading specs from
/usr/lib/gcc-lib/alpha-redhat-linux/egcs-2.91.66/specs
gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release)
Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS=''
LIBC:
lrwxrwxrwx1 root root 13 Apr 7 17:16 /lib/libc.so.6.1 -
libc-2.1.3.so
-rwxr-xr-x1 root root 8070122 Mar 27 2000 /lib/libc-2.1.3.so
-rw-r--r--1 root root 18837112 Mar 27 2000 /usr/lib/libc.a
-rw-r--r--1 root root 180 Mar 27 2000 /usr/lib/libc.so
Configure command: ./configure
Perl: This is perl, version 5.005_03 built for alpha-linux
-
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
The information contained in this email is privileged and confidential
and intended for the addressee only. If you are not the intended
recipient, you are asked to respect that confidentiality and not
disclose, copy or make use of its contents. If received in error
you are asked to destroy this email and contact the sender immediately.
Your assistance is appreciated.
-
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: Problems with Mysql on Sol7 i386
Hi Matt, Probably worth checking the archives for 'restartable' - there are a few messages there. Quentin -Original Message- From: Matt Mueller [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 9:53 a.m. To: [EMAIL PROTECTED] Subject: Problems with Mysql on Sol7 i386 Hello, I am trying to install mysql version 3.23.26 on my sun machine running solaris 7. I have installed gnu make, tar, and gcc-version 2.95.2. I have also tried doing everything that is reccomended for my error such as editing config.cache and even using the reccomended configure line. The error I am getting is: checking for restartable system calls... configure: error can not run test programs while cross compiling Has anyone run into this problem even after updating thier systems? Thanks for the help, Matthew Mueller Matthew Mueller Space Science and Engineering Center University of Wisconsin-Madison Phone: 608.263.8185 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Hello!Help.
The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. Hi, You need to use GNU tar - there is a link on the MySQL Download page for it. Once you have got that, just use your 'gtar' instead of tar. Quentin -Original Message- From: php_mysql [mailto:[EMAIL PROTECTED]] Sent: Thursday, 5 April 2001 3:34 p.m. To: [EMAIL PROTECTED] Subject: Hello!Help. Hello! How do you do! I meet a problem when I install Mysql at Solaris 2.7 Sun SPARC.Please help me. First I gzip and tar the mysql-3.23.36-sun-solaris2.7-sparc.tar.A error echoed "tar:directory checksum error."Then I goto the /mysql/bin/ and excute ./configure,the prompt is configure not found.I don't know what is the reason.I think maybe the tar of Solaris is not work in good way.How can I install a GNU tar and how to use it?Can you tell me?Thank you. Regards! David __ === (http://mail.sina.com.cn) !"",""? (http://newchat.sina.com.cn) - 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: How to recover from accidental 'drop database mysql'
Hi, Its called your backup tape. Quentin -Original Message- From: Anonymous Individual [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 3 April 2001 4:16 p.m. To: [EMAIL PROTECTED] Subject: How to recover from accidental 'drop database mysql' Greetings: I accidently dropped (my thunderous stupidity!!!) our mysql database. There were a few usernames and other databases. I expected hell to break loose (it may still happen!), but strangely enough, I noticed that I was still able to login, probably because mysql server caches usernames, passwords, etc ?? I quickly backed up the remaining databases using mysqldump. I did a make install to update the database and everything still seems ok. Now, anyone know if there is any way to create or repair my existing mysql database with the information that is currently cached in the server ? For example, if I do "show databases", I see all the databases that should exist, but when I do a "select * from mysql.db", I only see the "test" database!. Any ideas will be gratefully appreciated and accepted ! --== Sent via Deja.com ==-- http://www.deja.com/ - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
Mail Marshall E-mail Viruses - An Apology
Hi, My apologies on behalf of Mail Marshall for the flood of virus alerts. They started at 0:01 on1/4/01 NZST (hmm... maybe there is something there), and continued until our support staff re-installed the latest virus ID file - we didn't have time to find out why it happened. So, to those of you that sent sympathetic messages saying "Its probably not your fault, but " - thanks and apologies. To those of you that sent Unsubscribe messages - Come the .com revolution, you'll first against the wall and blasted with my "Super-Charged Geek Blaster with rocket launcher attachment". (What do you mean, I missed the .com revolution ???) Back to work..... Quentin Bennett Transport Systems Division Infinity Solutions web http:\\www.infinity.co.nz mailto:[EMAIL PROTECTED] Phone : +64 9 358 9720 Fax : +64 9 309 4142 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Delete Again?
Hi, No. you can't delete based on a join. Regards Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 30 March 2001 3:35 p.m. To: [EMAIL PROTECTED]; [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Delete Again? Hmmm Well I didn`t manage to get any of those examples to work. This is my select statement.. "select Failed_Signups.EmailAddress.Email from Failed_Signups.EmailAddress left join www_domain_net.Members on Failed_Signups.EmailAddress.Email=www_domain_net.Members.EmailAddress where www_domain_net.Members.EmailAddress is null"; That is matching the records, is it possible to just reverse engineer this so it deletes from Failed_Signups.EmailAddress when it makes a match ?? Thanks for all the help so far Ade - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Dynamic Custom Sort Orders
Hi, This is a bit unclear - any sorting is either based on some combination of values, be they columns, bits of columns, static values or random values, and so can be expressed as an Order BY clause. For example, I have a report that allows the user to say in which order the columns should be sorted, and create an order by clause (in 'C') from their selections. Are you able to clarify things a bit further? Quentin -Original Message- From: Michael Todd Glazier [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 8:31 a.m. To: [EMAIL PROTECTED] Subject: Dynamic Custom Sort Orders hey all! I'm developing a CGI app for access to a mysql table. I want to offer users the ability to arbitrarily sort the results. That is, given the following table: letter - A B C I want to sort the results as B,C,A , C,A,B, and such. I need to do this from a single select statement so I can use the LIMIT parameter to keep state and page through the results. The best solution I've come up with so far is to dynamically build an IF statement like the following. Assume the requested order is C, A, B SELECT letter, IF(letter='C',1,IF(letter='A',2,IF(letter='B',3,4))) as MYORDER FROM alpha ORDER BY MYORDER This works, but it seems a tad clumsy. Also, the real table and sort order uses and combines multiple columns, so it gets really hairy. How to use formulas to affect sort order in the ORDER BY clause isn't clear to me (other than RAND()), so I'm wondering if a cleaner solution lies there. Any thoughts would be appreciated Peace, Michael Todd - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: howto: telnet shell
Hi, You don't telnet to the server, you use the mysql command line client $ mysql --host="yourhost" etc. Quentin -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Friday, 23 March 2001 12:53 p.m. To: [EMAIL PROTECTED] Subject: howto: telnet shell i have a MySQL server running in my office. i need to be able to telnet into the MySQL server remotely. can anyone point me at documentation that will tell me how? right now (from a dos window) when i issue: TELNET server.name 3306 - it reports "BAD HANDSHAKE" i think that somehow i need to supply a user name and password, but unclear how to accomplish. thanks - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: [OT] SQL syntax qestion
Hi, Yes, in MySQL you can go select handle, sum(total) as t group by handle order by t; in ANSI (?) you can go select handle, sum(total) group by handle order by 2; 2 being the column number of the result. Regards Quentin -Original Message- From: Curtis Maurand [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 20 March 2001 4:28 p.m. To: MySQL List Subject: [OT] SQL syntax qestion Hi, Just a quick quesiton, I have a table that contains difined as create table picks( handle char(30) primary key, ... total int unsigned); there is a user table that has a list of handles and other user info. handle is the primary key. If I issue the command "select handle, sum(total) group by handle;" I get the information that I'm looking for, however I'd like to sort it by the sum that I get. Is there a way of accomplishing this? Curtis The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: MySQL 3.23.35 is released
Hi, To be fair to the anonymous writer, the main reason for introducing 3.23.25 was Changes in release 3.23.35 -- * Fixed newly introduce bug in `ORDER BY'. Nothing there about 'in Innobase and/or Gemini Tables', and for a release that is declared Stable to have a bug introduced is a bit of a no-no. If the bug only affected parts of the release that are still alpha, beta or gamma, as some of the new table types are, then the change notice should really reflect that, so that a new user is sure of what is affected, aiding the 'To upgrade or not upgrade' decision. JM2c Quentin -Original Message- From: Jeremy D. Zawodny [mailto:[EMAIL PROTECTED]] Sent: Monday, 19 March 2001 11:47 a.m. To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED]; Greg Cope Subject: Re: MySQL 3.23.35 is released On Sun, Mar 18, 2001 at 03:31:47PM -0500, [EMAIL PROTECTED] wrote: On 17-Mar-2001 Jeremy D. Zawodny wrote: Er. Is there any way you guys can actually form a stable branch, and a development branch? It would be nice to get a stable version of mysql with replication, and that's not going to happen with all of these new features being pumped into a supposedly "stable" branch. Don't enable innobase or gemini, and you'll have a stable server. Seriously, if you don't even compile in the new features, there's little danger of them affecting you. Little danger?! Correct. Look, let's approach this another way. 3.23.xx isn't stable, and hasn't been ever, because it _was_ a development branch, and you keep treating it as such, while at the same time you call it your stable branch. This is wrong. Not stable? Compared to what? I've had a server running several versions of 3.23.xx for about 6 months now. In that time it handled over a billion queries. Yes, a billion. The current one has been up for over two months running 3.23.29 (which was declared "gamma") without a hitch. Perhaps you haven't heard of such a thing as a development branch, and stable branch of code. Maybe you haven't heard the term "beta" and "alpha" ever before. 3.23.xx is BETA, and unusable in a production enviroment. I believe I (and many others) have evidence to the contrary. The MySQL team declared it "stable" for a reason. The development branch is 4.0.xx. Maybe I should say that again. 3.23.xx is BETA, and is unusable in a production enviroment. You need a stable branch, and a development branch, and you need them ASAP so that current MySQL code can be made stable enough for a production enviroment. Well, then I'll say again what I just said. The development branch is 4.0.xx. 3.23.xx (for the right versions of xx) is stable. Don't take this the wrong way. MySQL is a great product, but any great software product is a piece of crap if its crashing and causing problems because you keep it in a consitantly beta state. There are many, many, many folks running 3.23.xx without it constantly crashing. Is there some widespread problem that we're unaware of? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 328-7878Fax: (408) 530-5454 Cell: (408) 439-9951 - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: problems with mysql table
Hi, Try some of the more aggressive fixing options on isamchk - see the manual for details. Quentin -Original Message- From: Nuno Ferreira [mailto:[EMAIL PROTECTED]] Sent: Friday, 16 March 2001 10:39 a.m. To: [EMAIL PROTECTED] Subject: problems with mysql table Hi there I have a problem with one mysql table and i don't know how to solve it .. the table has some important stuff. when i make a select this is what happens mysql select * from imp_addr; ERROR 1030: Got error 127 from table handler mysql and isamchk isamchk imp_addr.ISM Checking ISAM file: imp_addr.ISM Data records:1223 Deleted blocks: 0 - check file-size - check delete-chain - check index reference - check record links Can anyone help me on this ??? Thanks :) -- Nuno Ferreira AKA |rider http://rider.lusoweb.pt mailto:[EMAIL PROTECTED] http://www.lusoweb.pt mailto:[EMAIL PROTECTED] - 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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: Full tables...
Hi, The output from mysqladmin variables would be useful. Quentin -Original Message- From: Dave Camarillo [mailto:[EMAIL PROTECTED]] Sent: Thursday, 15 March 2001 7:42 a.m. To: [EMAIL PROTECTED] Subject: Full tables... Hello all, I've run into a minor problem with my schema/mysql. I have a table with 64 columns (varying data-types) and about 7 indexes (some multi-column indexes) containing roughly 19 million records. Were running Solaris 2.8 on Sparc with mysql 3.23.33 with raid-tables and large files compiled in with gcc 2.95.2. In my development, I have roughly 30 MyISAM tables that are identical in columns/indexes to this particular table, the only difference is the number of records in this table (this table has the most records) My problem, is that when I go to do an update statement to the table, I get an error message back from the Perl DBI saying that "The table BLABLABLA is full". I have this table set up with raid-0, across 8 slices, each slice with a max size of 2 gigs. (in theory the max size of the table would be 16 gigs). After looking at the actual table slices in the mysql data directory, the sum of the slices only takes up about 4.5 gigs while, the index file is about 1.5 gigs and only in 1 file. There is plenty of memory on the machine, currently mysql has malloc'ed about 4 gigs. In my code, I've tried putting in "SET SQL_BIG_TABLES=1;", however I still get the same error. What kinds of things cause "Table Full" errors? I've looked through the mysql documentation, however I haven't been able to find a fix that works. Any suggestions, ideas etc? Thanks Dave [EMAIL PROTECTED] Some other info about how mysql is setup: Tmp_table_size=1gig Record buffer = 512M Table cache = 1gig Key_buffer = 1gig (I've been playing around with these settings so I know they are not optimal) Another question, off this subject. The most memory I've seen mysql use is 4 gigs. Is it possible for it to use more? Do I need to compile it with a different memory model? If so, what kind of model and where can I find out more about 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 The information contained in this email is privileged and confidential and intended for the addressee only. If you are not the intended recipient, you are asked to respect that confidentiality and not disclose, copy or make use of its contents. If received in error you are asked to destroy this email and contact the sender immediately. Your assistance is appreciated. - 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
