RE: Success !!!
That's great to hear. What I needed was to be able to access the database from only my pc. Hence the IP address but I later tried the '%' and this also worked. Thanks for the tip on restarting. I was doing the /etc/init.d/mysql stop and start :-( Thanks Tim -Original Message- From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk] Sent: 07 November 2002 03:22 PM To: Tim Venn Subject: RE: Success !!! Me too - what I did was different to you - if you change the tables you need to run this command mysqladmin flush-privileges -p. It save re-starting the server. Cheers Kevin -Original Message- From: Timothy Venn [mailto:tim@;optimus.co.za] Sent: 07 November 2002 12:55 To: [EMAIL PROTECTED] Subject: Success !!! Hi all, It now works I did the following Under the command line I did "insert into user (Host) values ('192.168.8.19')" and restarted mysql. I can now connect. Thanks for the help. Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error 2013
Hi I have been facing this problem since from many months. The problem is that when i try to connect mysql from the remote place using mysqld -h 192.168.1.1 -u temp -p it ends up with the error ERROR 2013: Lost connection to MySQL server during query As in the list i have tried increasing the MAX_PACKET_ALLOWED but the problem remails same. When i execute mysqladmin -i1 processlist status when the request from the remote client reaches the server the server dies. Since i am using the mysql fo accounting purpose please help me out to solve this problem which is severe. Thanks in advance Regards, Mazin -- Mazin Mohammed Vasnet Communication Pvt. Ltd System Administrator www.vasnet.co.in 0824-451001 [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to shut down the mySQL service ?
well, i did agree if for myself, it will be just simple as right click and choose "shutdown this tool". but now i want to use the program to shutdown the tool automatically. the reason why have to do that is during uninstallation for my system, so that when the user run again my setup program, which will then launch the mySQLAdmin again. if i not shutdown the mySQLAdmin at first, the system tray there will appear 2 traffic light there. so, in short, i need to shutdown it in programatic way. - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 11:15 AM Subject: Re: how to shut down the mySQL service ? > Pada Fri, 8 Nov 2002 11:16:16 +0800 > "Alice Tan" <[EMAIL PROTECTED]> menulis: > > > Hi, i got the stop mysqladmin service done. > > but this time is how to shutdown the mysqladmin service ? > > > > this is due to when ppl remove my system, > > and thinking of reinstall again, > > in my system should shutdown the service which already stop, > > then launch again the mysqladmin. > > on windows, mysqladmin is staying at systray, so you just click right-button mouse on the icon and choose close or exit. > > or just press ctrl-alt-del one time and end task for mysqladmin process. > > mysqladmin is not (main) mysql server application, it's only for administration (or control panel). > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) > Phone: +62 21 79199577 - HP: +62 8158787286 > Web: http://www.1rstwap.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > /---\ Confidential and/ or privileged information may be contained in this e-mail and any attachments transmitted with it ('Message'). If you are not the addressee indicated in this Message (or responsible for delivery of this Message to such person),you are hereby notified that any dissemination, distribution, printing or copying of this Message or any part thereof is prohibited. Please delete this Message if received in error and advise the sender by return e-mail. Opinions, conclusions and other information in this Message that do not relate to the official business of this company shall be understood as neither given nor endorsed by this company. This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) *Scanner Engine powered by Norman Virus Control \--/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Unique identifier in MySQL
Hello, Hope this makes sense, I am totally new with using MySQL. How would I create a unique ID number for a table, for, say, a field named UserID for example? Thanks Yves - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to shut down the mySQL service ?
Pada Fri, 8 Nov 2002 11:16:16 +0800 "Alice Tan" <[EMAIL PROTECTED]> menulis: > Hi, i got the stop mysqladmin service done. > but this time is how to shutdown the mysqladmin service ? > > this is due to when ppl remove my system, > and thinking of reinstall again, > in my system should shutdown the service which already stop, > then launch again the mysqladmin. on windows, mysqladmin is staying at systray, so you just click right-button mouse on the icon and choose close or exit. or just press ctrl-alt-del one time and end task for mysqladmin process. mysqladmin is not (main) mysql server application, it's only for administration (or control panel). -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to shut down the mySQL service ?
Hi, i got the stop mysqladmin service done. but this time is how to shutdown the mysqladmin service ? this is due to when ppl remove my system, and thinking of reinstall again, in my system should shutdown the service which already stop, then launch again the mysqladmin. > - Original Message - > From: "Amish K. Munshi" <[EMAIL PROTECTED]> > To: "Alice Tan" <[EMAIL PROTECTED]> > Sent: Monday, October 28, 2002 3:57 PM > Subject: Re: how to stop the mySQL service ? > > > > On Monday 28 October 2002 01:26 pm, you wrote: > > > run in the DOS, i got this error .. > > > am i doing wrongly ? > > > > > > C:\mysql\bin>mysqladmin shutdown > > > mysqladmin: connect to server at 'localhost' failed > > > error: 'Access denied for user: 'ODBC@localhost' (Using password: NO)' > > > > > > Use mysqladmin -u username -p shutdown > > where it usename is the username allowed to shutdown the server. I am not > > very sure about windows since I work on linux, on linux I give the command > > "mysqladmin -u root -p shutdown" > > > > > > > > > > > > > - Original Message - > > > From: <[EMAIL PROTECTED]> > > > Cc: <[EMAIL PROTECTED]> > > > Sent: Monday, October 28, 2002 2:32 PM > > > Subject: Re: how to stop the mySQL service ? > > > > > > > "mysqladmin shutdown" > > > > > > > > On Mon, 28 Oct 2002, Alice Tan wrote: > > > > > How to stop the mySQL service instead of right click the traffic > light > > > > > > and > > > > > > > > stop it ? > > > > > is there any exe can stop the mySQL service ? > > > > > i tried the mySQLShutDown.exe, but it didn't actually stop the > service. > > > > > i want to stop the mySQL service so that the mysqld-nt.exe wouldn't > > > > > hold > > > > > > my > > > > > > > > database, > > > > > which then make me not able to delete the database on the data > folder > > > > > > when > > > > > > > > the time > > > > > i want to uninstall my application with my database as well. > > > > > > > > > > anyone can help me ? > > > > > thanx > > > > > > > /-- > > > >- \ > > > > > > > > Confidential and/ or privileged information may be contained in this > > > > > e-mail and any attachments transmitted with it ('Message'). If you > are > > > > > not the addressee indicated in this Message (or responsible for > > > > > delivery of this Message to such person),you are hereby notified > that > > > > > any dissemination, distribution, printing or copying of this Message > or > > > > > any part thereof is prohibited. Please delete this Message if > received > > > > > in error and advise the sender by return e-mail. Opinions, > conclusions > > > > > and other information in this Message that do not relate to the > > > > > official business of this company shall be understood as neither > given > > > > > nor endorsed by this company. > > > > > > > > > > This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn > Bhd) > > > > > *Scanner Engine powered by Norman Virus Control > > > > > > > \-- > > >/ > > > > > > > > > - > > > > > Before posting, please check: > > > > >http://www.mysql.com/manual.php (the manual) > > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > > To unsubscribe, e-mail > > > > > > <[EMAIL PROTECTED]> > > > > > > > > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > > > > > > > > - > > > > Before posting, please check: > > > >http://www.mysql.com/manual.php (the manual) > > > >http://lists.mysql.com/ (the list archive) > > > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > > To unsubscribe, e-mail > > > > > > <[EMAIL PROTECTED]> > > > > > > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > /-- > > >-\ > > > > > > Confidential and/ or privileged information may be contained in this > > > e-mail and any attachments transmitted with it ('Message'). If you are > > > not the addressee indicated in this Message (or responsible for > > > delivery of this Message to such person),you are hereby notified that > > > any dissemination, distribution, printing or copying of this Message or > > > any part thereof is prohibited. Please delete this Message if received > > > in error and advise the sender by return e-mail. Opinions, conclusions > > > and other information in this Message that do not relate to the > > > official business of this company shall be understood as neither given > > > nor endorsed by this company. > > > > > > This mail is certified Virus Free by *ProtectNow! (InternetNow Sdn Bhd) > > > *Scanner Engine powered by Norman Virus C
Quote command and special characters
Ok, I tried using the QUOTE() function exactly how they have it on the string page in the online manual. Needless to say, this has not worked at all...I get an sql syntax error every time. If anyone else has had this problem or knows how to write a sql statement using a different function that handles special characters like apostrophe's, it would be GREATLY appreciated. I am using asp on a w2k server platform. To run the statement, i've tried going through adodb, mysqlgui, and just plain mysql. Ideas? Adam
Re: ERROR 1030: Got error 124 from table handler
Thanks for your help - problem now resolved. The issue was I was creating the userId field with auto_increment and setting it as the primary key in the UNION table definition - but had failed to make the same settings in the table which I was making a UNION from. I.E check very carefully when using UNION that you exactly match the table origional table definition.. thx dave Jocelyn Fournier wrote: Hi, In fact, it's : joce@forum:~$ perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function but the solution to resolve the problem remains the same ;) Regards, Jocelyn - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 2:11 AM Subject: Re: ERROR 1030: Got error 124 from table handler Pada Fri, 08 Nov 2002 01:59:20 + David Herring <[EMAIL PROTECTED]> menulis: What does "ERROR 1030: Got error 124 from table handler" mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql> repair table ; or shell# mysqlcheck -r -p -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Copy Records in a table...
insert into mytable(field1, field2, field3) select field1, field2, newvalue from mytable where productcode=xx > -Original Message- > From: Doug Coning [mailto:lists@;coning.com] > Sent: Friday, 8 November 2002 14:35 > To: [EMAIL PROTECTED] > Subject: Copy Records in a table... > > > Hi everyone, > > I'm still learning MySQL. I have a database of 600 items. I am still > adding products. Several of these products are identical in nature, but > have maybe one or two columns that are different. Is there a way > to write a > SQL command that selects these items and then inserts them, and > then updates > them respectively with one command? > > Thanks, > > Doug > > > > > > MySQL > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Copy Records in a table...
Pada Thu, 7 Nov 2002 21:35:00 -0600 "Doug Coning" <[EMAIL PROTECTED]> menulis: > Hi everyone, > > I'm still learning MySQL. I have a database of 600 items. I am still > adding products. Several of these products are identical in nature, but > have maybe one or two columns that are different. Is there a way to write a > SQL command that selects these items and then inserts them, and then updates > them respectively with one command? i don't if there is another way, but i know this one : you've to create temporary table ... mysql> create table table2 select * from table1; mysql> insert into table1 select * from table2; you can also do something like this : insert into table1(col1,col2,col3) select(col1,col2,"something") from table2; -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error connecting to Mysql via Apache/PHP (Newbie)
Pada Thu, 7 Nov 2002 12:10:21 -0500 [EMAIL PROTECTED] menulis: > Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on > Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. > > I am trying to connect to my Mysql DB via Apache and PHP, but I get the > following error: "Warning: Unknown MySQL Server Host '' (1) in > helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL > Server Host '' (1) in helloSql.php on line 3 Could not connect" > > Here is the code I used. > > // Connecting, selecting database > $link = mysql_connect("", "", "") > or die("Could not connect"); > print "Connected successfully"; is your mysqld running ? how to check ? run : shell# mysql -uroot -p is this the real code ? $link = mysql_connect("", "", "") if it is, so you should remove the "<>" sign, and looks like this : $link = mysql_connect("localhost", "root", "mypassword") -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error (61)
Pada Wed, 6 Nov 2002 15:44:58 + <[EMAIL PROTECTED]> menulis: > Can't connect to local MySQL server through socket '/tmp/mysql.sock' > (61) any suggestions on this > check your mysqld process, is it running or not ? ps ax (-edf for solaris) | grep mysqld if it's already running, try to find location of mysql.sock file, posibility : /tmp/ /var/lib/mysql/ /usr/local/mysql/data/ you can create a symbolic link from current location to /tmp or edit your my.cnf file for mysql.sock and point it to current location... -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Copy Records in a table...
Hi everyone, I'm still learning MySQL. I have a database of 600 items. I am still adding products. Several of these products are identical in nature, but have maybe one or two columns that are different. Is there a way to write a SQL command that selects these items and then inserts them, and then updates them respectively with one command? Thanks, Doug MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Pada Fri, 8 Nov 2002 02:20:56 - "Jocelyn Fournier" <[EMAIL PROTECTED]> menulis: > Hi, > > In fact, it's : > > joce@forum:~$ perror 124 > Error code 124: Wrong medium type > 124 = Wrong index given to function > > but the solution to resolve the problem remains the same ;) ups ... sorry ... :)) my mistake :D thx jocelyn ... ;-) sql,query -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
What is the handler for Collaborate ?? (What does "show create table Collaborate" display ?) - Original Message - From: "David Herring" <[EMAIL PROTECTED]> To: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 2:29 AM Subject: Re: ERROR 1030: Got error 124 from table handler > > > Dicky, > > Thank you for the quick response - but it appears tables created as > unions do not support these repair commands:- > > # bin/mysqlcheck -r -p test Collaborate > Enter password: > test.Collaborate > error: The handler for the table doesn't support check/repair > > > # mysql -uroot test > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 43 to server version: 3.23.52-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> repair Collaborate; > ERROR 1064: You have an error in your SQL syntax near > 'Vodafone_Collaborate' at line 1 > mysql> > > > Any other ideas ? Would trying an older version of MySQL be useful ? > > thx dave > > > Dicky Wahyu Purnomo wrote: > > >Pada Fri, 08 Nov 2002 01:59:20 + > >David Herring <[EMAIL PROTECTED]> menulis: > > > > > > > > > >>What does "ERROR 1030: Got error 124 from table handler" mean when > >>trying to select a single value from a table created as a UNIOn of > >>another table ? > >> > >> > > > >root@slimmer:~# perror 127 > >Error code 127: Unknown error 127 > >127 = Record-file is crashed > > > >Table corrupt ... do > >mysql> repair table ; > >or > >shell# mysqlcheck -r -p > > > > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Pada Fri, 08 Nov 2002 02:29:49 + David Herring <[EMAIL PROTECTED]> menulis: > > > Dicky, > > Thank you for the quick response - but it appears tables created as > unions do not support these repair commands:- > > # bin/mysqlcheck -r -p test Collaborate > Enter password: > test.Collaborate > error: The handler for the table doesn't support check/repair > > > # mysql -uroot test > Welcome to the MySQL monitor. Commands end with ; or \g. > Your MySQL connection id is 43 to server version: 3.23.52-log > > Type 'help;' or '\h' for help. Type '\c' to clear the buffer. > > mysql> repair Collaborate; > ERROR 1064: You have an error in your SQL syntax near > 'Vodafone_Collaborate' at line 1 > mysql> on syntax, your forgot to add ... table ... should be like this : mysql> repair table Collaborate; but it's only working if you're using MyISAM table type. -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Dicky, Thank you for the quick response - but it appears tables created as unions do not support these repair commands:- # bin/mysqlcheck -r -p test Collaborate Enter password: test.Collaborate error: The handler for the table doesn't support check/repair # mysql -uroot test Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 43 to server version: 3.23.52-log Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> repair Collaborate; ERROR 1064: You have an error in your SQL syntax near 'Vodafone_Collaborate' at line 1 mysql> Any other ideas ? Would trying an older version of MySQL be useful ? thx dave Dicky Wahyu Purnomo wrote: Pada Fri, 08 Nov 2002 01:59:20 + David Herring <[EMAIL PROTECTED]> menulis: What does "ERROR 1030: Got error 124 from table handler" mean when trying to select a single value from a table created as a UNIOn of another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql> repair table ; or shell# mysqlcheck -r -p - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Hi, In fact, it's : joce@forum:~$ perror 124 Error code 124: Wrong medium type 124 = Wrong index given to function but the solution to resolve the problem remains the same ;) Regards, Jocelyn - Original Message - From: "Dicky Wahyu Purnomo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Friday, November 08, 2002 2:11 AM Subject: Re: ERROR 1030: Got error 124 from table handler > Pada Fri, 08 Nov 2002 01:59:20 + > David Herring <[EMAIL PROTECTED]> menulis: > > > > What does "ERROR 1030: Got error 124 from table handler" mean when > > trying to select a single value from a table created as a UNIOn of > > another table ? > > root@slimmer:~# perror 127 > Error code 127: Unknown error 127 > 127 = Record-file is crashed > > Table corrupt ... do > mysql> repair table ; > or > shell# mysqlcheck -r -p > > -- > Dicky Wahyu Purnomo - System Administrator > PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) > Phone: +62 21 79199577 - HP: +62 8158787286 > Web: http://www.1rstwap.com > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: ERROR 1030: Got error 124 from table handler
Pada Fri, 08 Nov 2002 01:59:20 + David Herring <[EMAIL PROTECTED]> menulis: > What does "ERROR 1030: Got error 124 from table handler" mean when > trying to select a single value from a table created as a UNIOn of > another table ? root@slimmer:~# perror 127 Error code 127: Unknown error 127 127 = Record-file is crashed Table corrupt ... do mysql> repair table ; or shell# mysqlcheck -r -p -- Dicky Wahyu Purnomo - System Administrator PT FIRSTWAP: Jl Kapt. Tendean No. 34 - Jakarta Selatan (12790) Phone: +62 21 79199577 - HP: +62 8158787286 Web: http://www.1rstwap.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ERROR 1030: Got error 124 from table handler
Hi, What does "ERROR 1030: Got error 124 from table handler" mean when trying to select a single value from a table created as a UNIOn of another table ? When selecting just the primary key from a UNION table, with MySQL 3.23.53 I get the following error - however if I select the primary key and any other field I get the select to work fine ?? Any ideas - thx dave mysql> mysql> select userId from Collaborate; ERROR 1030: Got error 124 from table handler mysql> select userId,email from Collaborate ;+-+---+ | userId | email | +-+---+ | 178 | [EMAIL PROTECTED] | | 118 | [EMAIL PROTECTED]| | 119 | [EMAIL PROTECTED] | - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Indexes LIKE
I was reading through the docs and it says: The following SELECT statements will not use indexes: mysql> SELECT * FROM tbl_name WHERE key_col LIKE "%Patrick%"; mysql> SELECT * FROM tbl_name WHERE key_col LIKE other_col; I am using MYSQL on windows. So is that true? When I use the below statement should I not index TitleName? SELECT A.TitleName, C.ActorName FROM Titles A, ActorTitle B, Actors C Where A.TitleID=B.TitleID AND B.ActorID=C.ActorID AND A.TitleName LIKE '%PartOfName%' ORDER BY A.TitleName ASC - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL AB has reached a settlement with NuSphere Corporation
hi, > MySQL AB is pleased to announce that it has settled its lawsuit with > Progress Software Corporation and NuSphere Corporation. For more > information, see the joint press release at > > http://www.mysql.com/press/release_2002_14.html Here's some background-info on the lawsuit: http://www.mysql.com/news/article-75.html http://slashdot.org/article.pl?sid=02/11/07/1942254&mode=nested&tid=123 -daniel - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
try again
I have a Redhat linux box which has MySQL 3.23.52 loaded on it. I have mysql front loaded on a windows xp box which I am trying to use to connect to the mysql server. The error I am getting when trying to make a connection is 2013 - lost connection to MySQL server during query. I have checked to make sure that the Mysql server is running and that users were added to the mysql list with wide open permissions set just to see if I could get it working. I have tried re-installing the mysql software with the same result. Can you help? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql quota
I think you can set a max quota for a table. Insane - Original Message - From: "Henry Umansky" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, October 21, 2002 8:08 PM Subject: mysql quota > I want to let users on my system use MySQL, but I want them to have some > sort of quota. Is there anyway to create a max database size with MySQL? > I could just chown the directory in /var/lib/mysql, but that means I would > have to create a username for each person and set filesystem quota. I > really don't want to do that, I just want them to use mysql from a remote > machine or through PHP. > > Henry Umansky > University of Pittsburgh > Systems/Programmer III > www.pitt.edu/~hmust2 > [EMAIL PROTECTED] > (412)624-4357 > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Using AUTO_INCREMENT like SEQUENCE - Resolved
Hi all, Sorry to jump in the middle of this thread but there is a much simpler way to generate sequence numbers: You create an auxiliary table with a one row: CREATE TABLE sequence ( code int(11) DEFAULT '0' NOT NULL ); INSERT INTO sequence VALUES (0); And, each time you need a new sequence number: UPDATE sequence SET code=LAST_INSERT_ID(code+1); SELECT LAST_INSERT_ID(); We use this method in our applications and it works well. (and I didn't invent it, it is described in Paul DuBois'book ;)) Hope this helps -- Joseph Bueno Mike Hillyer wrote: > I was thinking of a similar problem as yours (having the select max(id) type > query get duplicate results) and what I realized was that I could do a > select max(id) and specify a where clause to a column that had the user id > of the creator of the row (which I already had in place for auditing) and > then there was never duplication because the odds of you yourself inserting > two rows simultaneously was nil. So, that may work for you as long as each > user is logged in separately, and you can accept putting a field in your row > referring to the row creator. > > Mike Hillyer > > -Original Message- > From: Chuck Tomasi [mailto:Chuck.Tomasi@;plexus.com] > Sent: Monday, October 21, 2002 7:19 AM > To: [EMAIL PROTECTED] > Subject: RE: Using AUTO_INCREMENT like SEQUENCE - Resolved > > > This past weekend the solution came to me. Simple, but elegant (well not as > elegant as using the auto_increment feature natively, but a lot less code to > write in my case.) > > I'm already used to managing a separate sequence so I too the AUTO_INCREMENT > feature out of the main table (ex: mytable) and created a second table > > Create table mytable_seq (ID int not null primary key auto_increment); > > To 'seed' the table I put in the highest value from mytable (ex: select > max(ID) from mytable). Now when I do this: > > Insert into mytable_seq values (NULL); > Select LAST_INSERT_ID() from mytable_seq limit 1; > > I get what I want, what I need to create the file, populate mytable, etc. > LAST_INSERT_ID() takes care of managing contentions (which I tested to no > end.) That's the basics of my GetCounter($table) routine! > > My only gripe now is that mytable_seq continues to grow and grow (hence the > need for LIMIT 1). I know it isn't a large table, but I may consider > trimming it from time to time once I've verified its usefulness. > > --Chuck > > -Original Message- > From: Peter Brawley [mailto:peter.brawley@;artfulsoftware.com] > Sent: Friday, October 18, 2002 11:39 AM > To: Chuck Tomasi; [EMAIL PROTECTED] > Subject: Re: Using AUTO_INCREMENT like SEQUENCE > > Chuck, > > last_insert_id() is per-connection. How do you see two users getting the > same auto_increment value? > > PB > > - > - Original Message - > From: "Chuck Tomasi" <[EMAIL PROTECTED]> > To: <[EMAIL PROTECTED]> > Sent: Friday, October 18, 2002 9:07 AM > Subject: Using AUTO_INCREMENT like SEQUENCE > > > >>General Info: >> >>OS: Mac OS X >>MySQL version: 3.23.52 (Jaguar) >>PERL: 5.6.0 >>DBI: 1.30 >> >>I've got an application that was written to use Oracle sequences, as such >>the program pulls a sequence number then creates a file based on that >>number and populates a database record with infomation. I've read >>everything I can find out AUTO_INCREMENT values, but I can't seem to >>reproduce the same functionality without causing some possible conflict >>condition where two people may get the same numbers. >> >>At the heart of the matter is a Perl sub I call "GetCounter()". It >>accepts a sequence name, pulls a value from the sequence and returns that >>value. Originally I was doing this with mSQL sequences. With a minor >>change to the code it ran fun in Oracle also. Now I'm looking at porting >>my stuff to MySQL, but can't seem to match the functionality. >> >>Note, I'm importing a lot of these records from the Oracle DB to MySQL so >>the counter would not be starting at 0. >> >>Thoughts so far: >> >>I've thought about "select MAX(ID+1) from mytable", but if two people >>happen to be doing this at the same time, they'll get the same number - >>bad. >> >>"select LAST_INSERT_ID(ID+1)" seems like a similar solution since two >>people could get the same LAST_INSERT_ID(). >> >>I'd like some way to pull the number and make sure it is not pulled again. >>By the time I need the number, the information has been verified. The >>record will be populated using this number (ID field), a file will be >>created using this number, etc. I'd hate to have to do something like >> >>"insert into mytable (ID) values (NULL)" >> >>only to go back and >> >>"select LAST_INSERT_ID(ID) from mytable" >>"update mytable set LastName='blah',FirstName='foo',Phone='xxx',... where >>ID=LAST_INSERT_ID()" >> >>--Chuck >> >> >>- >>Before posting, please check: >> http://www.mysql.com/manual.php (the ma
RE: getting the number of years between two dates
Well, actually I always use the Unix date format because is easier to use with PHP... and makes easier to do this kind of calculations... ;) -Mensaje original- De: John Meyer [mailto:johnmeyer_1978@;yahoo.com] Enviado el: jueves, 07 de noviembre de 2002 15:20 Para: Michael T. Babcock CC: [EMAIL PROTECTED] Asunto: RE: getting the number of years between two dates Actually figured out one of my own: FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age It's amazing what you can think of as soon as you ask the question. -Original Message- From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net] Sent: Thursday, November 07, 2002 1:58 PM To: John Meyer Cc: [EMAIL PROTECTED] Subject: Re: getting the number of years between two dates John Meyer wrote: >sql,query > >How do I do that? The contaxt is that I want to get somebody's age based >upon the current date. > > There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: privileges when moving from mysql 3.23 to 4.0
how is there a way to retain the user privileges in the mysql table when dumping from mysql 3.23 to 4.0 ? i dont want to have to reset these individually , let me know thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SQL Query
On Thu, 2002-11-07 at 16:17, [EMAIL PROTECTED] wrote: > Hi, > > I have the following SQL query, that returns the correct records on Access, > but when I use it with MySQL, it returns duplicate records, and it skips the > required records. > > SearchSQL=select > MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke > > tData.Occupation,MarketData.Country > ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM > MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE > Contacts.CustID=6115 I personally would try: SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname, MarketData.Occupation,MarketData.Country,County,MarketData.Forename, MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts WHERE MarketData.CustID=Contacts.ContactID AND Contacts.CustID=6115 John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
John, Michael, Andy and James, Thanks for the informative responses. I was hoping I was on the right track. Thanks for the query help, too. It looks like this is going to work just fine. Cheers, Rik Forgo JIST3 Army Test, Training and Technology Integration Office (T3I) Diverse Technologies Corp. (c) 443.463.8571 (h) 410.859.8474 > -Original Message- > From: John Ragan [mailto:jragan@;arkansas.net] > Sent: Thursday, November 07, 2002 10:16 AM > To: [EMAIL PROTECTED]; Richard Forgo > Subject: RE: Newbie: Intersecting entities > > > aha! sure. you weren't being vague. you just > needed to educate me. > > some of us have used intersecting entities > through the years, but didn't know that there was > a fancy name for what we were doing. if my > memory weren't so bad, i'd use it to impress > people in the next interview. > > in this case, simply do a three way multiple join > with the intersecting entity in the middle. > something like this: > select table1.col2, table 3.col2 >from table1 > left join table2 on table1.col1 = table2.col1 > left join table3 on table2.col2 = table3.col1 > > or you could use an equal join with the > intersecting entity in the middle. > > if you have a windows box that you can use as a > front end, i strongly recommend that you download > corereader because its point and click queries > can make a six way join look simple. then, it'll > show you the sql code. best of all is that it's > free. http://corereader.com > > > > > Sorry for being vague. I think the closest thing I can find to it is, > > possibly, a three-way join. I'm trying to figure out how to write the > > query. > > > > I've got the following tables: > > > > systems > > > > sys_nameID > > > > Abrams 202 > > Patriot 544 > > Stinger 229 > > > > ... and ... > > > > new_req > > > > proj_name ID > > > > Test Bed Alpha 344 > > Tracked Wheels 989 > > Battle Monitor 823 > > Shoulder Harness654 > > Ammo Flask 454 > > Spotter 773 > > > > There may be multiple new requirements for a single system. To > > accommodate them, I created a new table -- an intersecting entity is > > what I recall it being called -- to bridge the two. I can't keep the > > multiple references to new_req in the systems table, nor can I keep them > > in the new_req table. As best I can figure, I need to have a bridge > > table ... e.g., > > > > ie_sys_req > > > > sys_id proj_name_id > > > > 202344 > > 202989 > > 202823 > > 544654 > > 544454 > > 544773 > > > > If this seems peculiar, have patience with me I'm new at this. If it's > > right, let me know so I can breath a sigh of relief. And if the > > structure is right, could someone offer some guidance on how a query > > that allows me to query new_req using the intersecting entity (or > > three-way join, whatever it's called) would be written. > > > > Thanks, > > > > > > Rik Forgo > > JIST3 > > Army Test, Training and Technology Integration Office (T3I) > > Diverse Technologies Corp. > > (c) 443.463.8571 > > (h) 410.859.8474 > > > > > > > -Original Message- > > > From: John Ragan [mailto:jragan@;arkansas.net] > > > Sent: Wednesday, November 06, 2002 6:55 PM > > > To: [EMAIL PROTECTED]; Richard Forgo > > > Subject: Re: Newbie: Intersecting entities > > > > > > > > > if a succinct statement is possible, perhaps you > > > could give us an idea of its nature? > > > > > > somebody may be familiar with the concept under a > > > different name. > > > > > > > > > > I'm trying to find some documentation on creating intersecting > > entities > > > > in MySQL, but haven't been able to track any info down on the MySQL > > site > > > > or on the web. At least we called them intersecting entities while > > I > > > > was in Oracle training (which was some time ago). I think I > > remember > > > > how to set them up, but I'd love to have something to refer to > > quickly > > > > before I start. Can anyone point me in the right direction? > > > > > > > > > > > > Rik Forgo > > > > JIST3 > > > > Army Test, Training and Technology Integration Office (T3I) > > > > Diverse Technologies Corp. > > > > (c) 443.463.8571 > > > > (h) 410.859.8474 > > > > > > > > > > > > > > > > > > > > > > > > -- > > > John Ragan > > > [EMAIL PROTECTED] > > > http://www.CoreReader.com/ > > > > > > > > > - > > > Before posting, please check: > > >http://www.mysql.com/manual.php (the manual) > > >http://lists.mysql.com/ (the list archive) > > > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > > To unsubscribe, e-mail > > [EMAIL PROTECTED]> > > > Trouble unsubscribing? Try: http://
Re: Key/table cache size?
Grigor, Peter wrote: If you are using a version of MySql that has the query cache you can turn it on and those queries will run very fast after the initial query. The query cache is cleared whenever the underlying table(s) are modified so you'll get the initial time hit again after modification...but if your table contents don't change much the query cache will make a BIG difference. Unfortunately, they change a lot more often than I run the queries; its a mostly-update table for storing intrusion detection information. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
new user, new install
I just installed onto a solaris 8 machine. I've run mysql_install_db The script says to change the root password by doing this: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h myhost password 'new-password' When I do that I get ./bin/mysqladmin: No match. Is password the already established password? I'm totally new to mysql. I'm just trying to run the tutorial but I can't seem to do anything until I have established a root password. BTW - I can run safe_mysqld when I'm logged in as root but not as a user. I can't run ./bin/mysqld at all. If I try when logged in as root I get a message that I should read the security section of the manual about how to log in as root. If I run it as a user I get: 021107 13:39:19 ./bin/mysqld: Can't create/write to file '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 13) 021107 13:39:19 ./bin/mysqld: Table 'mysql.host' doesn't exist 021107 13:39:19 ./bin/mysqld: Error on delete of '/usr/local/mysql-3.23.52-sun-solaris2.8-sparc/var/newpop.pid' (Errcode: 2) I'm totally lost and I can't afford to sign up for the 30 day install support. Is there anyone willing to help me get this going? Thanks in advance - chris walcott - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Key/table cache size?
> I've got a query that selects the count of distinct rows in a table; the > table has 453632 rows and 24 distinct class_id's. > > mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event; > +---+ > | count(DISTINCT(sig_class_id)) | > +---+ > |24 | > +---+ > 1 row in set (4.80 sec) > > mysql> select count(*) FROM acid_event; > +--+ > | count(*) | > +--+ > | 453632 | > +--+ > 1 row in set (3.12 sec) > > > Is there any way to speed up these queries (InnoDB tables), or just put up? If you are using a version of MySql that has the query cache you can turn it on and those queries will run very fast after the initial query. The query cache is cleared whenever the underlying table(s) are modified so you'll get the initial time hit again after modification...but if your table contents don't change much the query cache will make a BIG difference. Peter <^_^> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: SQL Query
Is this line correct? MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Or should it be: MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.CustID WHERE JFernando ** sql ** -Original Message- From: [EMAIL PROTECTED] [mailto:Sam4Software@;aol.com] Sent: November 7, 2002 16:18 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: SQL Query Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Mar ke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 Regards, Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Profiler for windows
there is a Profiler similar to SQL server Profiler ,only for windows i wrote it myself , availiable at http://amr.activechannel.net/myprofiler.htm so sorry its not free :( Amr Salah --- "Iago Sineiro" <[EMAIL PROTECTED]> wrote: >Hi Alexander. > >If you specify option log in section mysqld of my.cnf configuration file you >get a log file of all queries >and sql operations (inserts, updates, deletes) executed in the MySQL server. > >This log file is created by default at $DATADIR/$HOSTNAME.log. > >Iago. > >> -Mensaje original- >> De: Alexander Burbello [mailto:burbello@;yahoo.com.br] >> Enviado el: jueves, 07 de noviembre de 2002 21:30 >> Para: [EMAIL PROTECTED] >> Asunto: Profiler >> >> >> I would like to know if the MySQL has any command where I get the queries >> requested by the application. >> >> SQL Server has Profiler. >> Oracle has any command that I don´t know >> >> With Delphi I run SQLMonitor. >> >> Regards >> >> >> Alexander >> >> >> >> sql,query >> >> ___ >> >> Yahoo! Encontros >> >> O lugar certo para encontrar a sua alma gêmea. >> >> http://br.encontros.yahoo.com/ >> >> >> - >> Before posting, please check: >>http://www.mysql.com/manual.php (the manual) >>http://lists.mysql.com/ (the list archive) >> >> To request this thread, e-mail <[EMAIL PROTECTED]> >> To unsubscribe, e-mail >> <[EMAIL PROTECTED]> >> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php >> > > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php _ Get your FREE, Private email today - [EMAIL PROTECTED] http://www.msexpert.com _ Select your own custom email address for FREE! Get [EMAIL PROTECTED] w/No Ads, 6MB, POP & more! http://www.everyone.net/selectmail?campaign=tag - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Key/table cache size?
On Thu, Nov 07, 2002 at 12:32:58PM -0500, Michael T. Babcock wrote: > I've got a query that selects the count of distinct rows in a table; the > table has 453632 rows and 24 distinct class_id's. > > mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event; > +---+ > | count(DISTINCT(sig_class_id)) | > +---+ > |24 | > +---+ > 1 row in set (4.80 sec) > > mysql> select count(*) FROM acid_event; > +--+ > | count(*) | > +--+ > | 453632 | > +--+ > 1 row in set (3.12 sec) > > > Is there any way to speed up these queries (InnoDB tables), or just put up? Check if the machine is disk or CPU bound when it runs. You may need a larger innodb_buffer_pool. That'll help keep more records in memory and imporove response time. > PS, at that number of distinct values, am I right in thinking that I > should just drop the index on that column while I'm at it? Maybe. Depends what else it might be used for. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,140,347 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL CPU usage skyrocketing
On Thu, Nov 07, 2002 at 08:48:15AM -0500, Grigor, Peter wrote: > Ok, we know that FreeBSD has problems with its thread implementation; > however, I'd like to know if the MySql guys know exactly what causes the > problems to which Mr Zawodny refers. The problem is the MySQL (by default) uses name resolution extensively. But the resolver calls are not thread-safe on FreeBSD. Race coniditions exist that can cause odd cicumstances which result in MySQL thrashing a bit. > I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before > which leads me to believe that either FreeBSD has not addressed the problem > or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is > not recommended because of its threading implementation. It's not a MySQL problem--it's a FreeBSD problem. This problem doesn't exist on other platforms. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 3.23.51: up 93 days, processed 1,954,122,045 queries (241/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL Digest
I sent this sometime ago and never got a response, so I will send it again I want to change my option to subscribe to this list as a digest, is the following command below correct, or is this list not setup has a digest? subscribe mysql-digest EMAILADDRESS END -- Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting the number of years between two dates
Actually figured out one of my own: FLOOR(PERIOD_DIFF(EXTRACT(YEAR_MONTH FROM NOW()),EXTRACT(YEAR_MONTH FROM UserDOB))/ 12) as Age It's amazing what you can think of as soon as you ask the question. -Original Message- From: Michael T. Babcock [mailto:mbabcock@;fibrespeed.net] Sent: Thursday, November 07, 2002 1:58 PM To: John Meyer Cc: [EMAIL PROTECTED] Subject: Re: getting the number of years between two dates John Meyer wrote: >sql,query > >How do I do that? The contaxt is that I want to get somebody's age based >upon the current date. > > There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
SQL Query
Hi, I have the following SQL query, that returns the correct records on Access, but when I use it with MySQL, it returns duplicate records, and it skips the required records. SearchSQL=select MarketData.CustID,Contacts.ContactID,Contacts.CustID,MarketData.Nickname,Marke tData.Occupation,MarketData.Country ,County,MarketData.Forename,MarketData.Surname,MarketData.Email FROM MarketData INNER JOIN Contacts on MarketData.CustID=Contacts.ContactID WHERE Contacts.CustID=6115 Regards, Sam - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newby: Duplicate Records in table...
Hi everyone, How do I select a group of records in a table and automatically duplicate them into the same table while modifying 1 or 2 columns without having to re-insert each record individually? Thanks, Doug MySQL - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Key/table cache size?
Dan Nelson wrote: Yes, with only 24 values, MySQL will probably never use that index for paring down records in a regular SELECT. But for your count() case it should. According to the EXPLAIN output, it does; but its still horrifically slow. mysql> explain SELECT count(DISTINCT(sig_class_id)) FROM acid_event; ++---+---+--+-+--++-+ | table | type | possible_keys | key | key_len | ref | rows | Extra | ++---+---+--+-+--++-+ | acid_event | index | NULL | sig_class_id | 5 | NULL | 377222 | Using index | ++---+---+--+-+--++-+ Mind you, it doesn't pare it down much ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: getting the number of years between two dates
John Meyer wrote: sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. There are several examples in the mailing list archives; but try subtracting the UNIX_TIMESTAMP of each date (which is the time in seconds) and then divide by the number of seconds in a year (~365*86400) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Why can I not access your support system via the Wizard?
I am a new customer and have a question about mysqldump recovery, but cannot seem to be able to logon. My user name is probusine8359 and my support contract is 2002-1428. Would you please correct this anomaly? I need to get my questions answered. My phone number is 925.737.3458. Thanks. Ian Clark ProBusiness, Inc - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using libmysqld - can't connect to remote DB as client.
At 11:14 -0800 11/7/02, Steven Webb wrote: On that page, it says: "You can't connect to the embedded server from an outside process with sockets or TCP/IP." ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? The client library calls are replaced with (or mapped onto, if you will) calls that talk to the embedded server. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: getting the number of years between two dates
sql,query How do I do that? The contaxt is that I want to get somebody's age based upon the current date. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Key/table cache size?
In the last episode (Nov 07), Michael T. Babcock said: > I've got a query that selects the count of distinct rows in a table; > the table has 453632 rows and 24 distinct class_id's. > > mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event; > | count(DISTINCT(sig_class_id)) |24 | > 1 row in set (4.80 sec) > > mysql> select count(*) FROM acid_event; > | count(*) | 453632 | > 1 row in set (3.12 sec) > > Is there any way to speed up these queries (InnoDB tables), or just > put up? > > PS, at that number of distinct values, am I right in thinking that I > should just drop the index on that column while I'm at it? I haven't played with InnoDB tables much, but a select like that runs much faster with an index on MyISAM tables. Most of the server's time should be spent reading the field values, and an index scan of just that field will be faster than a table scan where it has to read the whole record. Yes, with only 24 values, MySQL will probably never use that index for paring down records in a regular SELECT. But for your count() case it should. -- Dan Nelson [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Profiler
Hi Alexander. If you specify option log in section mysqld of my.cnf configuration file you get a log file of all queries and sql operations (inserts, updates, deletes) executed in the MySQL server. This log file is created by default at $DATADIR/$HOSTNAME.log. Iago. > -Mensaje original- > De: Alexander Burbello [mailto:burbello@;yahoo.com.br] > Enviado el: jueves, 07 de noviembre de 2002 21:30 > Para: [EMAIL PROTECTED] > Asunto: Profiler > > > I would like to know if the MySQL has any command where I get the queries > requested by the application. > > SQL Server has Profiler. > Oracle has any command that I don´t know > > With Delphi I run SQLMonitor. > > Regards > > > Alexander > > > > sql,query > > ___ > > Yahoo! Encontros > > O lugar certo para encontrar a sua alma gêmea. > > http://br.encontros.yahoo.com/ > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication and temp tables...
Using 4.0.2 for both server and client, replicating the following query seems to have caused a crash on the client: CREATE TEMPORARY TABLE tmp1 ( day DATE NOT NULL, campaign_id INT NOT NULL, clicks INT, clicked FLOAT, approved FLOAT, users_raw INT, users_coreg INT, users_fullreg INT, visitors INT, PRIMARY KEY (day, campaign_id) ) TYPE=InnoDB; The error log (w/ symbols resolved) is: 021107 8:51:32 Slave SQL thread initialized, starting replication in log 'db1-bin.085' at position 113214771, relay log './db3-relay-bin.001' position: 25762057 mysqld got signal 11; This could be because you hit a bug. It is also possible that this binary or one of the libraries it was linked against is corrupt, improperly built, or misconfigured. This error can also be caused by malfunctioning hardware. We will try our best to scrape up some info that will hopefully help diagnose the problem, but since we have already crashed, something is definitely wrong and this may fail. key_buffer_size=268431360 record_buffer=2093056 sort_buffer=1048568 max_used_connections=0 max_connections=50 threads_connected=1 It is possible that mysqld could use up to key_buffer_size + (record_buffer + sort_buffer)*max_connections = 415539 K bytes of memory Hope that's ok; if not, decrease some variables in the equation. thd=0x85261b0 Attempting backtrace. You can use the following information to find out where mysqld died. If you see no messages after this, something went terribly wrong... Cannot determine thread, fp=0xbfe3f248, backtrace may not be correct. Stack range sanity check OK, backtrace follows: 0x80722d8 init_signals__Fv + 16 0x82de908 _end + 239148 0x82cb534 _end + 160344 0x80e9a58 register_slave__FP3THDPUcUi + 228 0x80af595 exec_event__21Create_file_log_eventP17st_relay_log_info + 537 0x80b04f4 __15Query_log_eventP3THDPCcb + 160 0x80ebf71 nisam_open + 1837 0x80ece8f _nisam_search + 79 0x82dbf1c _end + 228416 0x831193a _end + 448094 New value of fp=(nil) failed sanity check, terminating stack trace! Please read http://www.mysql.com/doc/U/s/Using_stack_trace.html and follow instructions on how to resolve the stack trace. Resolved stack trace is much more helpful in diagnosing the problem, so please do resolve it Trying to get some variables. Some pointers may be invalid and cause the dump to abort... thd->query at (nil) is invalid pointer thd->thread_id=3 Any ideas on what might be causing this? -JF - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Profiler
I would like to know if the MySQL has any command where I get the queries requested by the application. SQL Server has Profiler. Oracle has any command that I don´t know With Delphi I run SQLMonitor. Regards Alexander sql,query ___ Yahoo! Encontros O lugar certo para encontrar a sua alma gêmea. http://br.encontros.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: using libmysqld - can't connect to remote DB as client.
On that page, it says: "You can't connect to the embedded server from an outside process with sockets or TCP/IP." ... not the other way around, which is what I'm trying to do. I'm trying to connect to another (remote) server from the same app as is using an embedded server. It doesn't say anything about the client-side TCP being disabled in the mysqld lib, just the server-side. This is still unclear to me since they specificially went out of their way to mention that the server-side TCP stuff was diabled, am I to just assume that the client-side stuff is also disabled? - Steve --- Paul DuBois <[EMAIL PROTECTED]> wrote: > At 11:09 -0800 11/6/02, Steven Webb wrote: > >I'm using libmysqld so I can have an "embedded" > mysql > >server in my application. It helps with > performance > >because there is not socket communication and all > I/O > >is done from the program directly to the files. > >Anyway, I have the need to also connect to a remote > >database in the same application. My code works > fine > >with the local "embedded" mysql server, I can > connect > >to the local server, create a database and > manipulate > >the data, but when I try to connect to a remote > >database, it fails. The C function that I'm using > is > >"mysql_real_connect". The "mysql_connect" that > you're > >talking about is just a wrapper function that I > wrote. > > The mysql_real_connect() is down further in the > code. > > > >Did you get my code? I sent it to the list, but > the > >list bounced it because the list didn't allow > >attachments. > > > >Anyway, According to the docs for the mysqld > library > >(http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#libmysqld) > >There is nothing that says that the > mysql_real_connect > >should work any differently than the one in the > normal > >library. > > Nothing there, perhaps. But the general description > of the > embedded server points out that it does no > networking. > You cannot use an embedded app to connect to remote > servers, > nor can external clients connect to the embedded > server. > (This is one reason the manual says embedded servers > can't > be used in replication.) > > > So, I'm thinking that either the > >documentation is incorrect (mysql_real_connect > >*DOESN'T* include any socket-level capability in > the > >mysqld lib like it does in the normal library) or > I'm > >just doing something wrong when I try to connect to > a > >remote database with mysql_real_connect. The man > page > >for mysql_real_connect is here: > >http://www.mysql.com/documentation/mysql/bychapter/manual_Clients.html#mysql_real_connect > > > >- Steve > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list > archive) > > To request this thread, e-mail > <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: > http://lists.mysql.com/php/unsubscribe.php > __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL AB has reached a settlement with NuSphere Corporation
MySQL AB and Nusphere Corporation Announce Settlement07 Nov 2002 UPPSALA, Sweden and BEDFORD, Massachusetts, (November 7, 2002) - MySQL AB, developer of the world's most popular open source database, and NuSphere Corporation, an independent operating company of Progress Software Corporation, today announced a settlement of the dispute between the two companies regarding use of the MySQL trademarks, copyrights, and compliance with the GNU General Public License (GPL). The settlement resolves all outstanding issues between the two companies including ownership and use of trademarks and domain names and assignment to MySQL AB of copyrights for all NuSphere contributions to the MySQL program, and MySQL AB has issued a letter to NuSphere Corporation verifying GPL compliance. "We are happy to resolve this dispute," said Olivier Beutels, Sales Executive, Northern Europe, MySQL AB. "These past months of discussion with NuSphere regarding trademark rights and GPL issues have confirmed for us all that open source software can flourish free under the GPL license and commercially when the situation merits it." "We are pleased to reach this amicable settlement and resolve the issues between the two companies," said Dmitri Dmitrienko, General Manager Europe, NuSphere Corporation. "We look forward to getting back to the normal run of business and plan to continue shipping the MySQL database in the NuSphere Technology Platform, and remain focused on our flagship product." About MySQL AB MySQL AB develops, markets and supports the MySQL database server, the world's most popular open source database. With over 4 million installations and 27,000 downloads per day, MySQL is the de facto open source database leader and is quickly becoming the core of many high-volume, business-critical applications. The MySQL database is available under the free software/open source GNU General Public License (GPL) or a non-GPL commercial license. For more information about MySQL, please go to www.mysql.com. MySQL is a registered trademark of MySQL AB in Sweden and other countries. MySQL is a trademark in the United States and other countries. About NuSphere Corporation NuSphere delivers the first Internet Application Platform (IAP) based on open source components, providing an integrated foundation that allows companies to deploy reliable, cost-effective, enterprise-class applications across Windows, UNIX and Linux environments. NuSphere® PHPEd(tm) Advantage is an integrated software suite that pairs the reliability and cost-effectiveness of PHP, Apache, Perl and open source databases with PHPEd, the leading PHP development environment for building business-critical web applications and web services. Based in Bedford, Mass., the company's commercial software services include technical support, consulting and training. For more information, visit www.nusphere.com or call +1-781-280-4600. NuSphere is a registered trademark of NuSphere Corporation in the United States and other countries. PHPEd is a trademark of NuSphere Corporation in the United States and other countries. Other marks mentioned in this press release are the trademarks of their respective owners. -Original Message- From: Leonardo Javier Belén [mailto:lbelen@;afip.gov.ar] Sent: Thursday, November 07, 2002 2:05 PM To: [EMAIL PROTECTED] Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: "Christopher Hicks" <[EMAIL PROTECTED]> To: "Michael Widenius" <[EMAIL PROTECTED]> Cc: "Mysql List" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation > On Thu, 7 Nov 2002, Michael Widenius wrote: > > MySQL AB is pleased to announce that it has settled its lawsuit with > > Progress Software Corporation and NuSphere Corporation. For more > > information, see the joint press release at > > > > http://www.mysql.com/press/release_2002_14.html > > The press release sounds like typical PR puffery. Is any meat going to > come out beyond "it's settled"? > > -- > > > Programming is a Dark Art, and it will always be. The programmer is > fighting against the two most destructive forces in the universe: > entropy and human stupidity. They're not things you can always > overcome with a "methodology" or on a schedule. > -Damian Conway, Perl God > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL AB has reached a settlement with NuSphere Corporation
Can someone post the piece of News, for the folks that cant get into the page (I dont have access to web from where I am now...) Thanks, Leo. - Original Message - From: "Christopher Hicks" <[EMAIL PROTECTED]> To: "Michael Widenius" <[EMAIL PROTECTED]> Cc: "Mysql List" <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 3:46 PM Subject: Re: MySQL AB has reached a settlement with NuSphere Corporation > On Thu, 7 Nov 2002, Michael Widenius wrote: > > MySQL AB is pleased to announce that it has settled its lawsuit with > > Progress Software Corporation and NuSphere Corporation. For more > > information, see the joint press release at > > > > http://www.mysql.com/press/release_2002_14.html > > The press release sounds like typical PR puffery. Is any meat going to > come out beyond "it's settled"? > > -- > > > Programming is a Dark Art, and it will always be. The programmer is > fighting against the two most destructive forces in the universe: > entropy and human stupidity. They're not things you can always > overcome with a "methodology" or on a schedule. > -Damian Conway, Perl God > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Storing/retrieving "long" or very big double values
Hi. I have some problems to retrieve the doubles I write in my tables. I use MySQL server 4.0.3-beta-max. I have not found the solution of my problem on the mailing-lis archive. Following is the problem: mysql> create table double_test (d double); mysql> insert into double_test values(1.7976931348623157E308); mysql> insert into double_test values(0.10012210012209899); mysql> select * from double_test; +---+ | d | +---+ | 1.79769313486232e+308 | ==> truncation happened | 0.100122100122099 | ==> truncation happened +---+ The numbers are truncated. Why and how to avoid it ? I would like store and retrieve the double values without modification. In my Java program when I read back the data, 1.79769313486232e+308 is considered as 'Infinity' because after the truncation and rounding, the value becomes bigger than the maximum double value allowed (1.7976931348623157E308 under Java). When I use double(M,D) instead of double in the table creation, the insertion of 1.7976931348623157E308 leads to the value 'inf' when I read back the value by typing 'select * from ouble_test'). Any idea or experience to share. Thanks in advance, Christophe. *** Christophe DIARRA Institut de Physique Nucleaire 15, Rue Georges Clemenceau Bat 102 - S2I 91406 ORSAY Cedex Tel: (33) 1 69 15 65 60 Fax: (33) 1 69 15 45 03 (33) 1 69 15 64 70 E-mail: [EMAIL PROTECTED] *** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL AB has reached a settlement with NuSphere Corporation
On Thu, 7 Nov 2002, Michael Widenius wrote: > MySQL AB is pleased to announce that it has settled its lawsuit with > Progress Software Corporation and NuSphere Corporation. For more > information, see the joint press release at > > http://www.mysql.com/press/release_2002_14.html The press release sounds like typical PR puffery. Is any meat going to come out beyond "it's settled"? -- Programming is a Dark Art, and it will always be. The programmer is fighting against the two most destructive forces in the universe: entropy and human stupidity. They're not things you can always overcome with a "methodology" or on a schedule. -Damian Conway, Perl God - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error connecting to Mysql via Apache/PHP (Newbie)
Hello all, I'm a newbie to Mysql. I just installed mysql 3.23.53 on Solaris 7. I am running Apache 2.0.42 and PHP 4.2.3. I am trying to connect to my Mysql DB via Apache and PHP, but I get the following error: "Warning: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Warning: MySQL Connection Failed: Unknown MySQL Server Host '' (1) in helloSql.php on line 3 Could not connect" Here is the code I used. ", "", "") or die("Could not connect"); print "Connected successfully"; // Performing SQL query $query = "SELECT now()"; $result = mysql_query($query) or die("Query failed"); // Printing results in HTML print "\n"; while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { print "\t\n"; foreach ($line as $col_value) { print "\t\t$col_value\n"; } print "\t\n"; } print "\n"; // Closing connection mysql_close($link); ?> - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MySQL AB has reached a settlement with NuSphere Corporation
Hi! MySQL AB is pleased to announce that it has settled its lawsuit with Progress Software Corporation and NuSphere Corporation. For more information, see the joint press release at http://www.mysql.com/press/release_2002_14.html Regards, Monty -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Michael Widenius <[EMAIL PROTECTED]> / /|_/ / // /\ \/ /_/ / /__ MySQL AB, CTO /_/ /_/\_, /___/\___\_\___/ Helsinki, Finland <___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: ActiveX error Visual Basic Integration MySQL
Either you are not referencing the correct library for the database access or you cannot doit from the Learning Edition. HTH JFernando ** sql *** -Original Message- From: Oliver Gottwald [mailto:goto1@;enteract.com] Sent: November 6, 2002 22:26 To: [EMAIL PROTECTED] Subject: ActiveX error Visual Basic Integration MySQL Hi, I'm attempting to get the MySQL ODBC Drive to work with Visual Basic 6.0 Leaning version I'm getting the following error: Run-time error '429': ActiveX component can't create object On the following line cnMySql.CursorDriver = rdUseOdbc Does anyone have any idea what I might be doing wrong? Oliver - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Error when compiling mysql
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 07 November 2002 17:46, ktran wrote: > Configure command: ./configure > --with-unix-socket-path=/var/tmp/mysql.sock > --with-low-memory --with-mit-threads=yes > --without-perl > --enable-thread-safe-client --with-berkeley-db > --enable-local-infile > --with-innodb CC=gcc CXX=gcc > > I have confirmed that the libm.a exist in the /lib > directory. I also have zlib set in my path: > echo $PATH: > /home/webusr/bin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/lib: > /usr/openwin/bin:/usr/dt/bin:/opt/oracle/product/8.1.6/bin: > /opt/java/jsdk/bin:/home/webusr/make_379:/tmp/SUNWspro/WS6/bin: > /opt/FSFgzip/bin:/home/webusr/zlib-114/lib: > /home/webusr/zlib-114/bin:/usr/ccs/bin:/home/webusr/perl-5.6.1 It's not enough to have zlib in your $PATH - you need to tell the compiler where to find it. You can do that by using the - --with-named-z-libs=/home/webusr/zlib-114/lib configure option. Alternatively you could simply disable it by using - --with-named-z-libs=no - The dynamic linker will not find it in your path by default anyway. Bye, LenZ - -- - -- Lenz Grimmer <[EMAIL PROTECTED]> -o) [ICQ: 160767607 | Jabber: [EMAIL PROTECTED]]/\\ http://lenz.grimmer.com_\_v -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.0 (GNU/Linux) iD8DBQE9yqukSVDhKrJykfIRAt/cAJ9DiI+wYnDIH98h5HtQAf4544gN7ACeLNNX PhqHF/fop3TK7bEN2lO99hQ= =GJFt -END PGP SIGNATURE- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql hangs, restarts on odbc connect
Thank you, Egor! It looks like Red Hat released an update to its glibc libraries yesterday which fix this, so if anybody else is having problems, they should be able to fix it by updating. :) Sage On Thu, 2002-11-07 at 17:46, Egor Egorov wrote: > Sage, > Wednesday, November 06, 2002, 3:31:21 PM, you wrote: > > S> I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel > S> (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 > S> gHz. > > S> MySQL works perfectly fine when connecting from the localhost. However, > S> I have another machine that needs to connect via ODBC. The ODBC client > S> can connect, but as soon as it does, the connection is suddenly closed. > S> The same thing happens if I try to telnet to port 3306 on the host > S> machine. > > S> Every time this happens, I find the following entry in mysqld.log: > > S> Number of processes running now: 1 > S> mysqld process hanging, pid 906 - killed > S> 021106 15:51:41 mysqld restarted > S> /usr/libexec/mysqld: ready for connections > > S> I have no idea what is causing this. Does anyone have any suggestions as > S> to what might be the cause, or at least what I should double-check? > > Your problem is described here: > https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 > > You can downgrade glibc or install the patched one or install MySQL > server v3.23.53a > > > > -- > 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 > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Key/table cache size?
I've got a query that selects the count of distinct rows in a table; the table has 453632 rows and 24 distinct class_id's. mysql> SELECT count(DISTINCT(sig_class_id)) FROM acid_event; +---+ | count(DISTINCT(sig_class_id)) | +---+ |24 | +---+ 1 row in set (4.80 sec) mysql> select count(*) FROM acid_event; +--+ | count(*) | +--+ | 453632 | +--+ 1 row in set (3.12 sec) Is there any way to speed up these queries (InnoDB tables), or just put up? PS, at that number of distinct values, am I right in thinking that I should just drop the index on that column while I'm at it? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Host not allowed to connect problem
Make sure /etc/hosts has this line 127.0.0.1 localhost ~Kelly W. Black -Original Message- From: Kevin Passey [mailto:kpassey@;kdpsoftware.co.uk] Sent: Thursday, November 07, 2002 4:38 AM To: 'Timothy Venn'; Mysql (E-mail) Subject: RE: Host not allowed to connect problem Hello Tim, Are you getting this regardless of what you put in user,host and db tables. If you are I am getting the same thing. Any access to my database is denied except from the console. How did you install - from the rpm's ?? I will watch this thread as I am at a complete standstill with MySQL on Linux - it runs fine on windows (not what you want to hear). Regards Kevin -Original Message- From: Timothy Venn [mailto:tim@;optimus.co.za] Sent: 07 November 2002 09:42 To: [EMAIL PROTECTED] Subject: Host not allowed to connect problem Hi, I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do anything from the console command line but any connections from any other hosts causes a host "xxx.xxx.xxx.xxx" not allowed to connect to this mysql server. I have updated the host table to include a % for all hosts. Any suggestions Regards Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Newbie: Intersecting entities
John Coder wrote: right, let me know so I can breath a sigh of relief. And if the structure is right, could someone offer some guidance on how a query that allows me to query new_req using the intersecting entity (or three-way join, whatever it's called) would be written. That looks right to me, fwiw; now have your hand at some SELECTs off it and see how it performs. Don't forget to UNIQUE index (or primary) the pair of values in your intersection table if you don't have repeats of pairs (which you probably don't) and that its ok to add additional information to that table if that information relates to the particular pair in question ... Customers (id, name), PhoneNumbers (id, number), CustomerPhoneNumbers (customerid, phonenumberid, type {fax/phone}, contact {ask for who?}) ... -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timestamp updated on select
At 11:41 + 11/7/02, Nikolas Galanis wrote: Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id from poems,translations where poems.poem_id=translations.poem_id order by date_added desc limit 0,10 and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update Exactly. To prevent this, you can modify your UPDATE query to set the TIMESTAMP column to its current value. That will prevent it from being updated to the current date and time automatically. I don't know what your query looks like exactly, but you can write it something like this: UPDATE translations SET date_added = date_added, translation_views = translation_views + 1 ... CREATE TABLE `poems` ( `poem_id` smallint(4) unsigned NOT NULL auto_increment, `poem_title` varchar(38) default NULL, `poet_id` smallint(4) unsigned default NULL, `comments` varchar(255) default NULL, `poem_views` smallint(5) unsigned NOT NULL default '0', `poem` text, `poem_comment` text NOT NULL, PRIMARY KEY (`poem_id`) ) TYPE=MyISAM and CREATE TABLE `translations` ( `poem_id` smallint(4) unsigned NOT NULL default '0', `language` varchar(14) NOT NULL default 'english', `translation_title` varchar(54) default NULL, `translation_text` text, `footnotes` text, `made_by_id` smallint(4) unsigned NOT NULL default '0', `contributed` varchar(70) default NULL, `translation_views` smallint(5) unsigned NOT NULL default '0', `date_added` timestamp(14) NOT NULL, PRIMARY KEY (`poem_id`,`language`,`made_by_id`), KEY `language` (`language`) ) TYPE=MyISAM Paul DuBois wrote: At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: >Hello > >I have a column of type timestamp(14) and I thought it would not be >updated on a query with simple select statements, though it does! I >read in the manual that it >shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the > TIMESTAMP column to *change*? That shouldn't happen. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How MySQL Works?
Philipp Steinkrueger wrote: if you dont understand the language mysql is written in you are probably not interested in "how" it works, technically. this I've actually had any number of people ask me how to do things that they think they can understand without knowing anything about programming. Like how to design a search engine (knowing nothing about programming or databases) or how NTFS works (knowing nothing about disk storage beyond the fact that there are icons to represent files and 'folders'), etc. I answered as I did, as you probably noted :-), because if the poster doesn't understand C, there's not much point in answering the intent of the question at all. FWIW (to everyone else), I'm a C/C++/PERL/Python/bah/foo/bar programmer and I probably wouldn't delve into how MySQL handles the setup for a query in the source code unless I had a pencil and paper handy and felt like using Ctrl-] a lot ... (I use vim). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: merging multiple rows results in join statement
[EMAIL PROTECTED] wrote: This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, R&D| | 164 | IT, R&D | | 165 | Video, Multimedia| | ... | ... | +--+--+ This is an output / formatting issue; you'll either have to do it externally (which you said you can't), use a string concat function (not sure if that'll work or not; never done it in SQL), or do two queries; SELECT ticketID LIMIT 10; SELECT pipelineName ... WHERE ticketID IN (previous response list); ... then format your output accordingly. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timestamp updated on select
Nikolas Galanis wrote: and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update Any change to the record will update the timestamp; what you probably want is a seperate counting table for views instead; PoemViews ( poemid smallint unsigned not null primary key, count smallint unsigned not null default 0 ); ... Then do a "REPLACE INTO PoemViews (poemid, count) SELECT 14, count FROM PoemViews WHERE poemid = 14" ... or whatever (where 14 is an arbitrary number in this case; I'd use a server-side variable, personally). You could also make a views table thats more universal to the site (which is what I do) and then point to it from your poems table (ViewsID type thing) ... your choice. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
merging multiple rows results in join statement
My last post wasn't titled accurately. Sorry for the repost. I have 3 tables. "Ticket" "Pipeline_Dept", and "Ticket_Matrix". Ticket_Matrix matches tickets to pipeline depts. A ticket can be posted to multiple pipeline depts. I want to select all tickets and the pipeline departments they are posted to but only one row per ticket. So: SELECT t.ticketID, p.pipelineName FROM Ticket t LEFT JOIN Ticket_Matrix tm ON t.ticketID = tm.ticketID LEFT JOIN Pipeline_Dept p ON p.pipelineID = tm.pipelineID This is what I want: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT, Adv.Tech, R&D| | 164 | IT, R&D | | 165 | Video, Multimedia| | ... | ... | +--+--+ This is what I get now: +--+--+ | ticketID | pipelineName | +--+--+ | 163 | IT | | 163 | Adv.Tech | | 163 | R&D | | 164 | IT | | 164 | R&D | | 165 | Video| | 165 | Multimedia | | ... | ... | +--+--+ I cannot do it with PHP because my query depends on LIMIT and returning a set number of rows. If I use PHP to do the concat-ing, the number of rows may be < LIMIT and that is undesirable. I appreciate any help. - This mail sent through IMP: http://horde.org/imp/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Error when compiling mysql
Description: checking size of char... configure: error: No size for char type. A likely cause for this could be that there isn't any static libraries installed. You can verify this by checking if you have libm.a in /lib, /usr/lib or some other standard place. If this is the problem, install the static libraries and try again. If this isn't the problem, examine config.log for possible errors. If you want to report this, use 'scripts/mysqlbug' and include at least the last 20 rows from config.log! How-to-repeat: ./configure --prefix=/opt/apache/mysql MySQL support: none Synopsis: unable to compile source code due to char type error MySQL release: mysql-3.23.51 (Source distribution) Machine/OS: Sun Solaris 2.7 Environment: System: SunOS saspcd02 5.7 Generic_106541-18 sun4u sparc SUNW,Ultra-80 Architecture: sun4 GCC: Reading specs from /usr/local/lib/gcc-lib/sparc-sun-solaris2.7/2.95.3/specs gcc version 2.95.3 20010315 (release) Compilation info: CC='gcc' CFLAGS='' CXX='gcc' CXXFLAGS='' LDFLAGS='' LIBC: -rw-r--r-- 1 bin bin 1711420 Jan 3 2002 /lib/libc.a lrwxrwxrwx 1 root root 11 Sep 13 2000 /lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125660 Jan 3 2002 /lib/libc.so.1 -rw-r--r-- 1 bin bin 1711420 Jan 3 2002 /usr/lib/libc.a lrwxrwxrwx 1 root root 11 Sep 13 2000 /usr/lib/libc.so -> ./libc.so.1 -rwxr-xr-x 1 bin bin 1125660 Jan 3 2002 /usr/lib/libc.so.1 Configure command: ./configure --with-unix-socket-path=/var/tmp/mysql.sock --with-low-memory --with-mit-threads=yes --without-perl --enable-thread-safe-client --with-berkeley-db --enable-local-infile --with-innodb CC=gcc CXX=gcc I have confirmed that the libm.a exist in the /lib directory. I also have zlib set in my path: echo $PATH: /home/webusr/bin:/usr/sbin:/bin:/usr/bin:/usr/local/bin:/lib:/usr/openwin/bin:/usr/dt/bin:/opt/oracl e/product/8.1.6/bin:/opt/java/jsdk/bin:/home/webusr/make_379:/tmp/SUNWspro/WS6/bin:/opt/FSFgzip/bin: /home/webusr/zlib-114/lib:/home/webusr/zlib-114/bin:/usr/ccs/bin:/home/webusr/perl-5.6.1 __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: timestamp updated on select
Ok, here we are, in much detail. There is a table called translations and another one called poems. Their structure is given in the end. The query (given by a php script by the way) is: select poems.poem_id, language, translation_title,made_by_id from poems,translations where poems.poem_id=translations.poem_id order by date_added desc limit 0,10 and with this I intend to retrieve the 10 latest additions of translations. However, when running the script, I noticed that always, on the top of the results was the translation link I had clicked last. And this happens all the time. Now that I think of it again, the clicked link contains a mysql query which increments the translation views by one. H.maybe this does the unwanted update CREATE TABLE `poems` ( `poem_id` smallint(4) unsigned NOT NULL auto_increment, `poem_title` varchar(38) default NULL, `poet_id` smallint(4) unsigned default NULL, `comments` varchar(255) default NULL, `poem_views` smallint(5) unsigned NOT NULL default '0', `poem` text, `poem_comment` text NOT NULL, PRIMARY KEY (`poem_id`) ) TYPE=MyISAM and CREATE TABLE `translations` ( `poem_id` smallint(4) unsigned NOT NULL default '0', `language` varchar(14) NOT NULL default 'english', `translation_title` varchar(54) default NULL, `translation_text` text, `footnotes` text, `made_by_id` smallint(4) unsigned NOT NULL default '0', `contributed` varchar(70) default NULL, `translation_views` smallint(5) unsigned NOT NULL default '0', `date_added` timestamp(14) NOT NULL, PRIMARY KEY (`poem_id`,`language`,`made_by_id`), KEY `language` (`language`) ) TYPE=MyISAM Paul DuBois wrote: At 2:09 +0200 11/7/02, Galanis Nikolas wrote: Yes, that is exactly what happens. It is updated with a simple select statement. It is a select from a table which contains only one timestamp column and the order by is made by this timstamp column. And every time the value if the timestamp is updated. That seems fairly strange. Let's see an example. On Wed, 6 Nov 2002, Paul DuBois wrote: At 23:47 + 11/6/02, Nikolas Galanis wrote: >Hello > >I have a column of type timestamp(14) and I thought it would not be >updated on a query with simple select statements, though it does! I >read in the manual that it >shouldn't, what could be wrong? Thanks. You're saying that performing a SELECT on the table causes the > TIMESTAMP column to *change*? That shouldn't happen. -- - - Nikolas Galanis - - Computer Engineering & Informatics Department - - University of Patras - - http://www.ceid.upatras.gr- - 061 997707- - - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Access replacement...
Brad. Not sure if you got my last mail but did you try Omnis Studio from www.omnis.net (trial download available). It is available for MacOS Classic, OSX, Windows, Solaris and Linux. Never used the Solaris/Linux versions but I do use the Mac and Windows versions every day. HTH Kev. > -- > From: Brian Johnson > Sent: Thursday, November 7, 2002 15:58 PM > To: MySQL mailing List > Subject: Re: Access replacement... > > That looks like a windows-only solution > > > > John Ragan ([EMAIL PROTECTED]) wrote*: > > > > > >i've been hesitant to respond because i'm not > >sure that this is a head on solution for you, but > >take a look at http://corereader.com > > > >it's certainly easier to use than access queries. > >simple point and click to build complex output. > > > >however, it's not designed for the fancy > >formatted output to which your folks are > >accustomed. it'll do text, browser, schema xml, > >and html, but it's all (intentionally) plain > >vanilla. > > > > > > > >> Brad wrote: > >> > >> >A programming environment; > >> > > >> > >> Python comes to mind immediately; very easy to learn, especially > >> compared to VB, and its even Windows compatible (MFC even). > >> > >> >A database maintenance utility; > >> > > >> > >> To what end? > >> > >> >A database query tool; > >> > > >> > >> Visual query tools exist for MySQL already; someone keeps posting the > >> name of one from time to time ... > >> > >> >A report builder > >> > > >> > >> Any report program that works from ODBC will work. > >> > >> -- > >> Michael T. Babcock > >> C.T.O., FibreSpeed Ltd. > >> http://www.fibrespeed.net/~mbabcock > >> > >> > >> > > > > > > > >-- > >John Ragan > >[EMAIL PROTECTED] > >http://www.CoreReader.com/ This e-mail has been scanned for all viruses by Star Internet. The service is powered by MessageLabs. For more information on a proactive anti-virus service working around the clock, around the globe, visit: http://www.star.net.uk - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
John, You're making sense. If you wanted to find all the systems used on project Test Bed Alpa, you'd do something like this: Select sys_name, s.id, project_name FROM systems s, new_req n,ie_sys_req i WHERE s.id = i.sys_id AND n.id = i.proj_name_id AND n.id = 344; Hope this helps, Andy mysql query > -Original Message- > From: John Coder [mailto:jcoder@;insightbb.com] > Sent: 07 November 2002 14:59 > To: Richard Forgo > Cc: [EMAIL PROTECTED] > Subject: RE: Newbie: Intersecting entities > > > On Wed, 2002-11-06 at 23:25, Richard Forgo wrote: > > Sorry for being vague. I think the closest thing I can find to it is, > > possibly, a three-way join. I'm trying to figure out how to write the > > query. > > > > I've got the following tables: > > > > systems > > > > sys_nameID > > > > Abrams 202 > > Patriot 544 > > Stinger 229 > > > > ... and ... > > > > new_req > > > > proj_name ID > > > > Test Bed Alpha 344 > > Tracked Wheels 989 > > Battle Monitor 823 > > Shoulder Harness654 > > Ammo Flask 454 > > Spotter 773 > > > > There may be multiple new requirements for a single system. To > > accommodate them, I created a new table -- an intersecting entity is > > what I recall it being called -- to bridge the two. I can't keep the > > multiple references to new_req in the systems table, nor can I keep them > > in the new_req table. As best I can figure, I need to have a bridge > > table ... e.g., > > > > ie_sys_req > > > > sys_id proj_name_id > > > > 202344 > > 202989 > > 202823 > > 544654 > > 544454 > > 544773 > > > > If this seems peculiar, have patience with me I'm new at this. If it's > > right, let me know so I can breath a sigh of relief. And if the > > structure is right, could someone offer some guidance on how a query > > that allows me to query new_req using the intersecting entity (or > > three-way join, whatever it's called) would be written. > > > > Thanks, > > > > > > Rik Forgo > > JIST3 > > Army Test, Training and Technology Integration Office (T3I) > > Diverse Technologies Corp. > > (c) 443.463.8571 > > (h) 410.859.8474 > > > > > > > -Original Message- > > > From: John Ragan [mailto:jragan@;arkansas.net] > > > Sent: Wednesday, November 06, 2002 6:55 PM > > > To: [EMAIL PROTECTED]; Richard Forgo > > > Subject: Re: Newbie: Intersecting entities > > > > > > > > > if a succinct statement is possible, perhaps you > > > could give us an idea of its nature? > > > > > > somebody may be familiar with the concept under a > > > different name. > > > > > > > > > > I'm trying to find some documentation on creating intersecting > > entities > > > > in MySQL, but haven't been able to track any info down on the MySQL > > site > > > > or on the web. At least we called them intersecting entities while > > I > > > > was in Oracle training (which was some time ago). I think I > > remember > > > > how to set them up, but I'd love to have something to refer to > > quickly > > > > before I start. Can anyone point me in the right direction? > > > > > > There is an example and full blown script in a book by Michael Koffler > called MYSQL. His Url is www,Kofler.cc If I remember it correctly he had > a "intersecting entity" involving Authors and Publishers in his > mylibrary example. > > John Coder > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysql backup user permissions?
i want to add a user to my system that has permissions to backup all the databases using mysqlhotcopy. i don't want to use the root user. so what permissions (minium set) should i give the user in order to accomplish this. thanks in advance, shon - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
That looks like a windows-only solution John Ragan ([EMAIL PROTECTED]) wrote*: > > >i've been hesitant to respond because i'm not >sure that this is a head on solution for you, but >take a look at http://corereader.com > >it's certainly easier to use than access queries. >simple point and click to build complex output. > >however, it's not designed for the fancy >formatted output to which your folks are >accustomed. it'll do text, browser, schema xml, >and html, but it's all (intentionally) plain >vanilla. > > > >> Brad wrote: >> >> >A programming environment; >> > >> >> Python comes to mind immediately; very easy to learn, especially >> compared to VB, and its even Windows compatible (MFC even). >> >> >A database maintenance utility; >> > >> >> To what end? >> >> >A database query tool; >> > >> >> Visual query tools exist for MySQL already; someone keeps posting the >> name of one from time to time ... >> >> >A report builder >> > >> >> Any report program that works from ODBC will work. >> >> -- >> Michael T. Babcock >> C.T.O., FibreSpeed Ltd. >> http://www.fibrespeed.net/~mbabcock >> >> >> > > > >-- >John Ragan >[EMAIL PROTECTED] >http://www.CoreReader.com/ > > >- >Before posting, please check: > http://www.mysql.com/manual.php (the manual) > http://lists.mysql.com/ (the list archive) > >To request this thread, e-mail <[EMAIL PROTECTED]> >To unsubscribe, e-mail <[EMAIL PROTECTED]> >Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
i've been hesitant to respond because i'm not sure that this is a head on solution for you, but take a look at http://corereader.com it's certainly easier to use than access queries. simple point and click to build complex output. however, it's not designed for the fancy formatted output to which your folks are accustomed. it'll do text, browser, schema xml, and html, but it's all (intentionally) plain vanilla. > Brad wrote: > > >A programming environment; > > > > Python comes to mind immediately; very easy to learn, especially > compared to VB, and its even Windows compatible (MFC even). > > >A database maintenance utility; > > > > To what end? > > >A database query tool; > > > > Visual query tools exist for MySQL already; someone keeps posting the > name of one from time to time ... > > >A report builder > > > > Any report program that works from ODBC will work. > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
how to Load Test Master-Slave Architecture ?
Hi, I have configured a master slave ring architecture. Can anyone suggest me how to load test this architecture ? I am using three MySQL servers in the following fashion : A --> B --> C --> A where A is the Master to B, B is the Master to C and C is the Master to A. My aim is to distribute the database load equally on the three MySQL servers. Please suggest me some way to do it. Thanks Akash Agarwal Senior Member Technical Staff, Intersolutions Pvt Ltd, NOIDA, INDIA (www.lotusinterworks.com) (www.alacre.com) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
aha! sure. you weren't being vague. you just needed to educate me. some of us have used intersecting entities through the years, but didn't know that there was a fancy name for what we were doing. if my memory weren't so bad, i'd use it to impress people in the next interview. in this case, simply do a three way multiple join with the intersecting entity in the middle. something like this: select table1.col2, table 3.col2 from table1 left join table2 on table1.col1 = table2.col1 left join table3 on table2.col2 = table3.col1 or you could use an equal join with the intersecting entity in the middle. if you have a windows box that you can use as a front end, i strongly recommend that you download corereader because its point and click queries can make a six way join look simple. then, it'll show you the sql code. best of all is that it's free. http://corereader.com > Sorry for being vague. I think the closest thing I can find to it is, > possibly, a three-way join. I'm trying to figure out how to write the > query. > > I've got the following tables: > > systems > > sys_nameID > > Abrams 202 > Patriot 544 > Stinger 229 > > ... and ... > > new_req > > proj_name ID > > Test Bed Alpha 344 > Tracked Wheels 989 > Battle Monitor 823 > Shoulder Harness654 > Ammo Flask 454 > Spotter 773 > > There may be multiple new requirements for a single system. To > accommodate them, I created a new table -- an intersecting entity is > what I recall it being called -- to bridge the two. I can't keep the > multiple references to new_req in the systems table, nor can I keep them > in the new_req table. As best I can figure, I need to have a bridge > table ... e.g., > > ie_sys_req > > sys_id proj_name_id > > 202344 > 202989 > 202823 > 544654 > 544454 > 544773 > > If this seems peculiar, have patience with me I'm new at this. If it's > right, let me know so I can breath a sigh of relief. And if the > structure is right, could someone offer some guidance on how a query > that allows me to query new_req using the intersecting entity (or > three-way join, whatever it's called) would be written. > > Thanks, > > > Rik Forgo > JIST3 > Army Test, Training and Technology Integration Office (T3I) > Diverse Technologies Corp. > (c) 443.463.8571 > (h) 410.859.8474 > > > > -Original Message- > > From: John Ragan [mailto:jragan@;arkansas.net] > > Sent: Wednesday, November 06, 2002 6:55 PM > > To: [EMAIL PROTECTED]; Richard Forgo > > Subject: Re: Newbie: Intersecting entities > > > > > > if a succinct statement is possible, perhaps you > > could give us an idea of its nature? > > > > somebody may be familiar with the concept under a > > different name. > > > > > > > I'm trying to find some documentation on creating intersecting > entities > > > in MySQL, but haven't been able to track any info down on the MySQL > site > > > or on the web. At least we called them intersecting entities while > I > > > was in Oracle training (which was some time ago). I think I > remember > > > how to set them up, but I'd love to have something to refer to > quickly > > > before I start. Can anyone point me in the right direction? > > > > > > > > > Rik Forgo > > > JIST3 > > > Army Test, Training and Technology Integration Office (T3I) > > > Diverse Technologies Corp. > > > (c) 443.463.8571 > > > (h) 410.859.8474 > > > > > > > > > > > > > > > > > -- > > John Ragan > > [EMAIL PROTECTED] > > http://www.CoreReader.com/ > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > [EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > -- John Ragan [EMAIL PROTECTED] http://www.CoreReader.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How MySQL Works?
Hi, if you dont understand the language mysql is written in you are probably not interested in "how" it works, technically. this perspective can only be explained by using terms from the programming language. i guess you are interested in learning more about the user-level, like how to set it up and how to do a query and this stuff. just go read the documentation at www.mysql.com. good luck, philipp - Original Message - From: "Unidux (S) - Han Lin" <[EMAIL PROTECTED]> To: "Michael T. Babcock" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 3:06 PM Subject: Re: How MySQL Works? > Hi Michael, > > Thanks for your suggestion, but I didn't read C code, and I don't think so > someone in this list will:) Maybe short explanation from you also can:) > > Regards, > Han Lin > > - Original Message - > From: "Michael T. Babcock" <[EMAIL PROTECTED]> > To: "Unidux (S) - Han Lin" <[EMAIL PROTECTED]> > Cc: <[EMAIL PROTECTED]> > Sent: Thursday, November 07, 2002 9:45 PM > Subject: Re: How MySQL Works? > > > > Unidux (S) - Han Lin wrote: > > > > >I wanna know what the steps MySQL perform when we do INSERT in Database? > > > > > >Anyone can explain? Or anyone here have some reference about how MySQL > > >works? > > > > > > > > > > The source code is freely available from the website; download it and > > take a read -- if you don't read C code, grab someone who does :). > > > > -- > > Michael T. Babcock > > C.T.O., FibreSpeed Ltd. > > http://www.fibrespeed.net/~mbabcock > > > > > > > > - > > Before posting, please check: > >http://www.mysql.com/manual.php (the manual) > >http://lists.mysql.com/ (the list archive) > > > > To request this thread, e-mail <[EMAIL PROTECTED]> > > To unsubscribe, e-mail > <[EMAIL PROTECTED]> > > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > > > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Heikki Tuuri wrote: log files are as important a part of a database as ibdata files. Trust me, I know; they didn't get backed up I've realized too late though ... You can try using some dummy log files from another installation and set force recovery to 6 to skip the log scan. ... what's the minimum configuration I need to set up to get a parallel copy of MySQL running (or on a different machine?) with those data files? If I just specify the data files with the same sizes and log directory (bringing in fake logs), will it work, or do I need additional information for MySQL to know what's going on? -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Snort & ACID (from CERT)
Has anyone else using Snort with CERT's ACID (Analysis Console for Intrusion Databases) reporting software (PHP) done work on optimizing their tables? I've found a few instances where TEXT was used instead of VARCHAR unnecessarily and prevented indexes from being created, etc. Any other tips? http://www.cert.org/kb/aircert/ http://www.snort.org/ SQL. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Michael, - Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 4:36 PM Subject: Re: InnoDB recovery > Heikki Tuuri wrote: > > >if you have on tape old images of ibdata files and ib_logfile's, you can try > >crash recovery from them, possibly using innodb_force_recovery=6. > > > > > > Unfortunately, as mentionned, I only have the data files on tape, no log > files. > > Are the data files 'dumpable' ?? log files are as important a part of a database as ibdata files. You can try using some dummy log files from another installation and set force recovery to 6 to skip the log scan. > SQL > > -- > Michael T. Babcock Regards, Heikki > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
On Wed, 2002-11-06 at 23:25, Richard Forgo wrote: > Sorry for being vague. I think the closest thing I can find to it is, > possibly, a three-way join. I'm trying to figure out how to write the > query. > > I've got the following tables: > > systems > > sys_nameID > > Abrams 202 > Patriot 544 > Stinger 229 > > ... and ... > > new_req > > proj_name ID > > Test Bed Alpha 344 > Tracked Wheels 989 > Battle Monitor 823 > Shoulder Harness654 > Ammo Flask 454 > Spotter 773 > > There may be multiple new requirements for a single system. To > accommodate them, I created a new table -- an intersecting entity is > what I recall it being called -- to bridge the two. I can't keep the > multiple references to new_req in the systems table, nor can I keep them > in the new_req table. As best I can figure, I need to have a bridge > table ... e.g., > > ie_sys_req > > sys_id proj_name_id > > 202344 > 202989 > 202823 > 544654 > 544454 > 544773 > > If this seems peculiar, have patience with me I'm new at this. If it's > right, let me know so I can breath a sigh of relief. And if the > structure is right, could someone offer some guidance on how a query > that allows me to query new_req using the intersecting entity (or > three-way join, whatever it's called) would be written. > > Thanks, > > > Rik Forgo > JIST3 > Army Test, Training and Technology Integration Office (T3I) > Diverse Technologies Corp. > (c) 443.463.8571 > (h) 410.859.8474 > > > > -Original Message- > > From: John Ragan [mailto:jragan@;arkansas.net] > > Sent: Wednesday, November 06, 2002 6:55 PM > > To: [EMAIL PROTECTED]; Richard Forgo > > Subject: Re: Newbie: Intersecting entities > > > > > > if a succinct statement is possible, perhaps you > > could give us an idea of its nature? > > > > somebody may be familiar with the concept under a > > different name. > > > > > > > I'm trying to find some documentation on creating intersecting > entities > > > in MySQL, but haven't been able to track any info down on the MySQL > site > > > or on the web. At least we called them intersecting entities while > I > > > was in Oracle training (which was some time ago). I think I > remember > > > how to set them up, but I'd love to have something to refer to > quickly > > > before I start. Can anyone point me in the right direction? > > > There is an example and full blown script in a book by Michael Koffler called MYSQL. His Url is www,Kofler.cc If I remember it correctly he had a "intersecting entity" involving Authors and Publishers in his mylibrary example. John Coder - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysqld_multi
Yes, that is what I meant. Thank you for the clarification and response. Any ideas on maximizing *server* performance besides the usual db-specific optimizations like indexing? If not too much trouble, could you give me a brief explanation why I would not see a performance boost if running separate servers on the same box? My thoughts, if have one MySQL server running on one box with 10 databases, and 1 or 2 of those databases are getting the majority of the requests and tying up the processes, seems like the other 8 would suffer. - Original Message - From: "Iikka Meriläinen" <[EMAIL PROTECTED]> To: "Paul DuBois" <[EMAIL PROTECTED]> Cc: "Raymer, Chris" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 12:42 AM Subject: Re: mysqld_multi On Wed, 6 Nov 2002, Paul DuBois wrote: > At 13:22 -0600 11/6/02, Raymer, Chris wrote: > >Any opinions on running mysqld_multi? Our architecture, X-serve, > >2GBs RAM,Dual Procs, 480 GB stogage as "Master" MySQL server > >replicated to a less impressive server. Seems logical to separate > >the "heavy-hitter" dbs to their own "servers" and take more > >advantage of the server's resources. > > What's this got to do with mysqld_multi, which is used for running > multiple servers on the *same* machine? Hi! Maybe Mr. Raymer means that he would get more performance when running multiple _MySQL_ servers (i.e. instances) on a same _physical_ server (i.e. box). Getting more performance this way is unfortunately a false assumption, though. More stability, perhaps, but not performance. Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: InnoDB row level locking?
>-Original Message- >From: Fernando Grijalba [mailto:fernando@;ggtours.on.ca] >Sent: Wednesday, November 06, 2002 11:41 AM >To: MySQL Help >Subject: InnoDB row level locking? > > >In the documentation it says that InnoDB supports row level >locking. How >can I ensure that rows are locked using ADO in a VB Applications >communicating with MySQL through MyODBC? > >I have tried setting my Recordsets to adLockPessimistic, but >that does not >seam to work. Make sure you are working inside transactions. then add this text to the end of your select statments "FOR UPDATE" This will ensure that no one else updates after you have selected the record. But it will still let others read. Commiting your transaction will release the lock. sean. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mySQL table as Perl Queue
I've done a specialized, high-volume FIFO queue implementation using MySql that performs extremely well - if your concern is speed I think you'll likely do fine. Of course, speed is relative to each solution - what kind of response time for enqueue/deque operations do you require? In my situation, we enqueue in less than 1 ms on average and dequeue speed depends somewhat on queue depth (but it's not much different). regards, Rick - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB recovery
Heikki Tuuri wrote: if you have on tape old images of ibdata files and ib_logfile's, you can try crash recovery from them, possibly using innodb_force_recovery=6. Unfortunately, as mentionned, I only have the data files on tape, no log files. Are the data files 'dumpable' ?? SQL -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: DateTime comparation problems
Andrew, Wednesday, November 06, 2002, 7:39:16 PM, you wrote: AS> SELECT ... FROM table o WHERE o.date >= 2002090100 AND o.date<=2002110624 AS> MySQL 3.23.xx - work (returns >0 rows) AS> MySQL 4.0.4 - not work (returns 0 rows) AS> P.S. also in 4.0.4 not work BETWEEN in this case (but as i can AS> see it will be fixed in next release) Hi! Thank you for bug report! Seems, it also was fixed in 4.0.5. Could you test it at the next week on 4.0.5? -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Character-sets
Michelle, Wednesday, November 06, 2002, 4:25:32 PM, you wrote: MdB> If I want to create a database with an arabic MdB> character-set, will only the data-cells be affected by MdB> this or will the table names, column names etc also be MdB> in arabic? You can use characters from current character set in table, column names: http://www.mysql.com/doc/en/Legal_names.html Unfortunatly MySQL doesn't have arabic character set, in this case you can use `` around table names. MdB> Can I mix two character-sets (English and Arabic) in MdB> the same database, or does it have to be in two MdB> separate databases? You can store data in different character set, but sort order may be wrong for arabic characters. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: load data infile syntax
>If the data contains "\", then database will automatically takes "\" >away and shift 1 byte left. >My data will mass up. That is why I still need "\" Does your data actually include backslash characters? If you want to import them as they are, you definitely don't want to ESCAPE BY them. Escaping is used to treat otherwise special characters as nonspecial. For example, quotes and commas have special meaning in some text files, but you can 'escape' the special interpretation by using a scheme like prefixing them with a character that's "more special" than they are. The prefix is usually a backslash, which means that if you really do want a backslash, you need to use two of them (the first one says to treat the next character in a different way than usual). So the moral of the story is this: If you're trying to import backslashes into an SQL table, and your text file doesn't have backslashes doubled, don't choose a backslash as your ESCAPE BY character. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How MySQL Works?
Hi Michael, Thanks for your suggestion, but I didn't read C code, and I don't think so someone in this list will:) Maybe short explanation from you also can:) Regards, Han Lin - Original Message - From: "Michael T. Babcock" <[EMAIL PROTECTED]> To: "Unidux (S) - Han Lin" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, November 07, 2002 9:45 PM Subject: Re: How MySQL Works? > Unidux (S) - Han Lin wrote: > > >I wanna know what the steps MySQL perform when we do INSERT in Database? > > > >Anyone can explain? Or anyone here have some reference about how MySQL > >works? > > > > > > The source code is freely available from the website; download it and > take a read -- if you don't read C code, grab someone who does :). > > -- > Michael T. Babcock > C.T.O., FibreSpeed Ltd. > http://www.fibrespeed.net/~mbabcock > > > > - > Before posting, please check: >http://www.mysql.com/manual.php (the manual) >http://lists.mysql.com/ (the list archive) > > To request this thread, e-mail <[EMAIL PROTECTED]> > To unsubscribe, e-mail <[EMAIL PROTECTED]> > Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php > > - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Access replacement...
Brad wrote: A programming environment; Python comes to mind immediately; very easy to learn, especially compared to VB, and its even Windows compatible (MFC even). A database maintenance utility; To what end? A database query tool; Visual query tools exist for MySQL already; someone keeps posting the name of one from time to time ... A report builder Any report program that works from ODBC will work. -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: MySQL CPU usage skyrocketing
Ok, we know that FreeBSD has problems with its thread implementation; however, I'd like to know if the MySql guys know exactly what causes the problems to which Mr Zawodny refers. I'm running FreeBSD 4.6.2, and have seen the 'rogue thread' problem before which leads me to believe that either FreeBSD has not addressed the problem or MySql hasn't. To be fair MySql says in its documentation that FreeBSD is not recommended because of its threading implementation. Furthermore, I wonder if anyone has been working with MySql and FreeBSD 5.0 DP1 and, if so, what behavior they've experienced. Peter <^_^> -Original Message- From: Simon Green [mailto:sgreen@;eurobell.net] Sent: Thursday, November 07, 2002 6:04 AM To: 'Bogdan TARU'; [EMAIL PROTECTED] Subject: RE: MySQL CPU usage skyrocketing See links form mail list. http://jeremy.zawodny.com/blog/archives/000203.html#000203 http://jeremy.zawodny.com/blog/archives/000264.html#000264 Simon -Original Message- From: Bogdan TARU [mailto:bgd@;icomag.de] Sent: 07 November 2002 10:35 To: [EMAIL PROTECTED] Subject: MySQL CPU usage skyrocketing Hi, I am running MySQL 3.23.41 on a FreeBSD 4.4, and I experience very high loads of the machine, without any apparent reason. We have a new project using this MySQL engine, with lots of inserts/deletes. But it happens that in the mornings, when nobody makes any kind of access to the database, we still have a MySQL daemon eating up 99% of CPU. If I log in as 'root' to the mysql server and make a 'show processlist', the only process in the 'query' command is mine ('show processlist'), all the others are in sleep mode (with NULL info). Is there any periodic maintanance/optimization work that the mysql server is doing? If so, why does it take so long? Can I schedule it sometimes during the night (and if so, how?) Thanks, bogdan iCom Media AG Kirchweg 36 Koln, 50858 Germany Phone: +49-(0)221-485-689-16 Fax : +49-(0)221-485-689-20 Mobile:+49-(0)173-906-46-01 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How MySQL Works?
Unidux (S) - Han Lin wrote: I wanna know what the steps MySQL perform when we do INSERT in Database? Anyone can explain? Or anyone here have some reference about how MySQL works? The source code is freely available from the website; download it and take a read -- if you don't read C code, grab someone who does :). -- Michael T. Babcock C.T.O., FibreSpeed Ltd. http://www.fibrespeed.net/~mbabcock - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Newbie: Intersecting entities
> systems > > sys_nameID > > Abrams 202 > Patriot 544 > Stinger 229 > > ... and ... > > new_req > > proj_name ID > > Test Bed Alpha 344 > Tracked Wheels 989 > Battle Monitor 823 > Shoulder Harness654 > Ammo Flask 454 > Spotter 773 > > There may be multiple new requirements for a single system. To > accommodate them, I created a new table -- an intersecting entity is > what I recall it being called -- to bridge the two. I can't keep the > multiple references to new_req in the systems table, nor can > I keep them > in the new_req table. As best I can figure, I need to have a bridge > table ... e.g., You mean a Many-to-Many or N-to-M join. IE, a system can be used in more than one project, and a project can have more than one system. > > ie_sys_req > > sys_id proj_name_id > > 202344 > 202989 > 202823 > 544654 > 544454 > 544773 > > If this seems peculiar, have patience with me I'm new at > this. If it's > right, let me know so I can breath a sigh of relief. And if the That is in fact how to implement an M-to-N relation in a relational database. Sigh away. :) > structure is right, could someone offer some guidance on how a query > that allows me to query new_req using the intersecting entity (or > three-way join, whatever it's called) would be written. > OK, so if you want to see all the systems involved in each project, do something like: select proj_name, sys_name from systems, new_req, ie_sys_req where new_req.ID=ie_sys_req.proj_name_id and ie_sys_req.sys_id=systems.ID If you'r going for speed, you're going to want an index on each column that contains an ID, so two indices in ie_sys_req. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Complicated (to me) query
> What I want to do is display to the user a list of files that > require a > security level that is less than or equal to the user's > security level, with > formatted last name and first name and date if the file is > checked out. > > Checked out by is a foreign key refering to username in the > staff table, and > the security level and required security level are also related. > > This is my attempt: > > SELECT file_name, CONCAT(last_name, ', ', first_name) AS name, > DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date > FROM file LEFT JOIN staff ON file.checked_out_by = staff.username > WHERE staff.username = 'mike' > AND staff.security_level > file.required_security_level; > Your query won't do what you want because you are only selecting files that are checked out by mike (staff.username='mike'). You'll need two queries to do this. First, get the user's security level and store it in a user variable: select @SecLev:=security_level from staff where username='mike'; Then, you can do your left join as you've described above: SELECT file_name, CONCAT(last_name, ', ', first_name) AS name, DATE_FORMAT(date_checked_out,'%b %D, %Y (%r)') AS date FROM file LEFT JOIN staff ON file.checked_out_by = staff.username WHERE @SecLev > file.required_security_level; By the way, when you're doing a left join, you should never include a column from the right table in your where clause. This is because the whole reason for doing a left join is to include rows that have no match in the right table, and any such rows will have all columns in the right table set to NULL. So, if you do a where condition on a column in the right table, you've just negated the effect of your left join (unless you're checking for IS NULL). - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Success !!!
Hi all, It now works I did the following Under the command line I did "insert into user (Host) values ('192.168.8.19')" and restarted mysql. I can now connect. Thanks for the help. Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: Host not allowed to connect problem
Hello Tim, Are you getting this regardless of what you put in user,host and db tables. If you are I am getting the same thing. Any access to my database is denied except from the console. How did you install - from the rpm's ?? I will watch this thread as I am at a complete standstill with MySQL on Linux - it runs fine on windows (not what you want to hear). Regards Kevin -Original Message- From: Timothy Venn [mailto:tim@;optimus.co.za] Sent: 07 November 2002 09:42 To: [EMAIL PROTECTED] Subject: Host not allowed to connect problem Hi, I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do anything from the console command line but any connections from any other hosts causes a host "xxx.xxx.xxx.xxx" not allowed to connect to this mysql server. I have updated the host table to include a % for all hosts. Any suggestions Regards Tim - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: mysql hangs, restarts on odbc connect
Sage, Wednesday, November 06, 2002, 3:31:21 PM, you wrote: S> I'm running MySQL 3.23.49 on Red Hat 7.3, with the latest kernel S> (2.4.18-17.7.x) installed. It is running in smp mode on a dual P3 1.0 S> gHz. S> MySQL works perfectly fine when connecting from the localhost. However, S> I have another machine that needs to connect via ODBC. The ODBC client S> can connect, but as soon as it does, the connection is suddenly closed. S> The same thing happens if I try to telnet to port 3306 on the host S> machine. S> Every time this happens, I find the following entry in mysqld.log: S> Number of processes running now: 1 S> mysqld process hanging, pid 906 - killed S> 021106 15:51:41 mysqld restarted S> /usr/libexec/mysqld: ready for connections S> I have no idea what is causing this. Does anyone have any suggestions as S> to what might be the cause, or at least what I should double-check? Your problem is described here: https://bugzilla.redhat.com/bugzilla/show_bug.cgi?id=75128 You can downgrade glibc or install the patched one or install MySQL server v3.23.53a -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Host not allowed to connect problem
Timothy, Thursday, November 07, 2002, 11:42:13 AM, you wrote: TV> I am having a problem with Mysql 3.23.39 for solaris 2.6. I can do TV> anything from the console command line but any connections from any TV> other hosts causes a host "xxx.xxx.xxx.xxx" not allowed to connect to TV> this mysql server. I have updated the host table to include a % for all TV> hosts. You need to update table 'user' to allow user connect to from any host. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Mysql dump error
Dan, Thursday, November 07, 2002, 9:11:10 AM, you wrote: DR> mysqldump: Got error: 1030: Got error 127 from table handler when retrieving DR> data DR> from server DR> for some reason i get this when i dump all databases DR> using mysqldump -p --all-databases --add-drop-table --quote-names > DR> all_databases.sql Error 127 means that record file is crashed. Repair table with myisamchk or REPAIR TABLE: http://www.mysql.com/doc/en/Repair.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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
re: Re: Is installation of MySQL C drive fixation?
Oluwagbamila, Thursday, November 07, 2002, 10:04:10 AM, you wrote: OO> No big deal. You can install MySQL in any directory or drive. OO> You just have to set path of your installation in the mySQL conf file. OO> Under MySQL Server Section -- Location, you point the directory to where the OO> Db is installed. OO> e.g. OO> # location OO> basedir = D:\database\mysql\ Right, and don't forget to set up location for the data dir, too. -- 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php