MySQL-Front
Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL-Front
Hello, As they say on the site, it is discontinued. My guess is that there were no active developers. Quite a shame, though, as MySQLFront was simply the best frontend for MySQL. I _really_ hope that someone will pick up the development from where it was left off and continue the development of this excellent frontend. Best regards, Iikka On Sun, 22 Sep 2002, Kevin Smith wrote: Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * 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: MySQL-Front
Hrm, I wouldn't mind taking this over, or at the very least, taking over the website and releasing the current version. I have quite a bit of Windows programming experience as it is so I should be able to make patches etc. where needed. Anyone know where I can find more info? I can host it at Perlboy.org without any dramas. Cheers, Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Sunday, 22 September 2002 7:10 PM To: Kevin Smith Cc: [EMAIL PROTECTED] Subject: Re: MySQL-Front Hello, As they say on the site, it is discontinued. My guess is that there were no active developers. Quite a shame, though, as MySQLFront was simply the best frontend for MySQL. I _really_ hope that someone will pick up the development from where it was left off and continue the development of this excellent frontend. Best regards, Iikka On Sun, 22 Sep 2002, Kevin Smith wrote: Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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-Front
Interesting, http://mysqlfront.sstienemann.de/ Still works. Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Iikka Meriläinen Sent: Sunday, 22 September 2002 7:10 PM To: Kevin Smith Cc: [EMAIL PROTECTED] Subject: Re: MySQL-Front Hello, As they say on the site, it is discontinued. My guess is that there were no active developers. Quite a shame, though, as MySQLFront was simply the best frontend for MySQL. I _really_ hope that someone will pick up the development from where it was left off and continue the development of this excellent frontend. Best regards, Iikka On Sun, 22 Sep 2002, Kevin Smith wrote: Hi All, Does anyone know what happened to the MySQL-Front project, which was at http://www.anse.de/mysqlfront/ ? Thanks, Kevin - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php ** * 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 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Fractions
From: MySQL [EMAIL PROTECTED] From: Madscientist [EMAIL PROTECTED] You might also consider using two integer type fields - one for the numerator and another for the denominator. This way storage and recovery are easy and the mathematics are wide open. _M I suspect that a float add is faster than 3 integer multiplies and sum. Ah, but it is not as accurate! If the original poster knows he needs fractions, he won't be happy with float. Just as one should NEVER use floating point to represent money, one should NEVER use it for representing fractions that need to be precise. For example, (1/3 as a float) * 3 will come out to 0.. -- : Jan Steinman -- nature photography: http://www.Bytesmiths.com : Bytesmiths -- artists' services: http://www.Bytesmiths.com/Services : Join the forums at http://www.Bytesmiths.com/wiki - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Multiple concurrent MySQL question?
I desire to configure MySQL in such a way that it will permit me to have two different PHP/MySQL e-commerce applications running concurrently on my development system. The table names and table structure are the same on both applications(and databases). I have received a SQL backup from the new client and would just like to be able to restore it to a directory and start up another copy of MySQL and point it to the new location. I know that I could create two different databases to accomplish what I desire however, I would have to change all of the security tables for the new database. What are your suggestions to solve this issue? Thank You Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 1146
hi list, trying to do my first steps with mysql, i have done the following : mysql USE mysql; Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql INSERT INTO mysql VALUES(localhost, sample_db, 'Y','Y','Y','Y','Y','Y','Y','Y','Y','Y'); ERROR 1146: Table 'mysql.mysql' doesn't exist hmm - what I have done wrong here ? or do I have to do something before ? these steps are a piece of description in a mysql-book mysql in 21 days and thanks for helping bye hans - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Build errors with 3.23.51
Yes, I now the problem with MySQL, Can anyone send me te solution? Greetings --- B. van Velzen VelzArt Mobile : +31(0)653382221 Mail : [EMAIL PROTECTED] Info : [EMAIL PROTECTED] http://www.velzart.nl === De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. velzart.nl staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan. - Original Message - From: [EMAIL PROTECTED] To: B. van Velzen [VelzArt.nl] [EMAIL PROTECTED] Sent: Sunday, September 22, 2002 3:06 PM Subject: Re: Re: Build errors with 3.23.51 Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to this message, and include the entire text of it in the reply, your reply will go through. However, you should first review the text of the message to make sure it has something to do with MySQL. Just typing the word MySQL once will be sufficient, for example. You have written the following: Yes. I have excaclty the same problem :S can somebody mail me the solution? [EMAIL PROTECTED] Many thanks B. van Velzen - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
TO_DAYS() equivalent for months, hours etc.?
I'm writing a website statistics system and have been using GROUP BY TO_DAYS(time) in the sql to aggregate results for different days, however there doesn't seem to be an equivalent function for other time periods such as hours and months. Will I be able to use: GROUP BY (MONTH(time),YEAR(time)) to achieve this result, or is there a better way? Cheers, Tim. -- Tim Fountain ([EMAIL PROTECTED]) http://www.tfountain.co.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
Duplicate key error
I am aware that this is an error of my own making, however . . . I am unable to install my sql because the scipt fails with a duplicate key error Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables ERROR: 1062 Duplicate entry 'localhost-root' for key 1 ERROR: 1062 Duplicate entry 'localhost-root' for key 1 020922 12:55:57 ./bin/mysqld: Shutdown Complete I have removed the database to the best of my ability, and am unable to find any mysql files of anything containing the text localhost-root. The output however remains the same. I have a mac G4 with os 10.1.5 Can anyone advise me how to proceed? regards Graham Hodges - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Build errors with 3.23.51
Shane Allen wrote: configure:12730: checking style of gethost* routines configure:12773: gcc -c -O -DDBUG_OFF -O3 -felide-constructors -fno-exceptions -fno-rtti -fpermissive -I/usr/local/mysql-glibc-2.2.2/include conftest.cc 5 gcc: installation problem, cannot exec `cc1plus': No such file or directory Configure assumes that gcc can compile .cc file as well. This is bad because gcc can be installed without .cc support, which is in the optional packages gpp and libgpp. I had the same problem with SuSE 7.3 and the unmodified mysql-4.0.3-beta sources using the recommended gcc configure options from the manual. Install packages gpp and libgpp, and all will work fine. Regards Julian - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Multiple concurrent MySQL question?
Paul, You need to run another server on a different port with a different socket path. See http://www.mysql.com/doc/en/Multiple_servers.html And http://www.mysql.com/doc/en/mysqld_multi.html to manage multiple MySQL servers. Cheers, Andrew -Original Message- From: Paul Maine [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 September 2002 12:26 To: MySQL MySQL Subject: Multiple concurrent MySQL question? I desire to configure MySQL in such a way that it will permit me to have two different PHP/MySQL e-commerce applications running concurrently on my development system. The table names and table structure are the same on both applications(and databases). I have received a SQL backup from the new client and would just like to be able to restore it to a directory and start up another copy of MySQL and point it to the new location. I know that I could create two different databases to accomplish what I desire however, I would have to change all of the security tables for the new database. What are your suggestions to solve this issue? Thank You Paul - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: Problem starting mysqld on SCO
did you run the mysql_install_db script to create the mysql database and populate it with the bare values necessary for mysql run? SK On Thursday, September 5, 2002, at 05:57 PM, Darryl Hoar wrote: Greetings, I downloaded the mysql-max-3.23.42-pc-sco3.2v5.0.6-i386 from MySQL website. I installed it per the INSTALL-BINARY readme file. When I try (from /usr/local/mysql) issue: bin/safe_mysqld --user=mysql It starts and immediately stops mysqld. The .err file contains 020904 21:41:45 mysqld started 020904 21:41:45 bdb: /var/opt/K/SCO/Unix/5.0.6Ga/usr/local/mysql-max-3.23.42-pc- sco3.2v5.0.6-i386 /data/log.01: Permission denied 020904 21:41:45 bdb: PANIC: Permission denied 020904 21:41:45 Can't init databases 020904 21:41:45 mysqld ended I have changed the ownership/group as per the instructions and I even went so far as to set the permission on the data directory to 777. Still no joy. Any ideas what step I missed? thanks in advance, Darryl - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail mysql-unsubscribe- [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlbug
After i install the Redhat 7.3 and mysql i cannot connect to the mysql server , it shutdown automatically [root@localhost root]/usr/bin/safe_install [1]2023 [root@localhost root]Starting mysql daemon with databases from /var/lib/mysql 020923 00:36:23 mysqld ended [1]+ Done /usr/bin/safe_install [root@localhost root}# mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(111) _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
first dbi access with perl and lost
Hi!, I am lost! I am running in win 98 and my perl code is: #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost, jwp, x, {'RaiseError' = 1}); $drh = DBI-install_driver(\mysql); I am not sure what is wrong. I get the following error: Global sysmbol $drh requires explicit package name at dbtest.pl line 12 Am I going about the the correct way? I have created the table and added a number if items to the table. I can look at the table with WinMySQL.adminVer 1.4 for Win95/Win98/NT/Win2000. Thanks , Jerry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
Gerald, #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost, jwp, x, {'RaiseError' = 1}); $drh = DBI-install_driver(\mysql); I am not sure what is wrong. I get the following error: Global sysmbol $drh requires explicit package name at dbtest.pl line 12 That's a Perl error. You've told Perl not to allow you to use a variable unless you declare it with: my local our (and possibly other keywords but these are the most common) If you substitute: my $drh= ...then you'll be fine. You might want to find out more information on what the use strict actually does too. A good place would be the perl documentation (perldoc) or http://www.perl.org/ Hope this helps. DSL [mysql,query] -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
David, Thanks, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? Thanks, Jerry David Lloyd wrote: Gerald, #!perl use strict; use DBI(); # Connect to the database. my $dbh = DBI-connect(DBI:mysql:database=club;host=localhost, jwp, x, {'RaiseError' = 1}); $drh = DBI-install_driver(\mysql); I am not sure what is wrong. I get the following error: Global sysmbol $drh requires explicit package name at dbtest.pl line 12 That's a Perl error. You've told Perl not to allow you to use a variable unless you declare it with: my local our (and possibly other keywords but these are the most common) If you substitute: my $drh= ...then you'll be fine. You might want to find out more information on what the use strict actually does too. A good place would be the perl documentation (perldoc) or http://www.perl.org/ Hope this helps. DSL [mysql,query] -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Turn logging on or off for SQL statements
Is there an easy way to turn logging or SQL statement executions on or off without having to restart with a changed my.cnf file? Just want to log queries to try and sort out some performance problems. Thanks, O. (sql) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
What's this error mean?
What's this error mean? Warning: Wrong parameter count for mysql_query() thanks Randy - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: mysqlbug
Hey there, That means that the MySQL server is unable to find the mysql socket. Check your error log for more info. Stuart --- Perlboy.org - Professional Perl Programming Services Carpet-Head.com - Sally's Blog -Original Message- From: Winnie Kwok [mailto:[EMAIL PROTECTED]] Sent: Monday, 23 September 2002 2:38 AM To: [EMAIL PROTECTED] Subject: mysqlbug After i install the Redhat 7.3 and mysql i cannot connect to the mysql server , it shutdown automatically [root@localhost root]/usr/bin/safe_install [1]2023 [root@localhost root]Starting mysql daemon with databases from /var/lib/mysql 020923 00:36:23 mysqld ended [1]+ Done /usr/bin/safe_install [root@localhost root}# mysql -u root mysql ERROR 2002: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'(111) _ Send and receive Hotmail on your mobile device: http://mobile.msn.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
Database Query Question
Hi all, I need to be able to tell what the maximum length of a char column is. Can I query the database for this information? Shaun list filter: 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: Database Query Question
Shaun, The length can be any value between 1 and 255. (As of MySQL Version 3.23, the length of CHAR may be 0 to 255.) See http://www.mysql.com/doc/en/CHAR.html If you're looking to find the maximum length of the values in a particular column, use something like this: In table 'tablename' for column 'columnname'. mysql select max(length(columnname)) from tablename; +-+ | max(length(columnname)) | +-+ | 22 | +-+ Cheers, Andrew -Original Message- From: Shaun Bramley [mailto:[EMAIL PROTECTED]] Sent: Sunday, 22 September 2002 19:14 To: [EMAIL PROTECTED] Subject: Database Query Question Hi all, I need to be able to tell what the maximum length of a char column is. Can I query the database for this information? Shaun list filter: 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: What's this error mean?
On Sun, 22 Sep 2002, Randy Johnson wrote: What's this error mean? Warning: Wrong parameter count for mysql_query() Exactly what it says. You called mysql_query (PHP?) with the wrong number of parameters/arguements. Ie, it might expect 2, and you only gave it 1. -- Sapere aude My mind not only wanders, it sometimes leaves completely. Never attribute to malice that which can be adequately explained by stupidity. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Because it's not part of MySQL. It's part of DBD::mysql, the MySQL-specific driver for the DBI module. Since you say you're not getting anywhere, but do not specify what you've tried, all we can say is follow the directions you've already been given. That is, use ppm to install the DBD::mysql module. Invoke the ppm program, then run this command: install DBD::mysql Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! Jerry Paul DuBois wrote: At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Because it's not part of MySQL. It's part of DBD::mysql, the MySQL-specific driver for the DBI module. Since you say you're not getting anywhere, but do not specify what you've tried, all we can say is follow the directions you've already been given. That is, use ppm to install the DBD::mysql module. Invoke the ppm program, then run this command: install DBD::mysql Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: first dbi access with perl and lost
At 14:24 -0500 9/22/02, Gerald Preston wrote: Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! I take it from your tone that your script works now? :-) DBI (I assume that's what you mean by installing DBD, because there is no DBD module as such) provides the top-level database access mechanism. But it doesn't contain any information about specific databases, so you need to install a driver for each type of database you want to access: DBD::mysql for MySQL, DBD::Pg for PostgreSQL, etc. DBI uses the DBD-level drivers to communicate with specific types of database servers. Jerry Paul DuBois wrote: At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Because it's not part of MySQL. It's part of DBD::mysql, the MySQL-specific driver for the DBI module. Since you say you're not getting anywhere, but do not specify what you've tried, all we can say is follow the directions you've already been given. That is, use ppm to install the DBD::mysql module. Invoke the ppm program, then run this command: install DBD::mysql Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Speaking of DBI -v- Net::MySQL (Was: RE: first dbi access with perl and lost)
Following this conversation myself (also a perl db newbie :) ... before always just used php) and curious if you know definitely what db vendor you are going to be using (mysql in this case), any reason to use dbi; as opposed to just using vendor specific or net::mysql; . Is it just a portability issue? Cheers, -Peter -Original Message- From: Paul DuBois [mailto:[EMAIL PROTECTED]] Sent: Sunday, September 22, 2002 21:35 To: Gerald Preston Cc: David Lloyd; mysql Subject: Re: first dbi access with perl and lost At 14:24 -0500 9/22/02, Gerald Preston wrote: Paul, Thank you!! I had installed DBD, but I did not know that I had to install DBD::mysql. THANKS SO MUCH!!! I take it from your tone that your script works now? :-) DBI (I assume that's what you mean by installing DBD, because there is no DBD module as such) provides the top-level database access mechanism. But it doesn't contain any information about specific databases, so you need to install a driver for each type of database you want to access: DBD::mysql for MySQL, DBD::Pg for PostgreSQL, etc. DBI uses the DBD-level drivers to communicate with specific types of database servers. Jerry Paul DuBois wrote: At 13:33 -0500 9/22/02, Gerald Preston wrote: David, I am not getting any where.. Do I have create mysql.pm on my system or can just copy the file onto my system. I do not understand why MySQL did not create this file. Because it's not part of MySQL. It's part of DBD::mysql, the MySQL-specific driver for the DBI module. Since you say you're not getting anywhere, but do not specify what you've tried, all we can say is follow the directions you've already been given. That is, use ppm to install the DBD::mysql module. Invoke the ppm program, then run this command: install DBD::mysql Thanks, Jerry David Lloyd wrote: Gerald, Now I am getting the following: install_driver(mysql) failed: Can't locate DBD/mysql.pm in @INC contains; C:/Perl/lib C:/Perlsite/lib .) at (eval 1) line 3; I can't mysql.pm on my PC. Was it not generated when I installed MySQL? How do I fix this? No, it's separate from the distribution of MySQL. If you're using ActiveState then start the ppm (Perl Package Manager Utility) and look for: DBD::mysql You'll find it here: * http://theoryx5.uwinnipeg.ca/mod_perl/cpan-search?request=search (Search for DBD::mysql) I don't really know the best way to install Perl modules on Windows (I avoid Windows like the plague). DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Perl and mySQL and character sets.
Hello all, I am currently using perl to import some information into a mysql db. At this point in time I have two issues: 1. The text files that are being imported contain both english and french text. My text editor (textpad) gladly displays the text with all proper hyphens and accentuated characters. Now when I use perl to read the files, the characters that are being displayed are not what I am expecting to see. Apparently perl is reading the file as UTF8?? How do I get it to recognize the file as using the ISO-8859-1 character set?? Now this leads to my second question 2. Does how perl is displaying the text really matter? will it store the 'proper' character or will it store the messed up character? 3. Does mysql by default use the ISO-8859-1 character set? Any help is greatly appreciated. Thanks Shaun - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Performance while Building Indices -- how does it scale?
I have a table with a few million rows, wth 633 columns. I want to create 10 inidices on this table, six single-column and four two-column inidices. The database will be loaded once and remain static, and queried many times. Please note that this is a small prototype for the actual database, which will have 40 times more rows. I used two strategies to create these tables: 1. Create the indices in the create table statement 2. Load the table, and then use the create index statement for each index. With Strategy 1, the loading started nicely using the load data infile command to load approx. 2000 records at a time. It took 3 seconds for each load data infile command. After a few hundred load data infile commands, however, the time increased to two minutes per command. With Strategy 2, the loading went from start to finish at 3 seconds for each load data infile command. But now, creating each index is taking longer. Here is a log: Fri Sep 20 15:17:43 CDT 2002 create index objId on bestTsObj (objId) Fri Sep 20 15:35:51 CDT 2002 create index fieldId on bestTsObj (fieldId) Fri Sep 20 15:56:02 CDT 2002 create index targetObjId on bestTsObj (targetObjId) Fri Sep 20 16:20:02 CDT 2002 create index ra on bestTsObj (ra) Fri Sep 20 16:49:16 CDT 2002 create index decl on bestTsObj (decl) Fri Sep 20 17:53:38 CDT 2002 create index u on bestTsObj (u) Fri Sep 20 18:42:52 CDT 2002 create index g on bestTsObj (g) Fri Sep 20 22:04:25 CDT 2002 create index r on bestTsObj (r) Sat Sep 21 10:06:44 CDT 2002 create index i on bestTsObj (i) Sat Sep 21 19:31:52 CDT 2002 create index z on bestTsObj (z) Sun Sep 22 15:45:06 CDT 2002 create index ug on bestTsObj (u,g) The first index was created in a reasonable amount of time (18 minutes), but it is taking longer to create more indices. With both strategies, no process is swapping heavily, and mysqld is not consuming available CPU cycles efficiently. Can you suggest how I can build multiple indices on large tables efficiently? Will it help to create a narrow table with only the quantities I want to use in indices? We have installed mysql via rpm: bash-2.04$ mysqladmin mysqladmin Ver 8.18 Distrib 3.23.36, for redhat-linux-gnu on i386 bash-2.04$ uname -r 2.4.18-xfs-1.1 bash-2.04$ What diagnostics do you suggest I run? 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: MySQL Gui Install and Setup for Win2K
We were told by David Axmark of MySQL AB to stop using MySQLGui and switch to MyCC. MySQLGUI is apparently dead. - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 16, 2002 12:52 PM Subject: MySQL Gui Install and Setup for Win2K Can some one point me in the direction of some good install and setup Doc for MySQL GUI. Im running the GUI on Win2K, but my DB server is RH7.2 w/ stock Mysql(not sure version number). Also is the FLTK absolutely necessary to run the GUI on Win2K? Any other hints or insights is greatly appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 kylix
I have a copy of Kylix 1.0, which I put on a recent RH 7.3 install. It is running MySQL 3.23.49. I therefore d/l 3.23 driver for kylix. I then did the following: *Copied the driver to the kylix\bin file *Created the symbolic link(Does it matter what dir this is executed from?) *Updated the /usr/local/etc/dbxdrivers.conf with libraryname=libsqlmy23.so.1 Now when I try to connect to the msql server I get a Unable to load libsqlmy23.so.1. Did I do something wrong? Did I skip a step? Terry - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Gui Install and Setup for Win2K
Oops... I meant Microsoft SQL Server and Oracle, not MySQL and Oracle. Matt - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Arthur Fuller [EMAIL PROTECTED]; David Kramer [EMAIL PROTECTED] Cc: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, September 22, 2002 9:14 PM Subject: Re: MySQL Gui Install and Setup for Win2K Don't let them mislead you, MyCC might as well be dead too... there hasn't been an update to it for more than 4 months. Go get MySQL Navigator because at least IT can export to a file that you can then edit. I usually use both though, MyCC is easier to design the basic (and I mean BASIC) database, then go into MySQL Navigator to export it so that I can manually add all the stuff that neither of the semi-worthless apps seem to support (half of SQL). If MySQL AB wants to know why a lot of people use MySQL and Oracle, it's because the tools are there and they work. The only reason that people use MySQL is because it's cheaper (OK, a LOT cheaper). If they made tools that fully supported SQL then MySQL would get a lot more industry support, IMO. Matt - Original Message - From: Arthur Fuller [EMAIL PROTECTED] To: David Kramer [EMAIL PROTECTED] Cc: mysql mailing list [EMAIL PROTECTED] Sent: Sunday, September 22, 2002 6:06 PM Subject: Re: MySQL Gui Install and Setup for Win2K We were told by David Axmark of MySQL AB to stop using MySQLGui and switch to MyCC. MySQLGUI is apparently dead. - Original Message - From: David Kramer [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 16, 2002 12:52 PM Subject: MySQL Gui Install and Setup for Win2K Can some one point me in the direction of some good install and setup Doc for MySQL GUI. Im running the GUI on Win2K, but my DB server is RH7.2 w/ stock Mysql(not sure version number). Also is the FLTK absolutely necessary to run the GUI on Win2K? Any other hints or insights is greatly appreciated. Thanks, DK David Kramer Software Developer Reflect.com Direct: 415.369.4856 Cell: 650.302.7889 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
merge tables - errorno: 143 - Is there a limit on columns with mergedtables ?
Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143) Reducing the number of colums in the tables to be merged removed the problem. Any ideas gratefully received, Dave ( MySQL version: 3.23.52 ) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: merge tables - errorno: 143 - Is there a limit on columns with merged tables ?
from perror 143 = Conflicting table definition between MERGE and mapped table On Sunday, Sep 22, 2002, at 18:36 America/Anchorage, David Herring wrote: Hello, I get the following error when trying to access a table created of TYPE=MERGE mysql describe yy; ERROR 1016: Can't open file: 'yy.MRG'. (errno: 143) Reducing the number of colums in the tables to be merged removed 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
Slight problem storing data with Mysql...
MySQL newbie seeking help and/or advice on storing data into a database. I have a poetry section I'm trying to add to my site that will allow users to submit some of their work for public viewing. An example is located here: http://www.nubiint.com/nuwoez/nuwoez.htm. By clicking on any one of the categories listed in the menu, the user is presented with a link that will allow them to complete a form and enter their text to be stored in the db I've created and made available for public viewing. The problem is that the data doesn't appear to store in the table in the database. After adding some test data I'm able to see the row added to the table, but I'm unable to see or view anything else, for instance the date(s) or data that's set as a mediumblob. How can I view this data to ensure that it is indeed in the table? Also how can I reset the ID field? After I delete the test data the ID doesn't reset, it continues to count from the last ID. Also how can I change the display of the date field? It currently shows as -00-00. Is there anyway to change it to 00-00-??? TIA...Any response is appreciated. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
transactions...
I think I've already asked this before, but I will try again. Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? Thanks. Joao sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions...
Joao, I think I've already asked this before, but I will try again. Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? Possibly, but too much is really relative on what your needs are. What are you trying to achieve and what is more important to you: * speed * reliability * ability to roll back commits mysql,query ?? DSL -- I reniad lin ne mor, nuithannen In gwidh ristennin, i fae narchannen I lach Anor ed ardhon gwannen (Soundtrack LOTR) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: transactions...
Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? Anyway yes. I'm sure it is not worth using InnoDB tables in autocommit mode. If you want to do this use MyISAM instead. Bye, Daniel (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: transactions...
On Mon, 23 Sep 2002, Daniel Kiss wrote: Hi! At 00:56 2002.09.23._ -0300, you wrote: Do I loose too much performance using InnoDB tables in autocommit mode instead of using MyISAM tables? The real quiestion is: Why do you want to use InnoDB tables when you don't want to use its transaction safe features? The reason for prefering InnoDB over MyISAM? Performance. Most benchmarks show InnoDB is slightly faster than MyISAM, and not to mention its some other benefits. But the performance could be a reason on its own to use InnoDB. I don't mean that MyISAM is bad, not at all. It's simpler to use, after all. But what I mean is that InnoDB can be used in all tasks MyISAM is suitable for, and some tasks will be done faster using InnoDB. Best regards, Iikka ** * Iikka Meriläinen * * E-mail: [EMAIL PROTECTED] * * Vaala, Finland * ** sql - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
mysqlimport
Hi I can create a database called test, mysql create database test; Query OK, 1 row affected (0.03 sec) BUT I can't create any other databases??? mysql create database tem; ERROR 1044: Access denied for user: 'ddb@localhost' to database 'tem' mysql create database proj; ERROR 1044: Access denied for user: 'ddb@localhost' to database 'proj' Any idea Thanks Vinita - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php