installing Binaries under /usr/local
Hello, I was wondering if there is distribution or method for me that would allow me to install mysql with a --prefix of /usr/local instead of /usr/local/mysql Normally I would just compile it but I am getting lazy in my old age and this is my first time with 4.x series, so I'll the official binaries this time. Should I just copy all the binaries over to /usr/local/bin and /usr/local/libexec /usr/local/share and be done with it? Moving from 3.23.x to 4.0. Thanks. -- Vincent Stoessel Linux Systems Developer vincent xaymaca.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
JDBC RowSets in Mysql Connector
Hello, I am working on a J2EE app and I really would love to take advantage of jdbc 2.0's RowSet functionality. Is Connector J (2 or 3) compliant with this part of the standard? Thank You sql,query -- Vincent Stoessel Linux Systems Developer vincent xaymaca.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: JDBC RowSets in Mysql Connector
Yeah, I was thinking about doing the scrolling results thing using a pure java solution. I will look into the CachedRowset from Sun, thanks for that info. I still believe the mysql driver is cool. What's up with the docs, though? Mark Matthews wrote: Vincent Stoessel wrote: Hello, I am working on a J2EE app and I really would love to take advantage of jdbc 2.0's RowSet functionality. Is Connector J (2 or 3) compliant with this part of the standard? No. There hasn't been a large demand for support of that API, and it's not required to be JDBC-compliant. What particular feature of a rowset would you be using that isn't in java.sql.ResultSet? There are a lot of third party ones that do work with MySQL. Sun's CachedRowset provider (from java.sun.com) is one. -Mark -- Vincent Stoessel Linux Systems Developer vincent xaymaca.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 with java
Hmm, I have done some java/linux development using mysql and it works fine using the jdbc api. I highly recommend using Mark Mathews' jdbc driver in your java development area. It is licensed under GNU LGPL. http://mmmysql.sourceforge.net/ Be sure to join the mysql-java mailing list for questions to the java/mysql community. Denny wrote: Hi, Is there any examples on developing a java interface with mysql? Thanks, Denny - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Help, any convert(legacy) function? in mysql?
sql,query Thank you very much. One more thing, would 250k be the same as 2500 x -3 ? ie -7500 Thanks again. On Sun, 10 Mar 2002, Roger Baklund wrote: * Vincent Stoessel Hello, I am trying to convert this weird cobol style number into a regular integer. I got it from a fixed length text file. [...] If the value is negative, the right most column will contain a special character: ] = -0, j = -1, k = -2, l = -3, m = -4, n = -5, o = -6, p = -7, q = -8, and r = -9. example numbers: I have 1500 numbers that look like this! the rest are normal integers. Any help would /really/ be appreciated. TIA. 000125] 20] 25] As ] is -0, these numbers should be -1250, -200 and -250... right? What is the problem? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Help, any convert(legacy) function? in mysql?
sql query Hello Folks, Hello, I am trying to convert this weird cobol style number into a regular integer. I got it from a fixed length text file. From the description file: Amount Columns 131-137 Numeric In the fixed width text file, the amounts are in COBOL format. If the value is negative, the right most column will contain a special character: ] = -0, j = -1, k = -2, l = -3, m = -4, n = -5, o = -6, p = -7, q = -8, and r = -9. example numbers: I have 1500 numbers that look like this! the rest are normal integers. Any help would /really/ be appreciated. TIA. 000125] 20] 25] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
a column of names
One thing that has always puzzled me is how poeple are gaurding against duplication in columns where people's names are stored. For example this table has a persons's first and last name. Stars: starID starFirstName starLastName 1 Vanna White 2 Bob Marley problems begin to arise when people begin adding new names to the table. I could make a unique key out of (starFirstName,starLastName) but what happens when someone enters ('Robert','Marley') or ('Vanna','Wihte'). I guess the solution is to force users to do a query for an existing name. Is there a way to do a more fuzzy search than using LIKE ? would soundex or something else be the way to go? -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: 16 char limit on Grant username
Why? Victoria Reznichenko wrote: Vincent, Sunday, February 17, 2002, 9:49:55 PM, you wrote: VS Hello, VS according to the docs: VSFor the moment, GRANT only supports host, table, database, and column names up to 60 VS characters long. VS A user name can be up to 16 characters. VS Is there a way to increase this limitation? VS I want 32-64 character usernames. VS Thanks It's impossible for tables 'user', 'db' in mysql db. -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
joins across table types?
Hello, I have finally decided to start using innodb tables in production enviroments and I noticed that I was able to do a join between a myisam table and a innodb table. Will the ability to do joins across table types always be supported in future versions of mysql? Also is there a standard set of features that all mysql must be able to support that mysql.com developers use internaly? Thanks. -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
joins across table types?
Hello, I have finally decided to start using innodb tables in production enviroments and I noticed that I was able to do a join between a myisam table and a innodb table. Will the ability to do joins across table types always be supported in future versions of mysql? Also is there a standard set of features that all mysql must be able to support that mysql.com developers use internaly? Thanks. -- Vincent Stoessel [EMAIL PROTECTED] Linux and Java Application Developer (301) 362-1750 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: [midgard-user] Re: big problem with mysqldb
I would /strongly/ advise that you discontinue the use of the Isam table type in mysql. The Isam table type is a legacy of the mysql 3.22.x series. If you are using the stable 3.23.x series Myisam is the new default type. One of the cool things about Myisam is that you CAN repair it while the database is running. You can also configure mysqld to repair tables automatically when it finds a problem. Of course you it manually still with myisamchk -r Tarjei Huse wrote: Hi, I would like to thank everyone (esp Carsten and Jocelyn) who helped me solve this problem. It now seems that the db now works ok. For the record, I suggest that isamchk should contain a warning in the help text that you should not run it when mysqld is running. This combined with isamchk -i *.ISM. Also, I'll backup using mysqldump from now on, not just tarballing my dbdirs :) Tarjei Carsten H. Pedersen wrote: isamchk -e -o page.ISM I get: Found block with too small length at 2249; Skipped ... Now what do I do?? Restore from backup? Your table structure is definitely corrupted. What happens if you run isamchk with just -r: isamchk -r page.ISM ? / Carsten -- Carsten H. Pedersen keeper and maintainer of the bitbybit.dk MySQL FAQ http://www.bitbybit.dk/mysqlfaq - To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] -- Vincent Stoessel [EMAIL PROTECTED] Java Linux Apache Mysql Php (JLAMP) Engineer (301) 362-1750 Mobile (410) 419-8588 AIM, MSN: xaymaca2020 , Yahoo Messenger: vks_jamaica - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Problem with mysql 3.23.35 using transaction
An example query and an explanation of what you are trying to do would be helpful. Thanks On Tue, 20 Mar 2001, Brunella del Sorbo wrote: Hi, the version mysql that I am using supports the transactions but these are not recognized from the DBD. How can I resolve the problem? Thanks -- Vincent Stoessel [EMAIL PROTECTED] Internet Applications Engineer IDEV http://www.idev.com V: 301 495 7345 x129 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php