Big problem with autoincrementing
Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. Can you explain me why I have this problem? Thanks Fandango _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Privilege question
Hi MySQL Fans ;-); I saw in the online manual http://www.mysql.com/doc/en/SET_OPTION.html http://www.mysql.com/doc/en/Privileges.html A SUPER PRIVILEGE mentioned. How does it differ from the GRANT privilege ? I would appreciate if anybody could point me to some more detailed infomation of each privilege . I have seen some description already f.e with mysql SHOW PRIVILEGES; -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
reinstall mysql
I would like to remove old mysql ,and install it again. I remove the old directory,Then I tryed to install it again .When I reach step make it give this error. [EMAIL PROTECTED] mysql-standard-4.0.13-pc-linux-i686]# make distclean make: *** No rule to make target `distclean'. Stop. My Question. 1.How can I remove old mysql. 2.I need clear steps to install it again. Regard Saad al-Hajeri _ Get an email address your friends will never forget... FREE! Become [EMAIL PROTECTED] at http://www.emailaccount.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql replication with 2 masters and 1 slave
Is it possible for slave to connect to 2 different masters and have synchronized database from both? Planning to have one backup mysql backup server that's has to synchronize/backup 2 master server. Followed the manual and got master / slave up and running without problem. Can I use something else the CHANGE MASTER TO MASTER_HOST= ADD MASER or something? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: reinstall mysql
Please specify OS, and previous install type (package, rpm, dist, compiled, etc.) And by the way, when/why you do make distclean during the new install? Lian -Original Message- From: saad al-hajeri [mailto:[EMAIL PROTECTED] Sent: Sunday, June 22, 2003 11:34 AM To: [EMAIL PROTECTED] Subject: reinstall mysql I would like to remove old mysql ,and install it again. I remove the old directory,Then I tryed to install it again .When I reach step make it give this error. [EMAIL PROTECTED] mysql-standard-4.0.13-pc-linux-i686]# make distclean make: *** No rule to make target `distclean'. Stop. My Question. 1.How can I remove old mysql. 2.I need clear steps to install it again. Regard Saad al-Hajeri _ Get an email address your friends will never forget... FREE! Become [EMAIL PROTECTED] at http://www.emailaccount.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Textfile to a 2 column mysql database
Hi there, I have a textfile that I want to get inserted into a database. The textfile consists of Questions and Answers. 1st line is a question. 2nd line of the textfile is the answer. And so on... What is the best way to import these lines into the database with 2 columns. 1 column for the questions and one for the answers? Thx! Unox -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql replication with 2 masters and 1 slave
Erik Olsen wrote: Is it possible for slave to connect to 2 different masters and have synchronized database from both? So you would have updates on 2 masters M1 and M2 which would be replicated to the read-only slave S1 ? The point of MySQL's replication is that after an replication-event there is allways a moment in time where slave == master. In your model you'd build : M1 -- S -- M2 An update of M1 would be carried to S but wouldn't be transferred to M2 so S had no chance to get in the state S == M2 anymore. I suppose that'd break the replication process and it'd stop. You have to do it in a circle as the manual describes : ... -- M1 -- M2 -- M3 -- M1 ... I'd rather have it like a star formation but that seams to be impossible, too. Updates on all machines with replication to a central supermaster SM M1 -- SM -- M2 This way I wouldn't rely on all hosts in the replication-circle to stay up and do their job since one is off site and hanging on a slow dial-up line. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Mysql replication with 2 masters and 1 slave
Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised db of both servers db. The plan was to have it on a different place in case of fire. But I must find another solution then. Erik Olsen wrote: Is it possible for slave to connect to 2 different masters and have synchronized database from both? So you would have updates on 2 masters M1 and M2 which would be replicated to the read-only slave S1 ? The point of MySQL's replication is that after an replication-event there is allways a moment in time where slave == master. In your model you'd build : M1 -- S -- M2 An update of M1 would be carried to S but wouldn't be transferred to M2 so S had no chance to get in the state S == M2 anymore. I suppose that'd break the replication process and it'd stop. You have to do it in a circle as the manual describes : ... -- M1 -- M2 -- M3 -- M1 ... I'd rather have it like a star formation but that seams to be impossible, too. Updates on all machines with replication to a central supermaster SM M1 -- SM -- M2 This way I wouldn't rely on all hosts in the replication-circle to stay up and do their job since one is off site and hanging on a slow dial-up line. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big problem with autoincrementing
Hi First, auto increment is a column type. You set the column to add one to the highest value in that column. If you would like the records to start at 10, either enter you first record with the Client_ID value explicitly set at 10 or enter a dummy MySQL statement like INSERT INTO Clients Client_ID VALUES (9) then the next Full_Name you enter, the Client_ID will be automatically set at 10, then next 11 and so on. Mike - Original Message - From: Fandango del Morro [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: June 22, 2003 3:35 AM Subject: Big problem with autoincrementing Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. Can you explain me why I have this problem? Thanks Fandango _ The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
function question
Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Thanx for the info Anthony -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: basic 4.0.13 setup on RH9.0
At 12:47 -0500 6/20/03, Kevin H. Phillips wrote: I had MySQL 3.23.56 on my RedHat machine but developed some problems (that were probably my own fault) so I decided to upgrade to 4.0. I downloaded the source rpm and rebuilt it on my system (running a fully updated RedHat 9.0). I removed the old mysql by doing rpm -e on the components; then I installed 4.0.13-2 by doing rpm -ivh on the binaries. I have copied the my-large.cnf.sh (I think that was it) from the support-files folder to /etc/my.cnf. Now when I try to set the root password, or other things, I get this message: Unknown suffix '@' used for variable 'port' (value '@MYSQL_TCP_PORT@') mysqladmin: Error while setting value '@MYSQL_TCP_PORT@' to 'port' The problem here is that you used my-large.cnf.sh, rather than my-large.cnf. The former is the source from which the latter is built by making the appropriate substitutions to the @xxx@ sequences. You want to use my-large.cnf instead. I noticed that several of the options apparently need to have values filled in. Where can I find some good documentation on how to set up the new version? Is the O'Reilly book a good resource? I had been using one of the Red Hat Linux Bible books and also MySQL Bible by Steve Suehring. Is there something more current that I could get? Yes. :-) You may e-mail me directly if you wish: [EMAIL PROTECTED] (or, if you have problems, [EMAIL PROTECTED]) Thanks, Kevin -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big problem with autoincrementing
At 7:35 + 6/22/03, Fandango del Morro wrote: Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. I know of no documentation that states you should use the option in the way you show above. To set the initial AUTO_INCREMENT value, you use an AUTO_INCREMENT option *following* the closing parenthesis that ends the column definitions in the CREATE TABLE statement. Try this instead: CREATE TABLE Clients ( Client_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Full_Name VARCHAR(30) ) AUTO_INCREMENT = 10; You can put that all on one line if you like. I put it on multiple lines to make it clearer where the table option at the end goes. Can you explain me why I have this problem? Thanks Fandango -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
char
I just created a table with some char columns (I am using Control Center). Every time I save the table (during the design process) my char fields are reset to varchar. Does anybody know why? Ron _ Add photos to your e-mail with MSN 8. Get 2 months FREE*. http://join.msn.com/?page=features/featuredemail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: function question
At 18:23 +0200 6/22/03, Anthony W. wrote: Hi, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Cookies don't delete themselves after expiring. Something (e.g., a browser) notices that they've reached their expiration time and deletes them. Rows don't automatically expire in MySQL. You run a query to identify expired rows and delete them. Depending on your operating system, you might be able to schedule a job that runs periodically to perform this task, which is in most respects what you appear to want. For example, on Unix you can schedule a cron job. Thanx for the info Anthony -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: char
At 9:40 -0700 6/22/03, Namor Taror wrote: I just created a table with some char columns (I am using Control Center). Every time I save the table (during the design process) my char fields are reset to varchar. Does anybody know why? We can make a guess. But you need to show the table structure you're using before we know whether our explanation applies in your case. Ron -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Mysql replication with 2 masters and 1 slave
May be I am misunderstanding your goals but it seems that you want to have a backup server for two independant masters (with different databases). Something like: M1 -- S -- M2 DB1DB1 DB2 DB2 If this is the case, you can run two mysqld instances on S, each one replicating from one master: M1 -- S1 DB1DB1 S2 -- M2 DB2 DB2 Hope this helps Joseph Bueno Erik Olsen wrote: Yes. The idea was to backup 2 masters, 1 that is ours and 1 that is a costumer. The slave's job is just going to have a synchronised db of both servers db. The plan was to have it on a different place in case of fire. But I must find another solution then. Erik Olsen wrote: Is it possible for slave to connect to 2 different masters and have synchronized database from both? So you would have updates on 2 masters M1 and M2 which would be replicated to the read-only slave S1 ? The point of MySQL's replication is that after an replication-event there is allways a moment in time where slave == master. In your model you'd build : M1 -- S -- M2 An update of M1 would be carried to S but wouldn't be transferred to M2 so S had no chance to get in the state S == M2 anymore. I suppose that'd break the replication process and it'd stop. You have to do it in a circle as the manual describes : ... -- M1 -- M2 -- M3 -- M1 ... I'd rather have it like a star formation but that seams to be impossible, too. Updates on all machines with replication to a central supermaster SM M1 -- SM -- M2 This way I wouldn't rely on all hosts in the replication-circle to stay up and do their job since one is off site and hanging on a slow dial-up line. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: basic 4.0.13 setup on RH9.0
Thanks for the notes. I have gotten the correct my.cnf file in place now. Now when I try to put in the password for the root user I get this: $ mysqladmin -u root password 'mypassword' mysqladmin: unable to change password; error: 'Access denied for user: '@localhost' to database 'mysql'' (I notice that there is an extra apostrophe at the end of mysql) What book or manual should I get? Thanks very much, Kevin Paul DuBois wrote: Is there something more current that I could get? Yes. :-) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
need help with subselect workaround
This is a reprise of a question I asked some months ago. Bruce Feist and Tore Bostrup gave me some untested code to try. I've only now been able to try it, and it's not quite working right. Here's a recap of the problem I'm trying to solve: My Web host is running MySQL 3.23, which doesn't support subselects. I have a Web site that displays a list of programs for sale (shareware). The list displays the authors' names. In some cases, more than one author works on a program. In this case, I want to display the name of the lead author. I define this programmatically as the author who earns the highest royalty rate. I have tables like this: royalties table (primary key is a combination of AuthorID and UtilityID): AuthorIDUtilityIDRoyalty -- Author1 Utility1 0.15 Author2 Utility1 0.10 Author3 Utility2 0.25 Author4 Utility3 0.05 Author5 Utility3 0.20 authors table: AuthorIDFirstNameLastName Author1 Joe Smith Author2 BrianJones Author3 Jeff Tucker Author4 MichaelMoore Author5 MarkMann utilities table: UtilityIDProgramName Utility1 ProgName1 Utility2 ProgName2 Utility3 ProgName3 This is my SQL code: DROP TABLE IF EXISTS ProgramRoyalties; CREATE TEMPORARY TABLE ProgramRoyalties SELECT AuthorID, UtilityID, Royalty, max(Royalty) as MaxRoyalty FROM royalties WHERE Royalty = MaxRoyalty GROUP BY UtilityID; Unfortunately, the above produces a table with nothing in it. If I take out the WHERE clause, I get one line per group (per utility), but the author isn't necessarily the one with the highest royalty rate. It seems like the first author in the list is being selected. The SELECT statement for using the above table (once it's properly populated) is: SELECT u.UtilityID, u.UtilityIcon, u.UtilityName, u.Version, u.ShortDescription, u.MinorReleaseDate, a.LastName, pr.UtilityID, pr.AuthorID FROM utilities u, authors a, ProgramRoyalties pr $WhereClause u.UtilityID = pr.UtilityID AND a.AuthorID = pr.AuthorID; How do I get the correct data into the temporary table?? Using the above sample data, I'd want it to look like this: ProgramRoyalties table (primary key is a combination of AuthorID and UtilityID): AuthorIDUtilityIDRoyalty -- Author1 Utility1 0.15 Author3 Utility2 0.25 Author5 Utility3 0.20 Thanks in advance for your help. Sheryl Canter Permutations Software www.permutations.com
basic local mysql config help
Hi I'm trying to setup a site on my local linux. What is a good database creation gui similar to ACCESS? Currently I use access to make my db then an app called access2mysql that makes a .sql file out of it. Usually it works fine but it crashes on my latest db structure. On my server which I am bad for using KDE on I'd like my steve user to be able to drag and drop files to /var/www/html How should permissions be set? What are the commands to check if the servers are running- mysql apache because when I try to connect it claims a standard mysql command is unknown. Thanks, Steve http://www.handheldspecs.com --- Paul DuBois [EMAIL PROTECTED] wrote: At 9:40 -0700 6/22/03, Namor Taror wrote: I just created a table with some char columns (I am using Control Center). Every time I save the table (during the design process) my char fields are reset to varchar. Does anybody know why? We can make a guess. But you need to show the table structure you're using before we know whether our explanation applies in your case. Ron -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
How to run install for mysql
Hi all - I'm trying to set up mysql on my Windows 2000 machine, but can't figure out how to run mysql_install_db I'm going to command prompt, starting the server, then typing in the command but nothing is happening. Do I have the syntax wrong? Also, I notice that there is no install file in my mysql\bin on my hard drive. Could it be that I didn't download it correctly? I have been able to run mysqladmin with no problem - but i am getting access denied errors when I attempt to access databases on my hard drive - that's why I'm assuming that I haven't run the install script correctly. Any help greatly appreciated! Regards, Kirsten Kirsten Belkhiria Solutions Manager Technik IT Web Development and Networking -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Big problem with autoincrementing
I believe you got the autoincrement = 10 from Oracle? It doesn't work here -Mensaje original- De: Paul DuBois [mailto:[EMAIL PROTECTED] Enviado el: Domingo, 22 de Junio de 2003 11:37 a.m. Para: Fandango del Morro; [EMAIL PROTECTED] Asunto: Re: Big problem with autoincrementing At 7:35 + 6/22/03, Fandango del Morro wrote: Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. I know of no documentation that states you should use the option in the way you show above. To set the initial AUTO_INCREMENT value, you use an AUTO_INCREMENT option *following* the closing parenthesis that ends the column definitions in the CREATE TABLE statement. Try this instead: CREATE TABLE Clients ( Client_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Full_Name VARCHAR(30) ) AUTO_INCREMENT = 10; You can put that all on one line if you like. I put it on multiple lines to make it clearer where the table option at the end goes. Can you explain me why I have this problem? Thanks Fandango -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: need help with subselect workaround
I got it to work, if anyone's interested (see message below). Here is the SQL: DROP TABLE IF EXISTS ProgramRoyalties; CREATE TEMPORARY TABLE ProgramRoyalties SELECT UtilityID, max(Royalty) as MaxRoyalty FROM royalties GROUP BY UtilityID; SELECT u.UtilityID, u.UtilityIcon, u.UtilityName, u.Version, u.ShortDescription, u.MinorReleaseDate, a.LastName, r.UtilityID, r.AuthorID, r.Royalty, pr.UtilityID, pr.MaxRoyalty FROM utilities u, authors a, royalties r, ProgramRoyalties pr WHERE u.UtilityID = r.UtilityID AND r.UtilityID = pr.UtilityID AND a.AuthorID = r.AuthorID AND r.Royalty = pr.MaxRoyalty; What I didn't understand was that the temporary table is simply a look-up table for the max royalty for each utility. I use this in the WHERE clause of the SELECT statement. Sheryl Canter Permutations Software www.permutations.com - Original Message - From: Sheryl Canter [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 2:46 PM Subject: need help with subselect workaround This is a reprise of a question I asked some months ago. Bruce Feist and Tore Bostrup gave me some untested code to try. I've only now been able to try it, and it's not quite working right. Here's a recap of the problem I'm trying to solve: My Web host is running MySQL 3.23, which doesn't support subselects. I have a Web site that displays a list of programs for sale (shareware). The list displays the authors' names. In some cases, more than one author works on a program. In this case, I want to display the name of the lead author. I define this programmatically as the author who earns the highest royalty rate. I have tables like this: royalties table (primary key is a combination of AuthorID and UtilityID): AuthorIDUtilityIDRoyalty -- Author1 Utility1 0.15 Author2 Utility1 0.10 Author3 Utility2 0.25 Author4 Utility3 0.05 Author5 Utility3 0.20 authors table: AuthorIDFirstNameLastName Author1 Joe Smith Author2 BrianJones Author3 Jeff Tucker Author4 MichaelMoore Author5 MarkMann utilities table: UtilityIDProgramName Utility1 ProgName1 Utility2 ProgName2 Utility3 ProgName3 This is my SQL code: DROP TABLE IF EXISTS ProgramRoyalties; CREATE TEMPORARY TABLE ProgramRoyalties SELECT AuthorID, UtilityID, Royalty, max(Royalty) as MaxRoyalty FROM royalties WHERE Royalty = MaxRoyalty GROUP BY UtilityID; Unfortunately, the above produces a table with nothing in it. If I take out the WHERE clause, I get one line per group (per utility), but the author isn't necessarily the one with the highest royalty rate. It seems like the first author in the list is being selected. The SELECT statement for using the above table (once it's properly populated) is: SELECT u.UtilityID, u.UtilityIcon, u.UtilityName, u.Version, u.ShortDescription, u.MinorReleaseDate, a.LastName, pr.UtilityID, pr.AuthorID FROM utilities u, authors a, ProgramRoyalties pr $WhereClause u.UtilityID = pr.UtilityID AND a.AuthorID = pr.AuthorID; How do I get the correct data into the temporary table?? Using the above sample data, I'd want it to look like this: ProgramRoyalties table (primary key is a combination of AuthorID and UtilityID): AuthorIDUtilityIDRoyalty -- Author1 Utility1 0.15 Author3 Utility2 0.25 Author5 Utility3 0.20 Thanks in advance for your help. Sheryl Canter Permutations Software www.permutations.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
XML in MySQL
Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? -- Joel Amoussou XML Instructor IBM XML Certification Practice Test http://www.xmlmentor.net/xmlexamsim.htm - Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month!
Re: XML in MySQL
On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
but see SOAP and WSDL support add ons which are freely available and probably what you want anyway -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Joel Amoussou [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 4:56 PM Subject: Re: XML in MySQL On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: but see SOAP and WSDL support add ons which are freely available and probably what you want anyway I don't buy that. If you've really looked at what Oracle is offering, it's hard to argue that the MySQL addons really solve the same problems. Have you seen otherwise? Maybe the addons are quite a bit better than last time I looked? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: How to run install for mysql
At 14:33 +0700 6/22/03, Technik IT wrote: Hi all - I'm trying to set up mysql on my Windows 2000 machine, but can't figure out how to run mysql_install_db On Windows, this program does not exist because it's unnecessary. It's used on Unix to initialize the data directory and the mysql database, but the data directory is included preinitialized in WIndows binary distributions. I'm going to command prompt, starting the server, then typing in the command but nothing is happening. Do I have the syntax wrong? Also, I notice that there is no install file in my mysql\bin on my hard drive. Could it be that I didn't download it correctly? I have been able to run mysqladmin with no problem - but i am getting access denied errors when I attempt to access databases on my hard drive That's odd. Are you trying to access your databases using the mysql client? Show us your mysqladmin and mysql commands. - that's why I'm assuming that I haven't run the install script correctly. Any help greatly appreciated! Regards, Kirsten Kirsten Belkhiria Solutions Manager Technik IT Web Development and Networking -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big problem with autoincrementing
Yes, it works like that. I believe this is the MySql specific syntax, because we can put the auto_increment anywere in other mysql systems. Are you the Paul Dubois who wrote MySql and Perl for the Web? I purchased that book, but before reading it I'm learning the basics of MySql. Also, if you are the author of this book, notice that the link hcp://www.kitebird.com/mysql-perl/ no longer works. What is the new web site compagnon for the book? Thanks Fandango From: Paul DuBois [EMAIL PROTECTED] To: Fandango del Morro [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: Big problem with autoincrementing Date: Sun, 22 Jun 2003 11:37:11 -0500 At 7:35 + 6/22/03, Fandango del Morro wrote: Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. I know of no documentation that states you should use the option in the way you show above. To set the initial AUTO_INCREMENT value, you use an AUTO_INCREMENT option *following* the closing parenthesis that ends the column definitions in the CREATE TABLE statement. Try this instead: CREATE TABLE Clients ( Client_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Full_Name VARCHAR(30) ) AUTO_INCREMENT = 10; You can put that all on one line if you like. I put it on multiple lines to make it clearer where the table option at the end goes. Can you explain me why I have this problem? Thanks Fandango -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ _ Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Big problem with autoincrementing
At 21:13 + 6/22/03, Fandango del Morro wrote: Yes, it works like that. I believe this is the MySql specific syntax, because we can put the auto_increment anywere in other mysql systems. I don't understand what you mean here. Are you the Paul Dubois who wrote MySql and Perl for the Web? I purchased that book, but before reading it I'm learning the basics of MySql. Also, if you are the author of this book, notice that the link Yes, I'm the author. hcp://www.kitebird.com/mysql-perl/ no longer works. What is the new web site compagnon for the book? I don't know what hcp is. Is that a typo? http://www.kitebird.com/mysql-perl/ is still the companion site, and it still works. Thanks Fandango From: Paul DuBois [EMAIL PROTECTED] To: Fandango del Morro [EMAIL PROTECTED],[EMAIL PROTECTED] Subject: Re: Big problem with autoincrementing Date: Sun, 22 Jun 2003 11:37:11 -0500 At 7:35 + 6/22/03, Fandango del Morro wrote: Hello, I'm new in this list and I also a newbie with MySql. I have a big problem with autoincrementing with an initial value. For example: use Database Business; create Table Clients(Client_ID int not null primary key auto_increment=10, Full_Name varchar(30)); Each time I assign an initial value to auto_increment I get an error and worse, the MySql server only tell me there is an error, it doesn't tell me what kind of error is. I tried at leat 30 times before writing this message. I really unable to solve this problem. auto_increment=n is an accepted syntax and it is documented in all sql books. I know of no documentation that states you should use the option in the way you show above. To set the initial AUTO_INCREMENT value, you use an AUTO_INCREMENT option *following* the closing parenthesis that ends the column definitions in the CREATE TABLE statement. Try this instead: CREATE TABLE Clients ( Client_ID INT NOT NULL AUTO_INCREMENT PRIMARY KEY, Full_Name VARCHAR(30) ) AUTO_INCREMENT = 10; You can put that all on one line if you like. I put it on multiple lines to make it clearer where the table option at the end goes. Can you explain me why I have this problem? Thanks Fandango -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- Paul DuBois, Senior Technical Writer Madison, Wisconsin, USA MySQL AB, www.mysql.com Are you MySQL certified? http://www.mysql.com/certification/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: chad pratt [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 5:04 PM Subject: Re: XML in MySQL On Sun, Jun 29, 2003 at 07:53:00PM -0400, chad pratt wrote: but see SOAP and WSDL support add ons which are freely available and probably what you want anyway I don't buy that. If you've really looked at what Oracle is offering, it's hard to argue that the MySQL addons really solve the same problems. Have you seen otherwise? Maybe the addons are quite a bit better than last time I looked? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,598,219 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: XML in MySQL
geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Monday, June 23, 2003 7:55 AM To: chad pratt Cc: [EMAIL PROTECTED] Subject: Re: XML in MySQL On Sun, Jun 29, 2003 at 08:18:24PM -0400, chad pratt wrote: PHP-SOAP, PEAR SOAP, NuSOAP need more SOAP? SOAP is one thing. But what about storing XML documents in the DB (with validation on the way in) and querying them using XPath? Oracle does that. MySQL does not. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,269,579 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
On Mon, Jun 23, 2003 at 07:58:51AM +1000, electroteque wrote: geez mysql is an open source product you cannot expect so much too soon over a very expensive commercial product which has been out for years , for xml i usually generate it on the fly when i am extracting the data using the field names as the xml tag nodes. This has nothing to do with my expectations and everything to do with answering Joel Amoussou's question(s). As a long-time MySQL and open source software user, I'm well aware of the development differences between OS and commercial software. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 620,460,949 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: XML in MySQL
well you probably want to import and export XML into tables.. is this what you want to do? IF you want to process it qua XML as opposed to TEXT or BLOB then it 's not that hard, right? You have data in XML that needs to be put in columns and visa-versaI am not *certain* what you're looking for...here's a resource for you- http://www.xmlphp.com/ I am sure there are probably others books and packages out there.. that';s why God gave you Google.. -C - Original Message - From: chad pratt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Sunday, June 29, 2003 7:53 PM Subject: Re: XML in MySQL but see SOAP and WSDL support add ons which are freely available and probably what you want anyway -C - Original Message - From: Jeremy Zawodny [EMAIL PROTECTED] To: Joel Amoussou [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Sunday, June 22, 2003 4:56 PM Subject: Re: XML in MySQL On Sun, Jun 22, 2003 at 01:30:15PM -0700, Joel Amoussou wrote: Hello, What is the level of support for XML in MySQL. Is there any kit similar to the Oracle XML Developper Kit or the XML features in SQL Server 2000? No. MySQL doesn't nativel deal with XML. -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 619,490,390 queries (366/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Problem with getImportedKeys: Solution?
OK, A few days ago I reported a problem with getImportedKeys, since nobody came with a solution that would work, I did some research, downloaded the code for the driver (I actually downloaded the code for Alpha, since I wanted to report the bug, if there was one as accurately as possible). As far as I can tell, it is a bug. I hope one of the developers is reading this list and can respond directly as to how to proceed with this, or if anyone knows where to post this, please let me know. In line 4926 of DatabaseMetaData.java, the code is looking for a line starting with FOREIGN KEY. The problem seems to be that the version of mysql I have (mysql --version gives me 'mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)') Returns the following when you do a show create table: mysql show Create Table Template CREATE TABLE `Template` ( `template_ID` int(11) NOT NULL auto_increment, `foreign_Key_ID` int(11) NOT NULL default '0', `string_Field` varchar(255) default NULL, `date_Field` timestamp(14) NOT NULL, `boolean_Field` tinyint(4) default NULL, `double_Field` double default NULL, `decimal_Field` decimal(10,0) default NULL, PRIMARY KEY (`template_ID`), KEY `fkid_ind` (`foreign_Key_ID`), CONSTRAINT `0_45` FOREIGN KEY (`foreign_Key_ID`) REFERENCES `ForeignTable` (`foreign_ID`) ) TYPE=InnoDB If you pay a little attention, the line with the foreign key happens to have the name of the constraint as well as the word FOREIGN KEY. This of course, breaks the algorithm. Perhaps something along the lines of line.substring may work better than line.startsWith? Thank you very much! Roberto Leibman P.S. Here are the versions of software I use mysql: mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) java: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06) Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode) mysql connector: mysql-connector-java-3.1.0-alpha-bin.jar signature.asc Description: This is a digitally signed message part
recommend access like db field creator for linux?
I'd like to no access Access anymore and create .sql files without typing varchar(x) :) Any ideas? __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Problem with getImportedKeys: Solution?
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Roberto Leibman wrote: OK, A few days ago I reported a problem with getImportedKeys, since nobody came with a solution that would work, I did some research, downloaded the code for the driver (I actually downloaded the code for Alpha, since I wanted to report the bug, if there was one as accurately as possible). As far as I can tell, it is a bug. I hope one of the developers is reading this list and can respond directly as to how to proceed with this, or if anyone knows where to post this, please let me know. In line 4926 of DatabaseMetaData.java, the code is looking for a line starting with FOREIGN KEY. The problem seems to be that the version of mysql I have (mysql --version gives me 'mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686)') Returns the following when you do a show create table: mysql show Create Table Template CREATE TABLE `Template` ( `template_ID` int(11) NOT NULL auto_increment, `foreign_Key_ID` int(11) NOT NULL default '0', `string_Field` varchar(255) default NULL, `date_Field` timestamp(14) NOT NULL, `boolean_Field` tinyint(4) default NULL, `double_Field` double default NULL, `decimal_Field` decimal(10,0) default NULL, PRIMARY KEY (`template_ID`), KEY `fkid_ind` (`foreign_Key_ID`), CONSTRAINT `0_45` FOREIGN KEY (`foreign_Key_ID`) REFERENCES `ForeignTable` (`foreign_ID`) ) TYPE=InnoDB If you pay a little attention, the line with the foreign key happens to have the name of the constraint as well as the word FOREIGN KEY. This of course, breaks the algorithm. Perhaps something along the lines of line.substring may work better than line.startsWith? Thank you very much! Roberto Leibman P.S. Here are the versions of software I use mysql: mysql Ver 12.20 Distrib 4.0.13, for pc-linux (i686) java: Java(TM) 2 Runtime Environment, Standard Edition (build 1.4.1_02-b06) Java HotSpot(TM) Client VM (build 1.4.1_02-b06, mixed mode) mysql connector: mysql-connector-java-3.1.0-alpha-bin.jar This was fixed last week, and is in the nightly snapshots (http://mmmysql.sourceforge.net/). Sorry that you weren't aware of http://bugs.mysql.com/ where bug reports are taken and closed (maybe we need to start adding it into the tagline for this list). Please check http://bugs.mysql.com/ when reporting bugs to [EMAIL PROTECTED], because it will save you some time if the bug has already been reported (and in this case, fixed and closed :) ) (See http://bugs.mysql.com/bug.php?id=517 and and a duplicate of #517, http://bugs.mysql.com/bug.php?id=664) -Mark - -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, SW Dev. Manager - J2EE/Windows /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.1 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iD8DBQE+9jQGtvXNTca6JD8RAgT8AKCyO9C535hHvTl3gpx/C62A0deshgCfbcVy e2HfcqWPJP/8NN9BSUk3c/w= =AgQ2 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql access error 1044 - update
Hi all - thanks so much for the advice that has been coming in regarding my mysql local installation problems. Here's what's going on - Tim and Paul - I especially appreciated your replies - do you have any ideas on the following: I reinstalled mysql (made sure I downloaded the binary with the installer, per Tim's advice.) But when I ran the command suggested to start up mysqlwinadmin, I wasn't prompted for a master password/login (although everything else seemed to run smoothly). I tried once more to give access to my database by running the following after logging in successfully to the mysql monitor on command line: GRANT all privileges on mydatabase.* to @localhost; and got the following: Error 1044: access denied for [EMAIL PROTECTED] Paul, I hope I'm being specific enough on the code and error messages - it's clear to me that for some reason I'm still unable to set user rights. But without having the option presented to me, I'm unsure how to fix the problem. Again, I am running Windows 2000. Thanks again for any insight! Regards, Kirsten Kirsten Belkhiria Solutions Manager Technik IT Web Development and Networking -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
CREATE TABLE with date as part of table name
I would like to know how to create a table within MySQL at the command prompt where the table name will be something like: MyTableName_TodaysDate Is this possible while at the command prompt? I am trying to create a batch file that will create a table in MySQL based on todays date. The system I am working on at the moment is Win2k. Thanks, Todd Routhier Lightwave Technologies, LLC. -- Start Your Own ISP! http://www.YourOwnISP.com
specified function mysql
Hello, mysql, I'm just wondering is there a function instead of update to overwrite data that has expired?? Or can mysql automatically deletes records or rows that has expires just like cookies delete themselves after expiring. Best regards. MaFai [EMAIL PROTECTED] 2003-06-23 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
APT-GET Help with upgrade to 4.1
Hi I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that has lots and lots of subselects. I hear that 4.1 now supports this (I hope). I used apt-get to install 3.23 so how can I install 4.1 over the top and not get into any trouble is what Im after? Ive tried apt-get install/upgrade mysql-server and it tells me Ive got the latest. Im using Debian 3.0 Woody. Frederic Lecul Technical Services Institutional and Business Services (IBS-IT) Commonwealth Bank of Australia Ph: (61-2) 9378 5328 Fax: (61-2) 9378 5202 ** IMPORTANT MESSAGE ** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: APT-GET Help with upgrade to 4.1
On Mon, Jun 23, 2003 at 12:00:56PM +1000, Lecul, Fred wrote: Hi I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that has lots and lots of subselects. I hear that 4.1 now supports this (I hope). It does, but they're not as optimized as they could be yet. I used apt-get to install 3.23 so how can I install 4.1 over the top and not get into any trouble is what Im after? Ive tried apt-get install/upgrade mysql-server and it tells me Ive got the latest. Im using Debian 3.0 Woody. Well, Debian stable has 3.23. Testing/Unstable have 4.0.12. 4.1.0 only exists in alpha form. To my knowledge nobody has build Debian packages for it yet. You'll need to uninstall your current MySQL and build 4.1 from source if you're sure you want to use it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 625,913,404 queries (365/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: APT-GET Help with upgrade to 4.1
Lecul, Fred wrote: Hi I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that has lots and lots of subselects. I hear that 4.1 now supports this (I hope). I used apt-get to install 3.23 so how can I install 4.1 over the top and not get into any trouble is what Im after? Ive tried apt-get install/upgrade mysql-server and it tells me Ive got the latest. Im using Debian 3.0 Woody. Frederic Lecul Technical Services Institutional and Business Services (IBS-IT) Commonwealth Bank of Australia Ph: (61-2) 9378 5328 Fax: (61-2) 9378 5202 I would be (very) surprised if someone made a debian package for MySQL-4.1. As you noticed, they don't even have one for MySQL-4.0 yet. If you want to use 4.1 (and I would recommend against it currently - for starters, there are issues with connecting from older clients) then you will have to uninstall the old MySQL (I don't know how you do that on Debian) and compile the new 4.1 from source. There are very good instructions for how to do this included in the source. I'm waiting for _at least_ another 4.1.x release before trying it out. I'll probably also wait for a few releases of MyODBC-3.52 - which currently has not been released yet. By the way, what do the Commonwealth Bank use MySQL for? (just curious) -- Daniel Kasak IT Developer * NUS Consulting Group* Level 18, 168 Walker Street North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: www.nusconsulting.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: APT-GET Help with upgrade to 4.1
Thanks for your help! I might wait or look elsewhere -Original Message- From: Jeremy Zawodny [mailto:[EMAIL PROTECTED] Sent: Monday, 23 June 2003 12:16 PM To: Lecul, Fred Cc: '[EMAIL PROTECTED]' Subject: Re: APT-GET Help with upgrade to 4.1 On Mon, Jun 23, 2003 at 12:00:56PM +1000, Lecul, Fred wrote: Hi I want to upgrade my mysql 3.23 to 4.1 as I want to convert a mssql app that has lots and lots of subselects. I hear that 4.1 now supports this (I hope). It does, but they're not as optimized as they could be yet. I used apt-get to install 3.23 so how can I install 4.1 over the top and not get into any trouble is what Im after? Ive tried apt-get install/upgrade mysql-server and it tells me Ive got the latest. Im using Debian 3.0 Woody. Well, Debian stable has 3.23. Testing/Unstable have 4.0.12. 4.1.0 only exists in alpha form. To my knowledge nobody has build Debian packages for it yet. You'll need to uninstall your current MySQL and build 4.1 from source if you're sure you want to use it. Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! [EMAIL PROTECTED] | http://jeremy.zawodny.com/ MySQL 4.0.13: up 19 days, processed 625,913,404 queries (365/sec. avg) ** IMPORTANT MESSAGE ** This e-mail message is intended only for the addressee(s) and contains information which may be confidential. If you are not the intended recipient please advise the sender by return email, do not use or disclose the contents, and delete the message and any attachments from your system. Unless specifically indicated, this email does not constitute formal advice or commitment by the sender or the Commonwealth Bank of Australia (ABN 48 123 123 124) or its subsidiaries. ** -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: recommend access like db field creator for linux?
Try MySQL CC from mysql.com or MySQL Front also seems to be a favorite of people still. There are a few commercial programs as wel that will help you manage mysql as well. Try a google search. keith Steve B. [EMAIL PROTECTED] 06/22/03 06:46PM I'd like to no access Access anymore and create .sql files without typing varchar(x) :) Any ideas? __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]