RE: access denied
What's user are you logged with when you're trying these commands? It looks like you specified no user when launching the mysql console. Try with user root if you have access to it. You don't have enough rights to perform your commands without a user specified. Lian Sebe, M.Sc. Freelance Analyst-Programmer www.programEz.net -Original Message- From: Helen [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 4:57 AM To: [EMAIL PROTECTED] Subject: access denied mysql CREATE DATABASE csttrainrep - ; ERROR 1044: Access denied for user: '@localhost' to database 'csttrainrep' mysql GRANT ALL ON csttrainrep. TO helen - ; 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 'TO helen' at line 1 mysql GRANT ALL ON csttrainrep.* TO helen; ERROR 1044: Access denied for user: '@localhost' to database 'csttrainrep' mysql how do i change this? -- 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]
is mysql compatible with C++???
Hi, is mysql compatible with c++ in linux? I cant seem to get it working any sample c++ script would do. thanks in advance. dave -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Jpg file insertion
Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO .. statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get stored in proper format. How do i acheieve this ?? ___ Download the hottest happening ringtones here! OR SMS: Top tone to 7333 Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
link broken
HI! I have problem to download http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip Is there some problem? Thanks. Emanuele
Re: WG: wait_timeout in my.cnf
On Wednesday 16 July 2003 16:10, Moritz Steiner wrote: Like this: # The number of seconds the server waits for activity on a connection # before closing it wait_timeout= 300 Set interactive_timeout=300, too. -Urspr?ngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 09:55 An: [EMAIL PROTECTED] Betreff: Re: WG: wait_timeout in my.cnf Moritz Steiner [EMAIL PROTECTED] wrote: I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. How did you set the wait_timeout variable? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Help!!!
CREATE TABLE NAME ( SELECT name, work FROM A UNION ALL SELECT name, home FROM A WHERE home IS NOT NULL ); CREATE TABLE ADDRESS ( SELECT work FROM A UNION ALL SELECT home FROM A WHERE home IS NOT NULL ); Cheers /rudy -Original Message- From: Colt Brunton [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 16:54 To: [EMAIL PROTECTED] Subject: Help!!! Hi I am trying to extract two lots of information from one table but in such a way as to maintain the relationship between the two entities. I.E.: Table A ID NAME WORK HOME ^ 1 Jon A null 2 TracyA null 3 Agnes A B 4 Tom C null 5 Pete X J 6 SteveY G 7 Jim Z W 8 Mary Z null 9 Sue Z R 10 Lynn K null 11 TracyH I 12 W 13 M 14 N 15 O What I need to do is: 1.Get the data held in the fields: WORK and HOME into one table (removing duplications) 2.Provide a reference to an address for each NAME. Hopefully producing something like: ADDRESS ^ A B C G H I J K M N O X Y Z and separately: NAME Jon A TracyA Agnes A Agnes B Tom C Pete X Pete J SteveY SteveG Jim Z Jim W Mary Z Sue Z Sue R Lynn K TracyH TracyI W M N O I don't even know where to start. Regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Select via Perl
Can you please post the source code? In any case, I would consider using DBI. Cheers /rudy -Original Message- From: Ashwin Kutty [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 17:12 To: [EMAIL PROTECTED] Subject: Select via Perl I am trying to read a file and see if the contents of it exists in the DB or not and am trying to do it via a Select. I try to do a select * into outfile /tmp/result.txt from table where field like %$var%; but it always goes through the first two lines of the input file and then says the file already exists. Is this because I read each line of a file in a for loop in perl and the mysql query tries to recreate the outfile each time? Is there any other way I can dump the results of the select to a file of some sort? Thanks.. -- 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]
Connector/J
Hi there Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME Regards Will S. NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information.
RE: Connector/J
I'm not sure about NT, but it works under 2000 (for me) Andrew Olden School Of Applied Sciences University Of Glamorgan x2227, [EMAIL PROTECTED] -Original Message- From: William Smith [mailto:[EMAIL PROTECTED] Sent: 18 July 2003 10:12 To: '[EMAIL PROTECTED]' Subject: Connector/J Hi there Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME Regards Will S. NOTICE AND DISCLAIMER: This email (including attachments) is confidential. If you have received this email in error please notify the sender immediately and delete this email from your system without copying or disseminating it or placing any reliance upon its contents. We cannot accept liability for any breaches of confidence arising through use of email. Any opinions expressed in this email (including attachments) are those of the author and do not necessarily reflect our opinions. We will not accept responsibility for any commitments made by our employees outside the scope of our business. We do not warrant the accuracy or completeness of such information. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql connection error
On Thursday 17 July 2003 12:59, zafar rizvi wrote: hi i have running MySQL version 3.23.52. and using Linux 8.0 Does your MySQL server crash when you try to connect remotely? Linux 8.0 - SuSe? Red Hat? Tx ZafAr - Original Message - From: Victoria Reznichenko [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, July 17, 2003 2:36 PM Subject: Re: mysql connection error zafar rizvi [EMAIL PROTECTED] wrote: hi I am running one centralized mysql server, its runnig fine and conneded with localhost and his own ip very fine. But when i want to connect him from remote system or other lan system it give me errror like that. [EMAIL PROTECTED] root]# mysql -h 192.168.0.63 mysql ERROR 2013: Lost connection to MySQL server during query Anybody has idea what's wrong and where is ? I get no answer from searching on google with that error. What is the version of MySQL server? What OS do you use? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Connector/J
Java write once, run anywhere works for Connector/J: it is the same for all platforms. Works under Windows 2K for me. -- Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
AW: WG: wait_timeout in my.cnf
Thanks a lot, that solved my problem! Moritz -Ursprüngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED] Gesendet: Freitag, 18. Juli 2003 10:16 An: [EMAIL PROTECTED] Betreff: Re: WG: wait_timeout in my.cnf On Wednesday 16 July 2003 16:10, Moritz Steiner wrote: Like this: # The number of seconds the server waits for activity on a connection # before closing it wait_timeout= 300 Set interactive_timeout=300, too. -Urspr?ngliche Nachricht- Von: Egor Egorov [mailto:[EMAIL PROTECTED] Gesendet: Mittwoch, 16. Juli 2003 09:55 An: [EMAIL PROTECTED] Betreff: Re: WG: wait_timeout in my.cnf Moritz Steiner [EMAIL PROTECTED] wrote: I set a lot of variables in the my.cnf file, all variables are set (I checked it with show variables) except of wait_timeout. If I set the option in MySQL with option wait_status=xxx it works. How did you set the wait_timeout variable? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: join query result difference between 3.23.49 and 4.0.13
Doug Reese [EMAIL PROTECTED] wrote: hello victoria, thanks for your response. however, the real goal of my question still remains unanswered: given my sample data, how would i find the balance on an invoice with one sql statement. sure, i could query for the amount paid, then in a separate query subtract the result from the invoice total, but that seems like a step backwards. is there a way to do what i was doing with v3.23, given the new NULL behavior? Check if field has NULL value, then 0, else original value. SUM(if(amount_paid IS NULL, 0, amount_paid)) doug At 02:53 PM 7/17/2003 +, [EMAIL PROTECTED] wrote: -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 10:33 To: [EMAIL PROTECTED] Subject: Re: join query result difference between 3.23.49 and 4.0.13 Doug Reese [EMAIL PROTECTED] wrote: query #2 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 10001 | NULL |NULL | +-+--+-+ 1 row in set (0.00 sec) NULL values in this result are not expected, nor are they helpful in determining the invoice balance. It's correct result. Since 4.0.13 SUM() returns NULL if there is no rows in the result or if all values are NULL (as in your case). And SELECT billing.amount - NULL also returns NULL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Working with the text datatype in Mysql
Hi All, I am managing a small database where a few fields are defined as being of type text. In my understanding, this would allow the user to enter up to about 65,000 characters in the text field. However, if the user types about 2,000 characters, then nothing is entered in the database. I have checked the max_packet_allowed and the net_buffer_length and the limits are quite high. Could somebody advice me on how to go about solving this problem? I look forward to hearing from you soon. Thanks in advance. George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: link broken
Emanuele [EMAIL PROTECTED] wrote: I have problem to download http://www.mysql.com/Downloads/mysqlgui/mysqlgui-win32-static-1.7.5-2.zip Worked for me. But MySQLGUI is no longer under development. Take a look at MySQL Control Center. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: join query result difference between 3.23.49 and 4.0.13
Better ifnull(sum(amount_paid),0) Because if you add up a column which contains NULL and NOT NULL values, all NULL values are SKIPPED for the calculation. This implies that if the column ONLY contains NULL values, the result is NULL. Would be great if MySQL could post a chart somewhere of how they treat NULL values in calculations. Until then, check the release notes for every release concerning NULLs. And also the known bugs/future releases. Cheers /rudy -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juli 2003 12:43 To: [EMAIL PROTECTED] Subject: Re: join query result difference between 3.23.49 and 4.0.13 Doug Reese [EMAIL PROTECTED] wrote: hello victoria, thanks for your response. however, the real goal of my question still remains unanswered: given my sample data, how would i find the balance on an invoice with one sql statement. sure, i could query for the amount paid, then in a separate query subtract the result from the invoice total, but that seems like a step backwards. is there a way to do what i was doing with v3.23, given the new NULL behavior? Check if field has NULL value, then 0, else original value. SUM(if(amount_paid IS NULL, 0, amount_paid)) doug At 02:53 PM 7/17/2003 +, [EMAIL PROTECTED] wrote: -Original Message- From: Victoria Reznichenko [mailto:[EMAIL PROTECTED] Sent: donderdag 17 juli 2003 10:33 To: [EMAIL PROTECTED] Subject: Re: join query result difference between 3.23.49 and 4.0.13 Doug Reese [EMAIL PROTECTED] wrote: query #2 mysql SELECT billing.invoice, SUM(amount_paid) AS paid, (billing.amount - SUM(amount_paid)) AS balance FROM billing LEFT JOIN billing_payment ON ( billing.invoice=billing_payment.invoice ) WHERE billing.invoice=10001 GROUP BY billing_payment.invoice; +-+--+-+ | invoice | paid | balance | +-+--+-+ | 10001 | NULL |NULL | +-+--+-+ 1 row in set (0.00 sec) NULL values in this result are not expected, nor are they helpful in determining the invoice balance. It's correct result. Since 4.0.13 SUM() returns NULL if there is no rows in the result or if all values are NULL (as in your case). And SELECT billing.amount - NULL also returns NULL. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: is mysql compatible with C++???
Try this http://www.cpp-home.com/tutorial.php?22_1 Hope it helps dave [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, is mysql compatible with c++ in linux? I cant seem to get it working any sample c++ script would do. thanks in advance. dave -- 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]
Non-blocking via C API?
I've been through the mysql doc for the C API in both mysql 4.0 and 4.1, but I don't see anything that explicitly supports non-blocking and/or cancel-able operations. For example, the mysql_real_query API doesn't take a timeout value and doesn't have any way to issue an asynchronous request. The mysql_real_connect API doesn't support anything to mark a connection as non-blocking. There's no API to obtain the underlying socket descriptor to manipulate this. Is this something that anyone else has an interest in? I know that this can be achieved (although somewhat brutally) using threads and killing threads, but this concerns me as it may cause corruption issues with lost connections/open tables - it seems to me that this support should be native to the software. Thx for any feedback/ideas. -R -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
Gerald, The version of MySQL is 3.23, the platform is Solaris, the language is English and the way I check whether data has been entered in the database or not is by running a select query on the database. Was that of any help? I tried searching the net but couldn't find more information about what might be causing the problem... Thanks, George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:11 PM Subject: Re: Working with the text datatype in Mysql | You supply almost no useful information here. | What version of MySQL are you using? | What platform? | What language? | How do you check to see if anything was entered? | | | Lekeas GK wrote: | | Hi All, | | I am managing a small database where a few fields are defined as being of | type text. In my understanding, this would allow the user to enter up to | about 65,000 characters in the text field. | | However, if the user types about 2,000 characters, then nothing is entered | in the database. I have checked the max_packet_allowed and the | net_buffer_length and the limits are quite high. | | Could somebody advice me on how to go about solving this problem? | | I look forward to hearing from you soon. | | Thanks in advance. | | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query debugging
Hi all I am trying to adapt a query, (kindly) given by Rudy and I can't seem to debug it. Here is the query: CREATE TABLE Contact (SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT ContactNo, Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); CREATE TABLE ADDRESS (SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); The error messages given by the MySQL Front are: You have an error in your SQL syntax near 'SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_C' at line 1 You have an error in your SQL syntax near 'SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM' at line 1 These messages aren't very informative, is there a more informative way to debug queries? Thanks again for the input. regards
FYI for all newbies
I highly recommend you go to http://www.mysqlstudio.com/ and buy Navicat. Extremely helpful GUI for creating and managing your MySQL databases! H -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySQL install/uninstall problem
I have what I (and my boss) consider to be a sort of serious problem with an install. I've downloaded and installed (per an instructor's request), the latest version of MySQL. Granted, this is not a purchased package, but is required for a class in SQL I'm taking through Kaplan College. When I installed this to my machine at work, where I run a Windows 2000 O/S, I followed the instructions listed on your website, got the service running and thought I was walking through okay. Then I attempted to install the Control Center and things started going wrong. The MySQL Control Center won't access the version of the client I have (4.1.0-Alpha) AND, I can't kill the process to remove it. The net stop turns into a terminal loop of some sort that never ends. The admin panel in Windows tries to stop the process, but it times out. I've tried to kill the mysql.exe file from the Task Manager and Access is denied. On the advice of my IT department, I tried to download and install the last stable version over the top to try to use the Uninstall to get back to where I was. That worked until it hit the exe file that was in use apparently, then the install died. I've weeded my way through my win.ini; autoexec.nt; and config.nt files trying to find the start commands for the process and they're not identifiable to me. I need help killing this thing before it gets threaded so far through my registry that I have to reload my O/S please. Help??!! Malaina Hudson Materials Manager/Production Scheduler Gilster-Mary Lee Corp. 100 W. Calumet Centralia, IL 62801 (618) 533-4808 ext. 242 (618) 533-4818 FAX [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
Lekeas GK wrote: Gerald, The version of MySQL is 3.23, That only spans 50 some odd releases. Which one? the platform is Solaris, the language is English Computer language. PHP? Perl? Python? Mysql command line tool? Did the program performing the insert properly quote special characters? Did it check for sucess of the insert? and the way I check whether data has been entered in the database or not is by running a select query on the database. Useing Which language above? Was that of any help? I tried searching the net but couldn't find more information about what might be causing the problem... Thanks, George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:11 PM Subject: Re: Working with the text datatype in Mysql | You supply almost no useful information here. | What version of MySQL are you using? | What platform? | What language? | How do you check to see if anything was entered? | | | Lekeas GK wrote: | | Hi All, | | I am managing a small database where a few fields are defined as being of | type text. In my understanding, this would allow the user to enter up to | about 65,000 characters in the text field. | | However, if the user types about 2,000 characters, then nothing is entered | in the database. I have checked the max_packet_allowed and the | net_buffer_length and the limits are quite high. | | Could somebody advice me on how to go about solving this problem? | | I look forward to hearing from you soon. | | Thanks in advance. | | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Database speed
Hi Roger, I guess you were right and I made the spelling mistake. ;-) I read your other posts to, especiall the long one. I respect your opinion, also I don't fully agree ;-) At the end everybody has to use what he is happy with. I am strongly Linux/Unix based so for me there is not need for a ACCESS or SQL server ;-) in any way. Peace ;-) Best regards Nils Valentin 2003 7 18 16:09Roger Irwin : Nils Valentin wrote: Excuse me but frankly speaking in British English I am sure some people wouls immadietly say bullocks - what you wrote here. While I dont want to go so far I am certainly interested to fully understand the statement you made above. Most people would say bullshit, allthougth I think the word you were looking for was Bollocks, which means testicles. A Bullock is a cows baby boy. Please feel free to critisize me, it is only by writing rubbish and then arguing about it that one arrives at the truth;-) -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote: The version of MySQL is 3.23, the platform is Solaris, the language is English and the way I check whether data has been entered in the database or not is by running a select query on the database. Was that of any help? I tried searching the net but couldn't find more information about what might be causing the problem... How are they typing in the information? From a web page? From the command line? From a custom program? ___/ / __/ / / Ed Leafe http://leafe.com/ http://opentech.leafe.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysqlbinlog suggestion
Luc Foisy [EMAIL PROTECTED] wrote: allowing date range options to the command line would be really neat Date or datetime option? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
They type the information from a web page. George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: Ed Leafe [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: gerald_clark [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Friday, July 18, 2003 3:05 PM Subject: Re: Working with the text datatype in Mysql | On Friday, July 18, 2003, at 09:25 AM, Lekeas GK wrote: | | The version of MySQL is 3.23, the platform is Solaris, the language is | English and the way I check whether data has been entered in the | database or | not is by running a select query on the database. | | Was that of any help? I tried searching the net but couldn't find more | information about what might be causing the problem... | | How are they typing in the information? From a web page? From the | command line? From a custom program? | | ___/ | / | __/ |/ | / | Ed Leafe | http://leafe.com/ | http://opentech.leafe.com | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
The checking is done from the mysql command line tool and all special characters are properly quoted (even tried it with a sequence of characters without any punctuation marks or anything else). The mysql_query() call has a die() statement as well but it is not coming up. George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: gerald_clark [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 3:00 PM Subject: Re: Working with the text datatype in Mysql | | | Lekeas GK wrote: | | Gerald, | | The version of MySQL is 3.23, | | That only spans 50 some odd releases. Which one? | | the platform is Solaris, the language is | English | | Computer language. | PHP? | Perl? | Python? | Mysql command line tool? | | Did the program performing the insert properly quote special characters? | Did it check for sucess of the insert? | | and the way I check whether data has been entered in the database or | not is by running a select query on the database. | | Useing Which language above? | | | Was that of any help? I tried searching the net but couldn't find more | information about what might be causing the problem... | | Thanks, | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | - Original Message - | From: gerald_clark [EMAIL PROTECTED] | To: Lekeas GK [EMAIL PROTECTED] | Cc: [EMAIL PROTECTED] | Sent: Friday, July 18, 2003 2:11 PM | Subject: Re: Working with the text datatype in Mysql | | | | You supply almost no useful information here. | | What version of MySQL are you using? | | What platform? | | What language? | | How do you check to see if anything was entered? | | | | | | Lekeas GK wrote: | | | | Hi All, | | | | I am managing a small database where a few fields are defined as being of | | type text. In my understanding, this would allow the user to enter up to | | about 65,000 characters in the text field. | | | | However, if the user types about 2,000 characters, then nothing is | entered | | in the database. I have checked the max_packet_allowed and the | | net_buffer_length and the limits are quite high. | | | | Could somebody advice me on how to go about solving this problem? | | | | I look forward to hearing from you soon. | | | | Thanks in advance. | | | | George | | | | I think there is a world market for maybe five computers. | | Thomas Watson, Chairman of IBM, 1943. | | | | | | | | | | | | | | | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Jpg file insertion
Sreesekhar Palaparthy [EMAIL PROTECTED] wrote: Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO .. statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get stored in proper format. How do i acheieve this ?? You should escape inserted data. Use LOAD_FILE() function instead: http://www.mysql.com/doc/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Query debugging
Sorry, MySQL does not like the ( ). Try it without them :) Cheers /rudy -Original Message- From: Colt Brunton [mailto:[EMAIL PROTECTED] Sent: vrijdag 18 juli 2003 15:38 To: [EMAIL PROTECTED] Subject: Query debugging Hi all I am trying to adapt a query, (kindly) given by Rudy and I can't seem to debug it. Here is the query: CREATE TABLE Contact (SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT ContactNo, Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); CREATE TABLE ADDRESS (SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); The error messages given by the MySQL Front are: You have an error in your SQL syntax near 'SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_C' at line 1 You have an error in your SQL syntax near 'SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM' at line 1 These messages aren't very informative, is there a more informative way to debug queries? Thanks again for the input. regards -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Jpg file insertion
Don't do that, if it's possible. You'll probably slow down the server. Try to save file in a directory and save to database only the filename. [you may want to rename the file so you won't overwrite diff pics with the same name] vioss - Original Message - From: Egor Egorov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:19 PM Subject: Re: Jpg file insertion Sreesekhar Palaparthy [EMAIL PROTECTED] wrote: Hi, I want to store jpg files to BLOB field of a table. That table has other fields which are integer and char types. So i tried inserting image using LOAD DATA INTO .. statement . It got stored , but when i retrieve it back , i'm not able to see the image file.I hope it didn't get stored in proper format. How do i acheieve this ?? You should escape inserted data. Use LOAD_FILE() function instead: http://www.mysql.com/doc/en/String_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: join query result difference between 3.23.49 and 4.0.13
Rudy Metzger [EMAIL PROTECTED] wrote: Better ifnull(sum(amount_paid),0) Yes, you are right. Because if you add up a column which contains NULL and NOT NULL values, all NULL values are SKIPPED for the calculation. This implies that if the column ONLY contains NULL values, the result is NULL. Would be great if MySQL could post a chart somewhere of how they treat NULL values in calculations. Until then, check the release notes for every release concerning NULLs. And also the known bugs/future releases. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Deleting a database....
Hello all, I have just finally finished my error free installation of mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced Server. I was able to follow a direction that helped me change the root user to myname and asign a password to myname. After that, I created 3 databases in addition to the test and mysql that were already created through the install process. My problem is that when I created the databases, I did not do anything else - no tables. I am running another application (Geeklog) and in the install of Geeklog, I got an error message saying that the Table gl_access already exist when I went to Geeklog forum help, it says that my problem is that I had performed an unsuccessful installation prior to this successful one, and therefore, I need to delete the table or better yet, delete the database and create a new one to use with Geeklog installation. The real question is that I do not know what would happen if I delete the database, and how do I delete the database? I thought it is something I could do at the command prompt just the same way I created the database: mysqlcreate database dbasenow would the following work: mysqldelete database dbasenow Or do I have to delete the tables in it first? Please understand that when I created the databases, I did not create any tables, but when I used PHPMYADMIN, I found that the database in question has tables in it while the other 2 that I created had nothing in them.. Thank you all in advance... Ola
RE: Query debugging
Sorry Rudy Still no luck Can't seem to figure out what's wrong. CREATE TABLE Contact SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT ContactNo, Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL; CREATE TABLE ADDRESS SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL; Is there any way of getting more information from MySQL?
Re: Query debugging
Colt Brunton [EMAIL PROTECTED] wrote: I am trying to adapt a query, (kindly) given by Rudy and I can't seem to debug it. Here is the query: CREATE TABLE Contact (SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT ContactNo, Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); CREATE TABLE ADDRESS (SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM import UNION ALL SELECT Home_Address, Field26, Home_City, Home_State, Home_Zip, Home_Country FROM import WHERE Home_Address IS NOT NULL); The error messages given by the MySQL Front are: You have an error in your SQL syntax near 'SELECT ContactNo, Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_C' at line 1 You have an error in your SQL syntax near 'SELECT Work_Address, Field20, Work_City, Work_State, Work_Zip, Work_Country FROM' at line 1 These messages aren't very informative, is there a more informative way to debug queries? Remove brackets, i.e. CREATE TABLE Contact SELECT .. UNION ALL SELECT ... ; -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: * HELP * MySQL Connection Issue - Access Denied!!
Jason - I just tried: GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'X' on the server machine in a mysql console and I got the following: ERROR 1045: Access denied for user: '@localhost' using password: NO ...in addition to my questions below, why doesn't that work! Ahhh! -Original Message- From: Ryan Schefke [mailto:[EMAIL PROTECTED] Sent: Friday, July 18, 2003 11:05 AM To: 'Jason k Larson' Subject: RE: * HELP * MySQL Connection Issue - Access Denied!! Hey Jason - Thanks a ton for your help! You're a lifesaver! When I use 'localhost' for the below line: C:\mysql\bin\mysqladmin -u root -h localhost password It seems to work??? because the next line goes back to c:\mysql\bin ...was the password for root successfully changed then? on the next line, I type c:\mysql\bin\mysqladmin -u root -h samserver password ...and oddly enough I get the following: mysqladmin: connect to server at 'samserver' failed error: 'Access denied for user: '[EMAIL PROTECTED]' using password: NO' Why doesn't it work when I use 'samserver' instead of 'localhost' In the winmysqladmin 1.4 tool under the environment tab it says my local host name is 'samserver'...what I named my computer? -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 7:19 PM To: Ryan Schefke Subject: Re: * HELP * MySQL Connection Issue - Access Denied!! You probably should either a) not use SAMSERVER or b) not specify the host or c) use localhost instead of SAMSERVER. the mysql prompt means you have successfully connected to the database server, which is a very good thing. As for the errors you probably need to create the ryanschefke user. Or just use root (not recommended). once you are at the mysql console try typing the following SQL statement. GRANT ALL ON *.* TO [EMAIL PROTECTED] IDENTIFIED BY 'your-password-here'; then do: FLUSH PRIVILEGES; you should be able to proceed with mySQLAdmin at that point. -- Jason k Larson Ryan Schefke wrote: Hi Jason, When I type: c:\mysql\bin\mysqladmin -u root -h localhost (I use 'samserver' for localhost...I hope that's right???) I get a whole list of things...version, options, variable, commands... When I type: c:\mysql\bin\mysqlc -u root I get welcome to the MySQL Monitor...then 'mysql' shows up. ...still getting errors though as mentioned below. -Original Message- From: Jason k Larson [mailto:[EMAIL PROTECTED] Sent: Thursday, July 17, 2003 6:08 PM To: Ryan Schefke Subject: Re: * HELP * MySQL Connection Issue - Access Denied!! How about: c:\mysql\bin\mysqladmin -u root -h localhost or just: c:\mysql\bin\mysqlc -u root ?? -- Jason k Larson Ryan Schefke wrote: .I just sent this out to the win32 distribution list but no one has replied.can someone on this list please help? The issue should be trivial for experienced MySQL users, I'm just a novice, thanks! Anyone - I've been racking my brain for the majority of the day and scouring through the MySQL manual trying to figure out what is wrong.can anyone please help? Here's my issue: - Extracted files to C:\MySQL - Ran setup.exe (everything went fine, using MySQL Admin 1.4 I can see 'mysql' and 'test' dbs installed) - MySQL is running as a service and MySQL Admin 1.4 shows a green light From the box that is running MySQL I try to set the root password in DOS two ways and when I mention the host (believe it's 'SAMSERVER' according to MySQL Admin tool) it gives me an error. O c:\mysql\bin\mysqladmin -u root password X.. Works fine and the next line goes back to my root directory of c:\mysql\bin O c:\mysql\bin\mysqladmin -u root -h SAMSERVER password X.. Gives me the below error! Mysqladmin: connect to server at 'samserver' failed Error: 'Access denied for user: '[EMAIL PROTECTED]' using password: NO' Also, when I try to connect to the database from another computer via the web using http://samserver.sytes.net:8080/mysqltest.php I get the following error (I've attached my mysqltest.php file too): 'Warning: mysql_connect(): Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) in C:\Apache\Apache2\html\mysqltest.php on line 20 Could not connect' *** Note, I had to change my router settings to forward port 8080 to my web server ip since my ISP blocks port 80. Also, I've successfully installed phpMyAdmin 2.5.2-rc2. When I run 'http://samsever.sytes.net:8080/phpadmin/index.php' I get the following message: Welcome to phpMyAdmin 2.5.2-rc2 phpMyAdmin tried to
Re: Connector/J
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 [EMAIL PROTECTED] wrote: Java write once, run anywhere works for Connector/J: it is the same for all platforms. Works under Windows 2K for me. -- Quick and simple question. Does the windows version of Connector/J run under Windows NT, the documentation implies only 9X and ME Hi! I'm curious as to what part confused you, so that I can fix it. I figured most people would just read the section http://www.mysql.com/documentation/connector-j/index.html#id2800741 and say 'Yup, I have one of those JVMs' and move on... Thanks, -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Thunderbird - http://enigmail.mozdev.org iD8DBQE/GA7jtvXNTca6JD8RApgPAJ46RxhUTrzQ20jRhQYoG6IYJk+PAACdFosn t0ERzCp6IcGLf/RolhQUKtY= =vgNA -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Multiple fiel attachments per record
Hello. How can I set up a table that allows multiple file attachments per record. Basically, if I have a table of clients, and I want to add or remove attached files for a client, I dont want to have to create a set number of blobcolumns ahead of time, so is there a way to dynamically add more files without adding more columns, or do I need to do an alter table statement add column..? Thanks Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Limiting query time
Is it possible to limit the query time in MySQL (3.x or 4.0)? For example, I'd like to have any query that takes more than a specified number of seconds just quit automatically. Seems dumb, but on a web site, nobody is going to wait minutes for a query to return so they refresh anyway. So on a busy server, MySQL ends up with several queries running that all take a long time to finish which compound to make it even slower. A simple time limit would solve the problem. Yes, I know that the queries should take less time, but again, on a busy server, sometimes the longer queries do take a long time (10 minutes or more) to complete. Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
Rob, The script is indeed written in PHP version 4.3.1. The full version of mysql I am using is 3.23.30-gamma. Thanks, George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: Rob A. Brahier [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Sent: Friday, July 18, 2003 4:31 PM Subject: RE: Working with the text datatype in Mysql | George, | You keep leaving out the vital bits. What are your sers using to enter | this data? We know it's a web page, but what script does that web page run | when the user submits their data? Is it a script written in the PHP | programming language or something else? What is the FULL version number of | the MySQL server you are using, and what is the version of the programming | language that you wrote your script in? | | -Rob | | -Original Message- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 10:17 AM | To: gerald_clark | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | | The checking is done from the mysql command line tool and all special | characters are properly quoted (even tried it with a sequence of characters | without any punctuation marks or anything else). The mysql_query() call has | a die() statement as well but it is not coming up. | | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | - Original Message - | From: gerald_clark [EMAIL PROTECTED] | To: Lekeas GK [EMAIL PROTECTED] | Cc: [EMAIL PROTECTED] | Sent: Friday, July 18, 2003 3:00 PM | Subject: Re: Working with the text datatype in Mysql | | | | | | | | Lekeas GK wrote: | | | | Gerald, | | | | The version of MySQL is 3.23, | | | | That only spans 50 some odd releases. Which one? | | | | the platform is Solaris, the language is | | English | | | | Computer language. | | PHP? | | Perl? | | Python? | | Mysql command line tool? | | | | Did the program performing the insert properly quote special characters? | | Did it check for sucess of the insert? | | | | and the way I check whether data has been entered in the database or | | not is by running a select query on the database. | | | | Useing Which language above? | | | | | | Was that of any help? I tried searching the net but couldn't find more | | information about what might be causing the problem... | | | | Thanks, | | George | | | | I think there is a world market for maybe five computers. | | Thomas Watson, Chairman of IBM, 1943. | | | | - Original Message - | | From: gerald_clark [EMAIL PROTECTED] | | To: Lekeas GK [EMAIL PROTECTED] | | Cc: [EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 2:11 PM | | Subject: Re: Working with the text datatype in Mysql | | | | | | | You supply almost no useful information here. | | | What version of MySQL are you using? | | | What platform? | | | What language? | | | How do you check to see if anything was entered? | | | | | | | | | Lekeas GK wrote: | | | | | | Hi All, | | | | | | I am managing a small database where a few fields are defined as being | of | | | type text. In my understanding, this would allow the user to enter up | to | | | about 65,000 characters in the text field. | | | | | | However, if the user types about 2,000 characters, then nothing is | | entered | | | in the database. I have checked the max_packet_allowed and the | | | net_buffer_length and the limits are quite high. | | | | | | Could somebody advice me on how to go about solving this problem? | | | | | | I look forward to hearing from you soon. | | | | | | Thanks in advance. | | | | | | George | | | | | | I think there is a world market for maybe five computers. | | | Thomas Watson, Chairman of IBM, 1943. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
oscom table structure
are there any of you guys really familar with the mysql table structure of oscommerce and in particular the search queries? Andrew -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Working with the text datatype in Mysql
Nope, same situation...When you hit the submit button, nothing happens...I check the database afterwards and find out that nothing was inserted... George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: Rob A. Brahier [EMAIL PROTECTED] To: Lekeas GK [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:01 PM Subject: RE: Working with the text datatype in Mysql | hmm, add this after your mysql_query() line in the script | | echo mysql_error(); | | Does that return anything? | | | -Original Message- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 11:52 AM | To: Rob A. Brahier | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | | Rob, | | The script is indeed written in PHP version 4.3.1. The full version of mysql | I am using is 3.23.30-gamma. | | Thanks, | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | - Original Message - | From: Rob A. Brahier [EMAIL PROTECTED] | To: Lekeas GK [EMAIL PROTECTED] | Sent: Friday, July 18, 2003 4:31 PM | Subject: RE: Working with the text datatype in Mysql | | | | George, | | You keep leaving out the vital bits. What are your sers using to enter | | this data? We know it's a web page, but what script does that web page | run | | when the user submits their data? Is it a script written in the PHP | | programming language or something else? What is the FULL version number | of | | the MySQL server you are using, and what is the version of the programming | | language that you wrote your script in? | | | | -Rob | | | | -Original Message- | | From: Lekeas GK [mailto:[EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 10:17 AM | | To: gerald_clark | | Cc: [EMAIL PROTECTED] | | Subject: Re: Working with the text datatype in Mysql | | | | | | The checking is done from the mysql command line tool and all special | | characters are properly quoted (even tried it with a sequence of | characters | | without any punctuation marks or anything else). The mysql_query() call | has | | a die() statement as well but it is not coming up. | | | | George | | | | I think there is a world market for maybe five computers. | | Thomas Watson, Chairman of IBM, 1943. | | | | - Original Message - | | From: gerald_clark [EMAIL PROTECTED] | | To: Lekeas GK [EMAIL PROTECTED] | | Cc: [EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 3:00 PM | | Subject: Re: Working with the text datatype in Mysql | | | | | | | | | | | | | Lekeas GK wrote: | | | | | | Gerald, | | | | | | The version of MySQL is 3.23, | | | | | | That only spans 50 some odd releases. Which one? | | | | | | the platform is Solaris, the language is | | | English | | | | | | Computer language. | | | PHP? | | | Perl? | | | Python? | | | Mysql command line tool? | | | | | | Did the program performing the insert properly quote special characters? | | | Did it check for sucess of the insert? | | | | | | and the way I check whether data has been entered in the database or | | | not is by running a select query on the database. | | | | | | Useing Which language above? | | | | | | | | | Was that of any help? I tried searching the net but couldn't find more | | | information about what might be causing the problem... | | | | | | Thanks, | | | George | | | | | | I think there is a world market for maybe five computers. | | | Thomas Watson, Chairman of IBM, 1943. | | | | | | - Original Message - | | | From: gerald_clark [EMAIL PROTECTED] | | | To: Lekeas GK [EMAIL PROTECTED] | | | Cc: [EMAIL PROTECTED] | | | Sent: Friday, July 18, 2003 2:11 PM | | | Subject: Re: Working with the text datatype in Mysql | | | | | | | | | | You supply almost no useful information here. | | | | What version of MySQL are you using? | | | | What platform? | | | | What language? | | | | How do you check to see if anything was entered? | | | | | | | | | | | | Lekeas GK wrote: | | | | | | | | Hi All, | | | | | | | | I am managing a small database where a few fields are defined as | being | | of | | | | type text. In my understanding, this would allow the user to enter | up | | to | | | | about 65,000 characters in the text field. | | | | | | | | However, if the user types about 2,000 characters, then nothing is | | | entered | | | | in the database. I have checked the max_packet_allowed and the | | | | net_buffer_length and the limits are quite high. | | | | | | | | Could somebody advice me on how to go about solving this problem? | | | | | | | | I look forward to hearing from you soon. | | | | | | | | Thanks in advance. | | | | | | | | George | | | | | | | | I think there is a world market for maybe five computers. | | | | Thomas Watson, Chairman of IBM, 1943. | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | | -- MySQL General Mailing List For list
Re: group before join
At 12:40 -0400 7/18/03, John Larsen wrote: Does anybody know if there is a way to aggregate a table then join it to another table? I assume this would be possible with a subquery as in SELECT * FROM t1 WHERE t1.a=(SELECT sum(t2.b) FROM t2 group by t2.c); Except when I do it with 4.1alpha I get error [root] ERROR 1240: Subselect returns more than 1 record I though that was the whole point of a subselect is that you got more than 1 record Not all subselects. The = subselect must return a single value. You may want to use IN instead, which allows a column of values. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: (SQL Question) WHERE NOT IN A LIST
At 12:29 -0500 7/18/03, Tom O'Neill (MySQL User) wrote:
Hi,
Is there a way I can run a query that will delete all items that are not in
a list? For example I have a bunch of records in a table and I want to
remove all of them that are not in a comma delimited list that I have
recieved from another application. I was thinking that I could create a
query that says:
WHERE id != 'item1' AND id != 'item2' AND id != 'item3'... etc but I was
wondering if there is an easier/more effecient way?
Thanks!
-Tom
... WHERE id NOT IN('item1','item2','item3',)
You cannot use NULL in the value list.
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
high availability sync of 3 hosts
Hello, I am trying to find a solution for the following scenario. The topic is replication/high-availability/redundancy and sync. I have three computers, A, B and C. A and B are operating important hardware (astronomical telescopes TEL_A and TEL_B), and the operation parameters as well as logs of operations are stored in a MySQL database. I prefer having a central database (DB_C) for this purpose, in fact located on C, from which I can overview parameters and logs of A and B simultaneously. During normal operation, A and B reads/writes only DB_C: C - DB_C | | -- - | | A - TEL_A B - TEL_B (|) (|) (|) (|) DB_A DB_B However, if for some reason the central C host goes down, or internet connection is broken, I would like to achieve the following: A and B to continues standalone operation (read-write) with the freshest possible local DB: C - DB_C | | X X X X X X X X X X X | | A - TELESCOPE_AB - TEL_B | | DB_A DB_B I guess this has to be done with continuous slave-master replication between DB_A -- DB_C and DB_B -- DB_C while the internet connection is alive. When the internet connection is resumed, or the central DB is available again, I would like [to realize that DB_C is available again, and] DB_C to be syncronized with the changes made in DB_A and DB_B (the changes, of course, are different in the two replicas). In other words, we have a synced system of A, B and C, and we have the possibility of A and B slowly diverging from C temporarily. Then we'd like to sync up the system again. What would you recommend? Maybe there is a problem with my concept. All the best, Gaspar -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Deleting a database....
Ola Ogunneye wrote: Hello all, I have just finally finished my error free installation of mysql 4.0.13 on Apache 2.0.47 and PHP 4.3.2 all running on Windows 2000 Advanced Server. I was able to follow a direction that helped me change the root user to myname and asign a password to myname. After that, I created 3 databases in addition to the test and mysql that were already created through the install process. My problem is that when I created the databases, I did not do anything else - no tables. I am running another application (Geeklog) and in the install of Geeklog, I got an error message saying that the Table gl_access already exist when I went to Geeklog forum help, it says that my problem is that I had performed an unsuccessful installation prior to this successful one, and therefore, I need to delete the table or better yet, delete the database and create a new one to use with Geeklog installation. The real question is that I do not know what would happen if I delete the database, and how do I delete the database? I thought it is something I could do at the command prompt just the same way I created the database: mysqlcreate database dbasenow would the following work: mysqldelete database dbasenow Or do I have to delete the tables in it first? Please understand that when I created the databases, I did not create any tables, but when I used PHPMYADMIN, I found that the database in question has tables in it while the other 2 that I created had nothing in them.. Thank you all in advance... Ola Hi Ola: To delete a database use the DROP DATABASE command at the command prompt as follows: drop database dbasenow [That's, of course assuming your database is named dbasenow] -- Peter K. Aganyo Eternal Designs Inc., +1(617)344-8023 (fax voicemail) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Replication Problem
First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error 'Server shutdown in progress'... but Uptime on the Master and Slave both show dates that are older than when the error occurred. This problem has been occurring for ~ 2 weeks. 3 days ago I moved the Slave into the same rack as the master so they would be on the same subnet/switch, but the problem still exists. I could implement a perl script to just check the replication status, and take necessary action to restart the slave if the SQL thread is down, but I was wondering if a more elegant solution existed. Thanks James ([EMAIL PROTECTED]) [(none)] show slave status\G *** 1. row *** Master_Host: Replaced Master_User: Replaced Master_Port: Replaced Connect_retry: 60 Master_Log_File: MASTER-bin.010 Read_Master_Log_Pos: 131845183 Relay_Log_File: SLAVE001-relay-bin.004 Relay_Log_Pos: 257067861 Relay_Master_Log_File: MASTER-bin.010 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: MASTER Replicate_ignore_db: Last_errno: 1053 Last_error: error 'Server shutdown in progress' on query 'UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' Skip_counter: 0 Exec_master_log_pos: 108378574 Relay_log_space: 280534474 1 row in set (0.00 sec) ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:11:27 | +-+ 1 row in set (0.02 sec) ([EMAIL PROTECTED]) [(none)] start slave; Query OK, 0 rows affected (36.25 sec) ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) Connection id: 5239 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.13 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/replication.sock Uptime: 3 days 15 hours 26 min 43 sec Then on my master. ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) Connection id: 71764 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: more Using outfile: '' Server version: 4.0.13-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 16 days 19 hours 7 min 47 sec Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush tables: 1 Open tables: 64 Queries per second avg: 36.901 -- ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:16:26 | +-+ 1 row in set (0.00 sec) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
multiple ORs
Hi This has probably come up before... Using version 3.23.54 I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. I know i can say where != if the the OR count is more than half the list items Is there any other way to provide optimization for this? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:07 PM Subject: Replication Problem First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error 'Server shutdown in progress'... but Uptime on the Master and Slave both show dates that are older than when the error occurred. This problem has been occurring for ~ 2 weeks. 3 days ago I moved the Slave into the same rack as the master so they would be on the same subnet/switch, but the problem still exists. I could implement a perl script to just check the replication status, and take necessary action to restart the slave if the SQL thread is down, but I was wondering if a more elegant solution existed. Thanks James ([EMAIL PROTECTED]) [(none)] show slave status\G *** 1. row *** Master_Host: Replaced Master_User: Replaced Master_Port: Replaced Connect_retry: 60 Master_Log_File: MASTER-bin.010 Read_Master_Log_Pos: 131845183 Relay_Log_File: SLAVE001-relay-bin.004 Relay_Log_Pos: 257067861 Relay_Master_Log_File: MASTER-bin.010 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: MASTER Replicate_ignore_db: Last_errno: 1053 Last_error: error 'Server shutdown in progress' on query 'UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' Skip_counter: 0 Exec_master_log_pos: 108378574 Relay_log_space: 280534474 1 row in set (0.00 sec) ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:11:27 | +-+ 1 row in set (0.02 sec) ([EMAIL PROTECTED]) [(none)] start slave; Query OK, 0 rows affected (36.25 sec) ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) Connection id: 5239 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.13 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/replication.sock Uptime: 3 days 15 hours 26 min 43 sec Then on my master. ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) Connection id: 71764 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: more Using outfile: '' Server version: 4.0.13-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 16 days 19 hours 7 min 47 sec Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush tables: 1 Open tables: 64 Queries per second avg: 36.901 -- ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:16:26 | +-+ 1 row in set (0.00 sec) -- 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]
read in a .sql file
I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. I am not thinking load data infile because it isn't text... Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
If your data is properly Normalized, then this is the best way. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Chris Edwards wrote: Hi This has probably come up before... Using version 3.23.54 I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. I know i can say where != if the the OR count is more than half the list items Is there any other way to provide optimization for this? Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:07 PM Subject: Replication Problem First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error 'Server shutdown in progress'... but Uptime on the Master and Slave both show dates that are older than when the error occurred. This problem has been occurring for ~ 2 weeks. 3 days ago I moved the Slave into the same rack as the master so they would be on the same subnet/switch, but the problem still exists. I could implement a perl script to just check the replication status, and take necessary action to restart the slave if the SQL thread is down, but I was wondering if a more elegant solution existed. Thanks James ([EMAIL PROTECTED]) [(none)] show slave status\G *** 1. row *** Master_Host: Replaced Master_User: Replaced Master_Port: Replaced Connect_retry: 60 Master_Log_File: MASTER-bin.010 Read_Master_Log_Pos: 131845183 Relay_Log_File: SLAVE001-relay-bin.004 Relay_Log_Pos: 257067861 Relay_Master_Log_File: MASTER-bin.010 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: MASTER Replicate_ignore_db: Last_errno: 1053 Last_error: error 'Server shutdown in progress' on query 'UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' Skip_counter: 0 Exec_master_log_pos: 108378574 Relay_log_space: 280534474 1 row in set (0.00 sec) ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:11:27 | +-+ 1 row in set (0.02 sec) ([EMAIL PROTECTED]) [(none)] start slave; Query OK, 0 rows affected (36.25 sec) ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) Connection id: 5239 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.13 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/replication.sock Uptime: 3 days 15 hours 26 min 43 sec Then on my master. ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) Connection id: 71764 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: more Using outfile: '' Server version: 4.0.13-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 16 days 19 hours 7 min 47 sec Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush tables: 1 Open tables: 64 Queries per second avg: 36.901 -- ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:16:26 | +-+ 1 row in set (0.00 sec) -- 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] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: read in a .sql file
after creating the database with mysql create DATABASE do a mysql .sqlfile. Make sure to add the line use DATABASENAME; at the top of the sql file. On Fri, 2003-07-18 at 14:44, Taylor Lewick wrote: I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. I am not thinking load data infile because it isn't text... Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
At 15:42 -0400 7/18/03, Chris Edwards wrote: Hi This has probably come up before... Using version 3.23.54 I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. I know i can say where != if the the OR count is more than half the list items Is there any other way to provide optimization for this? WHERE id IN(1,2,3,...) NULL cannot be in the value list. Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:07 PM Subject: Replication Problem First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error 'Server shutdown in progress'... but Uptime on the Master and Slave both show dates that are older than when the error occurred. This problem has been occurring for ~ 2 weeks. 3 days ago I moved the Slave into the same rack as the master so they would be on the same subnet/switch, but the problem still exists. I could implement a perl script to just check the replication status, and take necessary action to restart the slave if the SQL thread is down, but I was wondering if a more elegant solution existed. Thanks James ([EMAIL PROTECTED]) [(none)] show slave status\G *** 1. row *** Master_Host: Replaced Master_User: Replaced Master_Port: Replaced Connect_retry: 60 Master_Log_File: MASTER-bin.010 Read_Master_Log_Pos: 131845183 Relay_Log_File: SLAVE001-relay-bin.004 Relay_Log_Pos: 257067861 Relay_Master_Log_File: MASTER-bin.010 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: MASTER Replicate_ignore_db: Last_errno: 1053 Last_error: error 'Server shutdown in progress' on query 'UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' Skip_counter: 0 Exec_master_log_pos: 108378574 Relay_log_space: 280534474 1 row in set (0.00 sec) ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:11:27 | +-+ 1 row in set (0.02 sec) ([EMAIL PROTECTED]) [(none)] start slave; Query OK, 0 rows affected (36.25 sec) ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) Connection id: 5239 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.13 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/replication.sock Uptime: 3 days 15 hours 26 min 43 sec Then on my master. ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) Connection id: 71764 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: more Using outfile: '' Server version: 4.0.13-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 16 days 19 hours 7 min 47 sec Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush tables: 1 Open tables: 64 Queries per second avg: 36.901 -- ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:16:26 | +-+ 1 row in set (0.00 sec) -- 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] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: read in a .sql file
At 14:44 -0500 7/18/03, Taylor Lewick wrote: I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. mysql file.sql or mysql db_name file.sql if you need to set the database name first. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: read in a .sql file
Thanks all, I had to use the use database name as well as put the password in the first line and that worked... Paul DuBois [EMAIL PROTECTED] 07/18/03 02:59PM At 14:44 -0500 7/18/03, Taylor Lewick wrote: I have a large SQL file that contains a bunch of create table statements... How do I get mysql to read in this file and process the sql. mysql file.sql or mysql db_name file.sql if you need to set the database name first. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ Please Note The information in this E-mail message is legally privileged and confidential information intended only for the use of the individual(s) named above. If you, the reader of this message, are not the intended recipient, you are hereby notified that you should not further disseminate, distribute, or forward this E-mail message. If you have received this E-mail in error, please notify the sender. Thank you * -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SELECT help
HI all! I want make the SELECT for this situation. Example: Twarehouse -- IDname --- 01Spring_WH 02Screw_WH 03Toll_WH Tparts -- IDname --- 01M3 screw 02M4 screw 03Hammer Tmovement -- part_ID incoming_IDoutgoing_ID quantity ---- - 01010210 0201031 0302015 I want build list about movement, with warehouse's names SELECT twarehouse.name, ??# incoming warehouse name twarehouse.name, ??# outgoing warehouse name tparts.name, tmovement.quantity FROM tparts, twarehouse INNER JOIN tmovement ON tmovement.part_ID=tparts.ID AND tmovement.incoming_ID=twarehouse.ID AND tmovement.outgoing_ID=twarehouse.ID Please help me, who can . How can I do?? I don't want make temorary table, if is possible Thank You!
Crash on mysql_real_connect on FreeBSD 4.7
Hey all,
Have a very peculiar problem. First off -
OS: FreeBSD 4.7
MySQL version: Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.7 (i386)
(I have also compiled 3.23.53)
The problem:
I have written a class that connects to and disconnects from the database.
Everything works fine when I instantiate this class in another class to do
some work, but when that class instantiates yet another class then it seems
as though mysql_real_connect bombs, and I have a core file.
In other works
Works:
class1 {
function foo() {
MYSQL mysql
db.connect (mysql)
}
};
Does not work:
Class1 {
function foo() {
Class2 cl2;
cl2.fod()
}
}
Class2 {
function fod() {
db.connect()
}
}
I have done all sorts of debugging and inspection, but I am unable to figure
out what is causing this. Please send any ideas.
DB function is here.
(mysql_ptr points to a valid MYSQL object elsewhere)
MYSQL *DB::db_connect (MYSQL* mysql_ptr) {
/*
* connect to the database
*/
char msg_buffer[2000];
Log log;
/*
* initialize the MYSQL pointer
*/
mysql_ptr = mysql_init(mysql_ptr);
if (mysql_ptr == NULL) {
printf (ERROR: ptr is null!\n);
}
if (!(mysql_real_connect (mysql_ptr, borg.db_host,
borg.db_username,\
borg.db_passwd, borg.db_name, atoi(borg.db_port), NULL, 0))) {
memset (msg_buffer, 0, sizeof(msg_buffer));
sprintf (msg_buffer, ERROR: Failed to connect to database:
Error: %s., mysql_error(mysql_ptr));
log.log_entry (0, msg_buffer);
return NULL;
}
return mysql_ptr;
};
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: SELECT help
Try with : SELECT tparts.name, a.name, b.name, tmovement.quantity FROMtmovement inner join tparts on (tmovement.part_id = tparts.Id) inner join twarehouse a on ( tmovement.incoming_id = a.Id ) inner join twarehouse b on ( tmovement.outgoing_id = b.Id ) Ulises -Mensaje original- De: Gyurasits Zoltan [mailto:[EMAIL PROTECTED] Enviado el: Martes 18 de Febrero de 2003 04:11 PM Para: MYSQL Lista Asunto: SELECT help HI all! I want make the SELECT for this situation. Example: Twarehouse -- IDname --- 01Spring_WH 02Screw_WH 03Toll_WH Tparts -- IDname --- 01M3 screw 02M4 screw 03Hammer Tmovement -- part_ID incoming_IDoutgoing_ID quantity ---- - 01010210 0201031 0302015 I want build list about movement, with warehouse's names SELECT twarehouse.name, ??# incoming warehouse name twarehouse.name, ??# outgoing warehouse name tparts.name, tmovement.quantity FROM tparts, twarehouse INNER JOIN tmovement ON tmovement.part_ID=tparts.ID AND tmovement.incoming_ID=twarehouse.ID AND tmovement.outgoing_ID=twarehouse.ID Please help me, who can . How can I do?? I don't want make temorary table, if is possible Thank You!
Re: SELECT help
Hi This is working... Thank You Zoltan - Original Message - From: Cabanillas Dulanto, Ulises [EMAIL PROTECTED] To: MYSQL Lista [EMAIL PROTECTED] Sent: Friday, July 18, 2003 10:54 PM Subject: RE: SELECT help Try with : SELECT tparts.name, a.name, b.name, tmovement.quantity FROMtmovement inner join tparts on (tmovement.part_id = tparts.Id) inner join twarehouse a on ( tmovement.incoming_id = a.Id ) inner join twarehouse b on ( tmovement.outgoing_id = b.Id ) Ulises -Mensaje original- De: Gyurasits Zoltan [mailto:[EMAIL PROTECTED] Enviado el: Martes 18 de Febrero de 2003 04:11 PM Para: MYSQL Lista Asunto: SELECT help HI all! I want make the SELECT for this situation. Example: Twarehouse -- IDname --- 01Spring_WH 02Screw_WH 03Toll_WH Tparts -- IDname --- 01M3 screw 02M4 screw 03Hammer Tmovement -- -- -- part_ID incoming_IDoutgoing_ID quantity ---- - 01010210 0201031 0302015 I want build list about movement, with warehouse's names SELECT twarehouse.name, ??# incoming warehouse name twarehouse.name, ??# outgoing warehouse name tparts.name, tmovement.quantity FROM tparts, twarehouse INNER JOIN tmovement ON tmovement.part_ID=tparts.ID -- -- AND tmovement.incoming_ID=twarehouse.ID AND tmovement.outgoing_ID=twarehouse.ID Please help me, who can . How can I do?? I don't want make temorary table, if is possible Thank You! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
Paul, Does this optimize the query? I thought both of the queries will have the same relational algebra representation. Am I wrong? Thanks. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Paul DuBois wrote: At 15:42 -0400 7/18/03, Chris Edwards wrote: Hi This has probably come up before... Using version 3.23.54 I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. I know i can say where != if the the OR count is more than half the list items Is there any other way to provide optimization for this? WHERE id IN(1,2,3,...) NULL cannot be in the value list. Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com - Original Message - From: James [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 2:07 PM Subject: Replication Problem First off, this is the first time I have done replication in MySQL so the problem very well may be my fault. I run a simple master / slave setup that Replicates one database. Replication works for a day or two then for reasons unknown to me I see this on show slave status, Last_error: error 'Server shutdown in progress'... but Uptime on the Master and Slave both show dates that are older than when the error occurred. This problem has been occurring for ~ 2 weeks. 3 days ago I moved the Slave into the same rack as the master so they would be on the same subnet/switch, but the problem still exists. I could implement a perl script to just check the replication status, and take necessary action to restart the slave if the SQL thread is down, but I was wondering if a more elegant solution existed. Thanks James ([EMAIL PROTECTED]) [(none)] show slave status\G *** 1. row *** Master_Host: Replaced Master_User: Replaced Master_Port: Replaced Connect_retry: 60 Master_Log_File: MASTER-bin.010 Read_Master_Log_Pos: 131845183 Relay_Log_File: SLAVE001-relay-bin.004 Relay_Log_Pos: 257067861 Relay_Master_Log_File: MASTER-bin.010 Slave_IO_Running: Yes Slave_SQL_Running: No Replicate_do_db: MASTER Replicate_ignore_db: Last_errno: 1053 Last_error: error 'Server shutdown in progress' on query 'UPDATE LOW_PRIORITY thread SET views=views+1 WHERE threadid='154039'' Skip_counter: 0 Exec_master_log_pos: 108378574 Relay_log_space: 280534474 1 row in set (0.00 sec) ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:11:27 | +-+ 1 row in set (0.02 sec) ([EMAIL PROTECTED]) [(none)] start slave; Query OK, 0 rows affected (36.25 sec) ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.18 Distrib 4.0.12, for unknown-freebsd4.8 (i386) Connection id: 5239 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: /usr/bin/less Using outfile: '' Server version: 4.0.13 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/replication.sock Uptime: 3 days 15 hours 26 min 43 sec Then on my master. ([EMAIL PROTECTED]) [(none)] status; -- mysql Ver 12.20 Distrib 4.0.13, for unknown-freebsd4.8 (i386) Connection id: 71764 Current database: Current user: [EMAIL PROTECTED] SSL:Not in use Current pager: more Using outfile: '' Server version: 4.0.13-log Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 16 days 19 hours 7 min 47 sec Threads: 92 Questions: 53552863 Slow queries: 698 Opens: 83017 Flush tables: 1 Open tables: 64 Queries per second avg: 36.901 -- ([EMAIL PROTECTED]) [(none)] select now(); +-+ | now() | +-+ | 2003-07-18 10:16:26 | +-+ 1 row in set (0.00 sec) -- 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] -- Paul DuBois, Senior
Re: Working with the text datatype in Mysql
Hi Rob, Error_reporting is set to 2039 and the script is not written in an object-oriented way. When you type too many characters in the textarea, you can't even get a simple print(Hello World!); statement to work; I am really surprised with that... Could you please offer any other perspectives of what might be going wrong? George I think there is a world market for maybe five computers. Thomas Watson, Chairman of IBM, 1943. - Original Message - From: Rob A. Brahier [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 5:43 PM Subject: RE: Working with the text datatype in Mysql | So this happens even with shorter blocks of text? This is going to take | some narrowing down. Make a new PHP file in the same directory as your | script. It should contain only one line: | | ?php phpinfo(); ? | | Navigate to that in your web browser. You should see a pre-generated PHP | page come on the screen. Do a search for 'error_reporting' and tell me what | it's set to. | Ideas off the top of my head: | --If error_reporting is turned off then your script might be dying at an | earlier part of your script. | --If your script is written in an object-oriented style then you might be | sure you have a new MyObjectNameGoesHere() type of call somewhere outisde of | the function. | --Try adding an echo to the very beginning of your file, just after the | opening ?php tag. See if it will return even a plain text string that way. | --Lastly, check your apache log file--it should usually be in | /path/to/apache/logs/error_log. See if there are any errors in there from | when you last ran the script--it may be crashing. | | -Rob | | -Original Message- | From: Lekeas GK [mailto:[EMAIL PROTECTED] | Sent: Friday, July 18, 2003 12:29 PM | To: Rob A. Brahier | Cc: [EMAIL PROTECTED] | Subject: Re: Working with the text datatype in Mysql | | | Nope, same situation...When you hit the submit button, nothing happens...I | check the database afterwards and find out that nothing was inserted... | | George | | I think there is a world market for maybe five computers. | Thomas Watson, Chairman of IBM, 1943. | | - Original Message - | From: Rob A. Brahier [EMAIL PROTECTED] | To: Lekeas GK [EMAIL PROTECTED] | Sent: Friday, July 18, 2003 5:01 PM | Subject: RE: Working with the text datatype in Mysql | | | | hmm, add this after your mysql_query() line in the script | | | | echo mysql_error(); | | | | Does that return anything? | | | | | | -Original Message- | | From: Lekeas GK [mailto:[EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 11:52 AM | | To: Rob A. Brahier | | Cc: [EMAIL PROTECTED] | | Subject: Re: Working with the text datatype in Mysql | | | | | | Rob, | | | | The script is indeed written in PHP version 4.3.1. The full version of | mysql | | I am using is 3.23.30-gamma. | | | | Thanks, | | George | | | | I think there is a world market for maybe five computers. | | Thomas Watson, Chairman of IBM, 1943. | | | | - Original Message - | | From: Rob A. Brahier [EMAIL PROTECTED] | | To: Lekeas GK [EMAIL PROTECTED] | | Sent: Friday, July 18, 2003 4:31 PM | | Subject: RE: Working with the text datatype in Mysql | | | | | | | George, | | | You keep leaving out the vital bits. What are your sers using to enter | | | this data? We know it's a web page, but what script does that web page | | run | | | when the user submits their data? Is it a script written in the PHP | | | programming language or something else? What is the FULL version number | | of | | | the MySQL server you are using, and what is the version of the | programming | | | language that you wrote your script in? | | | | | | -Rob | | | | | | -Original Message- | | | From: Lekeas GK [mailto:[EMAIL PROTECTED] | | | Sent: Friday, July 18, 2003 10:17 AM | | | To: gerald_clark | | | Cc: [EMAIL PROTECTED] | | | Subject: Re: Working with the text datatype in Mysql | | | | | | | | | The checking is done from the mysql command line tool and all special | | | characters are properly quoted (even tried it with a sequence of | | characters | | | without any punctuation marks or anything else). The mysql_query() call | | has | | | a die() statement as well but it is not coming up. | | | | | | George | | | | | | I think there is a world market for maybe five computers. | | | Thomas Watson, Chairman of IBM, 1943. | | | | | | - Original Message - | | | From: gerald_clark [EMAIL PROTECTED] | | | To: Lekeas GK [EMAIL PROTECTED] | | | Cc: [EMAIL PROTECTED] | | | Sent: Friday, July 18, 2003 3:00 PM | | | Subject: Re: Working with the text datatype in Mysql | | | | | | | | | | | | | | | | | | Lekeas GK wrote: | | | | | | | | Gerald, | | | | | | | | The version of MySQL is 3.23, | | | | | | | | That only spans 50 some odd releases. Which one? | | | | | | | | the platform is Solaris, the language is | | | | English | | | | | | | | Computer language. | | | | PHP? | | | | Perl? | | | | Python? | | | | Mysql command line
Greetings All
I would like to use MySQL++ in an application I am writing in Visual Studio.NET 2003. Does anyone out there have or could point me to a zip of the source that could easily be compiled for this purpose. The VC++6 one gave me 157 errors, which would be a bear to track down. Thanks! Ron Ohmer
Re: Greetings All
If you've got 157 errors it probably won't be to hard to track down. What are the 1st couple of errors? You probably don't have your environment set correctly. Pat... [EMAIL PROTECTED] SW Florida's 1st ISP - Original Message - From: Ron Ohmer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, July 18, 2003 6:44 PM Subject: Greetings All I would like to use MySQL++ in an application I am writing in Visual Studio.NET 2003. Does anyone out there have or could point me to a zip of the source that could easily be compiled for this purpose. The VC++6 one gave me 157 errors, which would be a bear to track down. Thanks! Ron Ohmer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Fri, 18 Jul 2003 15:42:47 -0400, Chris Edwards wrote: I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. You can also do this: where id in (1,2,3) - -- jimoe at sohnen-moe dot com pgp/gpg public key: http://www.keyserver.net/en/ -BEGIN PGP SIGNATURE- Version: PGPfreeware 5.0 OS/2 for non-commercial use Comment: PGP 5.0 for OS/2 Charset: cp850 wj8DBQE/GH0hsxxMki0foKoRAtVrAKCN+MWBcMuK8HxsvK6xb1a6fRW1nQCfRyCs eT4T5dAmnjkhSkYC4jGxD6E= =MK4O -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Version 5
After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use the SP functions to duplicate stuff in SQLServer for possible migration.
Re: oscom table structure
Hi Andrew, Unfortunately I am not, but I figured that it would probbaly take only 30-60 minutes to get the system set up on a machine ;-) Have you tried it yet ? You could login and use SHOW TABLES; DESCRIBE TABLES; to find the information you require. Best regards Nils Valentin Tokyo/Japan 2003 7 19 01:24Andrew : are there any of you guys really familar with the mysql table structure of oscommerce and in particular the search queries? Andrew -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help: cannot connect on localhost (10061)
At 15:15 -0500 7/18/03, Kyle Goetz wrote: hey, i'm new to mySQL...this meaning that i have tried ~1 times to install it and get it working over the past few weeks...and it always gives me the same error (scroll further down to see it) despite following the manual's windows installation exactly i have version 4.0.13 for windows and i used the installer once i was done, i followed the instructions in the manual exactly i have no firewall running i am on windows XP i am running the client and server on the same computer i ran winmysqladmin and it starts up fine the 'mysqld-nt' service is in my processes tab of task manager i go to dos prompt and type net start and mysql is there running fine You're sure? Look in C:\mysql\data for the .err file and take a look at it. Does it indicate any problems starting the server? The error you show below is typical for a situation in which the MySQL server is not actually running. however, when in c:\mysql\bin and i run 'mySQL' i get this error: ERROR 2003: Can't connect to MySQL server on 'localhost' (10061) i have tried devshed, mysql help, etc. and cannot figure out why mine doesn't work...it seems most people just reboot and it voile! works... but i've rebooted over and over and over, and nothing changes...same error... when i use mySQL Control Center v0.9.2-beta i get the same error when i click Action-Connect all i can say is ARGH! all i can ask is does anyone have any idea why this happens? or how to stop it? i can telnet to port 3306, and get this readout (i have no idea how really to use telnet...) c:\telnet localhost 3306 * 4.0.13-nt?;[EMAIL PROTECTED],? ??ܶBad handshake Connection to host lost. (this when i press backspace, so i understand you don't do that in telnet...) i guess it is getting to mySQL, cuz the 4.0.13 at the beginning is my version of mySQL i'll paste my my.ini (which is in c:\windows) thanks so much, \Kyle, who has been frustrated for a while now... --beginning of my.ini #This File was made using the WinMySQLAdmin 1.4 Tool #7/18/2003 3:06:59 PM #Uncomment or Add only the keys that you know how works. #Read the MySQL Manual for instructions [mysqld] basedir=C:/mysql #bind-address=127.0.0.1 datadir=C:/mysql/data #language=C:/mysql/share/your language directory #slow query log#= #tmpdir#= #port=3306 #set-variable=key_buffer=16M [WinMySQLadmin] Server=C:/mysql/bin/mysqld-nt.exe user=sakurak password=sfzero2 --end of my.ini -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Installing MySQL 4 on Windows 2000
Hi!! I had once installed PHPTriad, a package which installs php, apache and mysql on windows machines, and since I wanted to update my mysql and php version I uninstalled the package. Then I tried installing php manually and did the smae with mysql, installing it under a different hd. The problem is that the mysql version I had with phptriad was installed as a service. And I wanted to do the same with this new version. But I don`t know how to uninstall the old mysql server to install the new version. I tried the manual but couldn`t find the answer... can anyone please help me do this? Thanks in advance... Decio --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/03
Re: Installing MySQL 4 on Windows 2000
From the Manual section 2.2.2.1 1. If you are working on an NT/2000/XP server, logon as a user with administrator privileges. 2. If you are doing an upgrade of an earlier MySQL installation, it is necessary to stop the server. If you are running the server as a service, use: C:\ NET STOP MySQL Otherwise, use: C:\mysql\bin mysqladmin -u root shutdown 3. On NT/2000/XP machines, if you want to change the server executable (e.g., -max or -nt), it is also necessary to remove the service: C:\mysql\bin mysqld-max-nt --remove 4. Unzip the distribution file to a temporary directory. 5. Run the `setup.exe' file to begin the installation process. If you want to install into another directory than the default `c:\mysql', use the Browse button to specify your preferred directory. 6. Finish the install process. [EMAIL PROTECTED] wrote: Hi!! I had once installed PHPTriad, a package which installs php, apache and mysql on windows machines, and since I wanted to update my mysql and php version I uninstalled the package. Then I tried installing php manually and did the smae with mysql, installing it under a different hd. The problem is that the mysql version I had with phptriad was installed as a service. And I wanted to do the same with this new version. But I don`t know how to uninstall the old mysql server to install the new version. I tried the manual but couldn`t find the answer... can anyone please help me do this? Thanks in advance... Decio --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/03
Re: Installing MySQL 4 on Windows 2000
Also: PhpTriad is now Sokkit. I'm having a very hard time getting PhP to post to Mysql. I sent them an email requesting help. Will try to remember to give you any answers I get from them. [EMAIL PROTECTED] wrote: Hi!! I had once installed PHPTriad, a package which installs php, apache and mysql on windows machines, and since I wanted to update my mysql and php version I uninstalled the package. Then I tried installing php manually and did the smae with mysql, installing it under a different hd. The problem is that the mysql version I had with phptriad was installed as a service. And I wanted to do the same with this new version. But I don`t know how to uninstall the old mysql server to install the new version. I tried the manual but couldn`t find the answer... can anyone please help me do this? Thanks in advance... Decio --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.500 / Virus Database: 298 - Release Date: 10/07/03 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Version 5
At 19:15 -0500 7/18/03, Andy Hartman wrote: After I downloaded the Ver 5 Dev tree how do I get it active. I tried the Windows stuff on the Mysql site with no luck. the Windows stuff? Please be more specific. The INSTALL-WIN-SOURCE file in the top-level directory of the source tree may be of some use. However, because MySQL 5 is available only from the BitKeeper repository, you'll need to use the approach that requires you to configure a distribution for Windows by using a Unix machine. I run WIndows/ME and have Ver3.23 running. When I try to use the instructions for Compile it fails looking for .c pgms How do I get this to work... would like to use the SP functions to duplicate stuff in SQLServer for possible migration. -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: multiple ORs
At 14:25 -0700 7/18/03, SAQIB wrote: Paul, Does this optimize the query? I thought both of the queries will have the same relational algebra representation. Am I wrong? They're logically equivalent, yes. You appear to be under the impression that MySQL will *not* optimize your original statement. OR defeats the optimizer when it's used to join tests on different keys, but your statement uses the same key for all the comparisons. Thanks. Saqib Ali - http://www.xml-dev.com On Fri, 18 Jul 2003, Paul DuBois wrote: At 15:42 -0400 7/18/03, Chris Edwards wrote: Hi This has probably come up before... Using version 3.23.54 I have multiple OR logic in the where clause. where id = 1 or id = 2 or id = 3 The list is finite, at about 20 ids. I know i can say where != if the the OR count is more than half the list items Is there any other way to provide optimization for this? WHERE id IN(1,2,3,...) NULL cannot be in the value list. Thanks. -- Chris Edwards Web Application Developer Outer Banks Internet, Inc. 252-441-6698 [EMAIL PROTECTED] http://www.OuterBanksInternet.com -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Multiple Tables for Categories Products
TASK: I have to generate a report with all categories, subcategories and products in database. PROBLEM: I want to write one query that will return: 1. category 2. subcategory: determined by parent_id 3. products in each category or subcategory. I have four tables with the following structure: --- CREATE TABLE `categories` ( `categories_id` int(11) NOT NULL auto_increment, `parent_id` int(11) NOT NULL default '0', `sort_order` int(3) default NULL, PRIMARY KEY (`categories_id`), ) INSERT INTO `categories` VALUES (1, 0, 1); INSERT INTO `categories` VALUES (2, 1, 1); INSERT INTO `categories` VALUES (3, 0, 2); INSERT INTO `categories` VALUES (4, 3, 1); CREATE TABLE `categories_description` ( `categories_id` int(11) NOT NULL default '0', `categories_name` varchar(32) NOT NULL default '', PRIMARY KEY (`categories_id`), ) INSERT INTO `categories_description` VALUES (1, 'Sedans'); INSERT INTO `categories_description` VALUES (2, 'Honda'); INSERT INTO `categories_description` VALUES (3, 'Luxury'); INSERT INTO `categories_description` VALUES (4, 'Mercedez'); CREATE TABLE `products_to_categories` ( `products_id` int(11) NOT NULL default '0', `categories_id` int(11) NOT NULL default '0', PRIMARY KEY (`products_id`,`categories_id`) ) INSERT INTO `products_to_categories` VALUES (100, 1); INSERT INTO `products_to_categories` VALUES (101, 2); INSERT INTO `products_to_categories` VALUES (102, 4); INSERT INTO `products_to_categories` VALUES (103, 4); CREATE TABLE `products` ( `products_id` int(11) NOT NULL auto_increment, `products_model` varchar(12) default NULL, `products_image` varchar(64) default 'image_na.gif', `products_price` decimal(15,4) NOT NULL default '0.', PRIMARY KEY (`products_id`), ) INSERT INTO `products` VALUES (100, 'Civic', 'civic.jpg', '15'); INSERT INTO `products` VALUES (101, 'Accord', 'accord.jpg', '25'); INSERT INTO `products` VALUES (102, 'S500', 's500.jpg', '6'); INSERT INTO `products` VALUES (103, 'S600', 's600.jpg', '9'); --- I can do this with multiple queries, but to be more efficient can I do this with one query? Your help is appreciated. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
BOOK: MySQL Cookbook
Paul, I just picked up your book today: MySQL Cookbook and I just wanted to comment on how great it is. I've spent hours at the bookstore looking through mySQL books, and by far this is the best one I come across. I strongly recommend it to anybody--Beginners, Intermediate, or Advanced Users. MySQL Cookbook By Paul DuBois Ralph -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
