Crashes
The MySQL server keeps crashing together with half the tables (MySQL-3.23.38). The server is tight-loaded, but not enough for a possible lack of resources. It all acts on a Dell server, Linux-2.2.18. Sincerely yours Maxim A Belushkin System Administrator Hosting Unit RUNET.COM Tuesday, 19 June 2001 - 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
Z prompt running MYSQL on Windows 2000
Hi Guys, I am running MySQL on windows 2000 and I have just noticed something very strange! I have been setting up a network over the last few weeks and managed to install MySQL ok when I wasn't logged on to our domain (I could just run a command prompt, change directory to c:/mysql/bin and then type mysql to run it!) But after I got our domain up and running and I logged on the command prompt automatically starts up with a 'Z' prompt!! Now I can't find the mysql folder, so therefore I can't start mysql anymore - PLEASE HELP! Craig _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Z prompt running MYSQL on Windows 2000
Hi Guys, I am running MySQL on windows 2000 and I have just noticed something very strange! I have been setting up a network over the last few weeks and managed to install MySQL ok when I wasn't logged on to our domain (I could just run a command prompt, change directory to c:/mysql/bin and then type mysql to run it!) But after I got our domain up and running and I logged on the command prompt automatically starts up with a 'Z' prompt!! Now I can't find the mysql folder, so therefore I can't start mysql anymore - PLEASE HELP! Craig _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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: Database size limit
Well, my server is running on Mandrake 8.0. We're trying to implement database hosting at our site, therefore people should probably have database spaces between 10-50 MB. In Microsoft SQL server you can limit the size of a database when creating it. Is it possible in MySQL ? VVM Ravikumar Sarma Chengalvala wrote: No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - 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[2]: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?
Bonjour Heikki, In fact this morning Mysql is ... crashed on this server :( It never crashed with 3.23.38 :( I don't yet know if this is really a 3.23.39 problem or something else. If I'm able to restart Mysql, I will downgrade to 3.23.38 in order to see if it's back to the normal. And then upgrade once more to .39 ... But I have some difficulties to restart Mysql. Here is what I have from the logs : == 010619 09:11:11 mysqld started InnoDB: Database was not shut down normally. InnoDB: Starting recovery from log files... InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 17 879096443 InnoDB: 1 uncommitted transaction(s) which must be rolled back InnoDB: Starting rollback of uncommitted transactions InnoDB: Rolling back trx no 0 == It's like that since minutes now. And not telling anything else :( When I check disk usage and CPU, they stay low so it seems Mysql is not working hard and limited by the system : == load averages: 1.00, 1.00, 0.7709:19:55 55 processes: 53 sleeping, 2 on cpu CPU states: 74.9% idle, 25.0% user, 0.0% kernel, 0.0% iowait, 0.0% swap Memory: 1024M real, 776M free, 362M swap in use, 1402M swap free PID USERNAME THR PRI NICE SIZE RES STATETIMECPU COMMAND 1 root 3 00 342M 39M cpu/38:43 25.00% mysqld 16784 root 1 500 2200K 1400K cpu/20:00 0.09% top ... == If I try to log in Mysql, it's not telling me that there is no Mysql server, but it's not giving me the hand back: == [9:21am]# mysql ... don't returns == With 3.23.38 I started to think I could use Mysql with InnoDB in a production system, but I'm a little feared now :( Alex. - 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 + nfs + Netapp
Hi Ladies and Gents, does anybody has experience with mysql + nfs, or mysql + Nettapp Storage? thx for feedback, Stepan Stepan Havel Nextra Telekom GmbH Kirchberggasse 33 1070 Vienna Tel: +43-1-52533-837 Fax: +43-1-52533-100 Mobile: +43-699-15253-837 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to setup passwords for mysql
hallo!
With reference to Terrell Johnson on 18.06 06:10:
how to setup passwords for mysql
mysql use mysql;
mysql replace into user values ('localhost', 'root', password('testadmin'),
'Y', 'Y', );
mysql quit
Bye
user01@tunix:~ mysqladmin -u root reload
try it with this
On Mon, 18 June 2001, [EMAIL PROTECTED] wrote:
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:
database,sql,query,table
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. You have written the following:
-
Sign up for ICQmail at http://www.icq.com/icqmail/signup.html
-
Sign up for ICQmail at http://www.icq.com/icqmail/signup.html
-
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
--
Gruß bye
Michael Ott
-
- Siemens AG - IS IT PS 51 ERL -
- Werner-von-Siemens-Strasse 60 -
- 91050 Erlangen-
- Tel. +49 91 31 7 42 0 54 -
- [EMAIL PROTECTED] -
-
open-source and you have much fun
-
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 + nfs + Netapp
On Tue, Jun 19, 2001 at 09:27:15AM +0200, Stepan Havel wrote: Hi Ladies and Gents, does anybody has experience with mysql + nfs, or mysql + Nettapp Storage? Several folks on this list (or who *were* on this list) do, yes. Check the list archives and see if you find the answers you seek. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 20,169,033 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: raid tables
On Tue, Jun 19, 2001 at 04:49:58AM +0200, Tonu Samuel wrote: On Mon, 18 Jun 2001, Jeremy Zawodny wrote: I'd use a combination of my.cnf entries and SQL. The my.cnf entry (or entries) woudl list the available directories, like others have suggested. Then, using SQL, you could: * Mark a table to be spread out at creation time vis some attribute. * Possibly do it after the fact using ALTER TABLE. Maybe you are right. I am thinking about security and this is a not the best idea if we introduce a way to write data anywhere on the disks on user request. Indeed. Meanwhile any change in cnf file requires restart of MySQL which is not always possible :(. A while back (at last year's database summit), Monty made some rumblings about maybe making it possible to modify many (most?) of the server variables without an actual restart. Is that that on the horizon for MySQL 4.x, or did it become more difficult that originally thought? If it does happen, I'll start working on the MySQL self-tuning add-on so that folks don't have to play with their my.cnf files as much... Really. I think it'd be fun to build and VERY useful. Then MSSQL wouldn't be the only [advertised] self-tuning database server in the market. :-) Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 20,171,403 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: MySQL + nfs + Netapp
The answers I find are on the one hand: Yes, it works perfectly, I run mysql on a Netapp filer for hunderts of years! , or on the other hand: It simply does not work with nfs and locking it core dumps inconsistent isam files and so on! Do you feel my problem? :-) Stepan -Ursprungliche Nachricht- Von: Jeremy Zawodny [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 19. Juni 2001 09:46 An: Stepan Havel Cc: [EMAIL PROTECTED] Betreff: Re: MySQL + nfs + Netapp On Tue, Jun 19, 2001 at 09:27:15AM +0200, Stepan Havel wrote: Hi Ladies and Gents, does anybody has experience with mysql + nfs, or mysql + Nettapp Storage? Several folks on this list (or who *were* on this list) do, yes. Check the list archives and see if you find the answers you seek. Thanks, Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 20,169,033 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL + nfs + Netapp
On Tue, Jun 19, 2001 at 09:47:27AM +0200, Stepan Havel wrote: The answers I find are on the one hand: Yes, it works perfectly, I run mysql on a Netapp filer for hunderts of years! , or on the other hand: It simply does not work with nfs and locking it core dumps inconsistent isam files and so on! Do you feel my problem? :-) Certainly. The good news is that people *have* made it work and are rather happy with the setup. The first question I have is this: do you plan on running multiple servers against the same data file on the netapp filer? Or are you only going to have one active server (with another available in case the first one dies)? If you're only using a single server, it should work very well. If you're using multiple servers, it should still work if you tell MySQL to use it's external locking feature. Of course, you'll need to test it in your environment. But I've heard of folks making it work. Hope that helps a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 20,305,680 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
cascade delete's
Hi, I wanted only to know, if there is a possibility in mysql for cascading delete's? Because in databases with a lot of tables, it s really difficult to pay attention to all of the dependencies and it would be nice, if there is a possibility for automatically deleting the dependent records. thanks, Sibel. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
AW: MySQL + nfs + Netapp
Thx, that helped! We plan it in the sipler scenario (1 mysqld at time) Of cource we will test it first, before taking it into production. My last question would be: Does it also work if the lockd and statd is not running on the machine where mysqld is running? Stepan On Tue, Jun 19, 2001 at 09:47:27AM +0200, Stepan Havel wrote: The answers I find are on the one hand: Yes, it works perfectly, I run mysql on a Netapp filer for hunderts of years! , or on the other hand: It simply does not work with nfs and locking it core dumps inconsistent isam files and so on! Do you feel my problem? :-) Certainly. The good news is that people *have* made it work and are rather happy with the setup. The first question I have is this: do you plan on running multiple servers against the same data file on the netapp filer? Or are you only going to have one active server (with another available in case the first one dies)? If you're only using a single server, it should work very well. If you're using multiple servers, it should still work if you tell MySQL to use it's external locking feature. Of course, you'll need to test it in your environment. But I've heard of folks making it work. Hope that helps a bit... Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 2 days, processed 20,305,680 queries (79/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: create database problem
mysqladmin --help will provide you with a list of switches you can use. If you add -u root to the shell command , perhaps you'll have more success. - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 16:37 Subject: create database problem shellmysqladmin create trial mysqladmin: CREATE DATABASE failed; error: 'Access denied for user: '@localhost' to database 'trial'' why this happened i only can use test database by default - 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: cascade delete's
That requires the use of foreign keys and that's not supported. - Original Message - From: Sibel Toprakkiran [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 16:23 Subject: cascade delete's Hi, I wanted only to know, if there is a possibility in mysql for cascading delete's? Because in databases with a lot of tables, it s really difficult to pay attention to all of the dependencies and it would be nice, if there is a possibility for automatically deleting the dependent records. thanks, Sibel. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: how to setup passwords for mysql
hallo terrell! what if i can't get into mysql anymore at all, not even as root, :( is there file somewhere i can edit so i can get in again? have you try it with this? mysql -u root mysql Gruß bye Michael Ott - - Siemens AG - IS IT PS 51 ERL - - Werner-von-Siemens-Strasse 60 - - 91050 Erlangen- - Tel. +49 91 31 7 42 0 54 - - [EMAIL PROTECTED] - - open-source and you have much fun - 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
listing data form database
hai Can anybody help me? I'am query out data(country name) from database,total count of country if 100.Now i want to arrange the country's name by 3 column() not long list.It should be example: trtdAntigua/tdtdAustralia/tdtdAustria/td/tr trtdBarbados/tdtdBelgium/tdtdBrazil/td/tr trtdBulgaria/tdtdCanada/tdtdChina/td/tr It's possible? thanks in advance. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
Performance and the my.cnf file
Hi, I have several problems to do with tuning mysql to run on a Sun E450. Firstly, I cannot get the mysql to read the my.cnf file. If it is installed in the data directory, mysql boots OK but ignores it, while if I copy it into the /etc directory I get the following error Starting mysqld daemon with databases from /home1/mysql/data mysqld daemon ended and mysql does not start up Also, how do you know what the current values of the variables are? Does the command mysqladmin variables outputs the global variables or the current settings of those variables and does the -O option eg mysqld -O key_buffer=32m change the variables on the fly or does the mysql process have to be restarted? Thanks for any help. I am presently struggling to get reasonable performance from our server. Thanks, David - 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 transfer
Hi, Do someone maybe know, if it is possible to transfer a mysql database? Is it enough, that I copy the /mysql/data/$databasename to another computer to have there the same database with the same tables and records? thanks regards, Sibel. __ Do You Yahoo!? Spot the hottest trends in music, movies, and more. http://buzz.yahoo.com/ - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
phpMyAdmin newbie problem
Hi, I am wondering why I am unable to use the SELECT statement to access data in a MySQL (3.22.32) database I have created using phpMyAdmin (2.1.0). Everything else about it is a delight to use (I am migrating from SQLAnywhere) and I have managed to create tables and insert data into them no problem. But every time I use a SELECT statement I get the error: Error SQL-query: select * from books; MySQL said: Back Obviously I am making a wrong assumption somewhere. The documentation I have checked is the official MySQL manual but this does not relate specifically to phpMyAdmin and certainly does not prohibit SELECT statements! tia Tommy Beavitt - 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: Oddity with building 3.23.38 on Tru64 4.0f
Dave FitzPatrick writes: I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f Alpha box from 3.22.25 to 3.23.38. As in the past, I used the Compaq cc as CC and gcc (2.95.3) as CXX with appropriate flags set. I do not have the GNU binutils installed, so it is the Compaq ld that is used. I am, however, using GNU make. I wanted to build with both BDB and InnoDB, so I configured as: ./configure --prefix=/usr/local/mysql --enable-assembler \ --with-low-memory --with-innodb --with-berkeley-db The configure proceded just fine and I typed make. Quite a while later I got this: cut I edited sql/Makefile and replaced the two occurrences of: -L$(top_builddir)/bdb/build_unix -ldb with $(top_builddir)/bdb/build_unix/libdb.a and the make proceded without further incident. I'm not sure if this is a problem with Compaq's ld or something else, but I found it curious. D= -- Dave FitzPatrick [EMAIL PROTECTED] Webmaster 978-681-1599 Quantic Communications An MHI Company http://www.quantic.com/ Definitely looks like Compaq linker bug. Some GNU linker versions have a similar bug. Contact Compaq and submit the info. We have had good experience with a software engineer from Compaq that is maintaining their linker. -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
COUNT(DISTINCT) -- is this correct behaviour?
Hi!
Thanks for the nice test case!
Next time you have as nice a test case, please send it to
[EMAIL PROTECTED] for fast treatment!
tommie == tommie [EMAIL PROTECTED] writes:
tommie count() gives 0 but count(distinct) gives 1. is this correct or
tommie a bug or is there something wrong with my SELECT?
mysql create table t1 (f1 int);
mysql insert into t1 values (1);
mysql create table t2 (f1 int,f2 int);
mysql select t1.f1,count(t2.f2) from t1
- left join t2 on t1.f1=t2.f1 group by t1.f1;
tommie +--+--+
tommie | f1 | count(t2.f2) |
tommie +--+--+
tommie |1 |0 |
tommie +--+--+
tommie 1 row in set (0.00 sec)
mysql select t1.f1,count(distinct t2.f2) from t1
- left join t2 on t1.f1=t2.f1 group by t1.f1;
tommie +--+---+
tommie | f1 | count(distinct t2.f2) |
tommie +--+---+
tommie |1 | 1 |
tommie +--+---+
tommie 1 row in set (0.01 sec)
Fix:
= sql/item_sum.cc 1.7 vs edited =
*** /tmp/item_sum.cc-1.7-18231 Sun Jan 28 21:35:50 2001
--- edited/sql/item_sum.cc Tue Jun 19 12:58:35 2001
***
*** 809,816
ListItem list;
/* Create a table with an unique key over all parameters */
for (uint i=0; i arg_count ; i++)
! if (list.push_back(args[i]))
! return 1;
count_field_types(tmp_table_param,list,0);
if (table)
{
--- 809,827
ListItem list;
/* Create a table with an unique key over all parameters */
for (uint i=0; i arg_count ; i++)
! {
! Item *item=args[i];
! if (list.push_back(item))
! return 1; // End of memory
! if (item-const_item())
! {
! (void) item-val_int();
! if (item-null_value)
! always_null=1;
! }
! }
! if (always_null)
! return 0;
count_field_types(tmp_table_param,list,0);
if (table)
{
***
*** 827,841
void Item_sum_count_distinct::reset()
{
! table-file-extra(HA_EXTRA_NO_CACHE);
! table-file-delete_all_rows();
! table-file-extra(HA_EXTRA_WRITE_CACHE);
! (void) add();
}
bool Item_sum_count_distinct::add()
{
int error;
copy_fields(tmp_table_param);
copy_funcs(tmp_table_param-funcs);
--- 838,857
void Item_sum_count_distinct::reset()
{
! if (table)
! {
! table-file-extra(HA_EXTRA_NO_CACHE);
! table-file-delete_all_rows();
! table-file-extra(HA_EXTRA_WRITE_CACHE);
! (void) add();
! }
}
bool Item_sum_count_distinct::add()
{
int error;
+ if (always_null)
+ return 0;
copy_fields(tmp_table_param);
copy_funcs(tmp_table_param-funcs);
= sql/item_sum.h 1.5 vs edited =
*** /tmp/item_sum.h-1.5-18231 Sat Jan 27 01:20:55 2001
--- edited/sql/item_sum.h Tue Jun 19 12:59:50 2001
***
*** 145,155
table_map used_table_cache;
bool fix_fields(THD *thd,TABLE_LIST *tables);
TMP_TABLE_PARAM *tmp_table_param;
public:
Item_sum_count_distinct(ListItem list)
:Item_sum_int(list),table(0),used_table_cache(~(table_map) 0),
! tmp_table_param(0)
{ quick_group=0; }
~Item_sum_count_distinct();
table_map used_tables() const { return used_table_cache; }
--- 145,156
table_map used_table_cache;
bool fix_fields(THD *thd,TABLE_LIST *tables);
TMP_TABLE_PARAM *tmp_table_param;
+ bool always_null;
public:
Item_sum_count_distinct(ListItem list)
:Item_sum_int(list),table(0),used_table_cache(~(table_map) 0),
! tmp_table_param(0),always_null(0)
{ quick_group=0; }
~Item_sum_count_distinct();
table_map used_tables() const { return used_table_cache; }
The above will be in the next MySQL release.
Regards,
Monty
-
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 3.23.39 released
hi! Steven == Steven Roussey [EMAIL PROTECTED] writes: Steven Now I have a question: Does this also apply to automatic repair inside Steven mysqld? I'd finally use the feature if its true... If you just run CHECK TABLE, it will repair the open count (it should always have done that). myisamchk --fast --force is equal to: run CHECK TABLE on all tables Run REPAIR TABLE on tables which was not marked as ok. Steven I was refering to --myisam-recover=FORCE Steven As I remember, it would repair tables that had a open count 0 (at least Steven back when I first tried using it). I checked this and at least now it only repairs the table if a check table finds something wrong. Regards, Monty - 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: begin and commit w/ perl
r When begining and commiting a transaction using perl and DBI, does the
r commit need to come from the same statement handle as the begin or does it
r just need to be from the same database connection handle?
If you are using DBI for transactions you should have something like:
$dbh-{AutoCommit} = 0; # enable transactions, if possible
$dbh-{RaiseError} = 1;
eval {
foo(...)# do lots of work here
bar(...)# including inserts
baz(...)# and updates
$dbh-commit; # commit the changes if we get this far
};
if ($@) {
warn Transaction aborted because $@;
$dbh-rollback; # undo the incomplete changes
# add other application on-error-clean-up code here
}
Sample have been taken right from 'perldoc DBI'. Read section
'Transaction' there for more info.
P.S. Be sure that you have latest version of Msql-Mysql-modules
(version 1.2216). Previous versions does not support transactions.
--
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
| Ilya Martynov (http://martynov.org/)|
| GnuPG 1024D/323BDEE6 D7F7 561E 4C1D 8A15 8E80 E4AE BE1A 53EB 323B DEE6 |
| AGAVA Software Company (http://www.agava.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: simple commands, no joy
Assuming you are trying to execute MySQL(SQL) commands from 'netsloth.dump', remove the 'redirect to' after the mysql command. This also assumes you are logged into the localhost using the command line interface. Your command would appear similar to the following: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump Remove the trailing semi-colon from the command line. I hope this helps... Pat... [EMAIL PROTECTED] - Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, June 18, 2001 9:44 PM Subject: simple commands, no joy what's wrong with this please: mysql -u jjames -psd342 dbtheNetee /Library/WebServer/web1/book/install/netsloth.dump; - (as i understand it a .dump = .sql file) 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 - 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: cascade delete's
Rolf Hopkins writes: That requires the use of foreign keys and that's not supported. The above is true, but in a near future beta version of multi-table delete will be ready for testing in 4.0 branch. Syntax will be : delete t1,t2,t3 from join_of_any_type_involving_at_least_t1_t2_t3 ... -- Regards, __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Important bug in RAID tables
On Tue, 19 Jun 2001, Patrizio Bruno wrote: BTW, why did you change the chunksize? By default it is 256000 and I tested it for speed with many different values. 256000 seemed to be best value. If you have any experience showing that I was wrong, please share it with me. I was testing different chunksize looking for the best on SGI's XFS, I will let you know some better value than 256000, if one exists :) I got this result when I first put lower vales like 4kB and 8kB and found that RAID takes too much of CPU time. When using RAID, instead of single syscalls open/read/write/seek/tell/close mysql calls then many times. Syscalls are very expensive in time in many operating systems and I got no slowdown when I increased raid chunk value to be so high as 256000kBytes. I think this is the good value as such amount of data can be fitted into hard disk hardware cache and can speed up writing do disk many times. Because this I do not suggest to extend it also. Default value should be good for most cases. -- For technical support contracts, goto https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Tonu Samuel [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Security Administrator /_/ /_/\_, /___/\___\_\___/ Hong Kong, China ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Database size limit
Hi, For most of the platforms Mysql has reasonably enough space for each table itself(in GB).Database wise, also there should not be any problem for the database size you are mentioning.For sure,I can say that I have not worked on Mandrake.But, I feel the size you have mentioned should not be a problem. Regards, Ravi --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Well, my server is running on Mandrake 8.0. We're trying to implement database hosting at our site, therefore people should probably have database spaces between 10-50 MB. In Microsoft SQL server you can limit the size of a database when creating it. Is it possible in MySQL ? VVM Ravikumar Sarma Chengalvala wrote: No need to worry.On NT each table can have upto4GB.Database there is predefined limit.It can go even upro 20GB or more also. --- Ali Kemal YURTSEVEN [EMAIL PROTECTED] wrote: Hi, I'm new in this list and new to MySQL also. What I want to know is how to limit the size of a database. Thanks. -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- Ali Kemal YURTSEVEN Is Net A.S. Iletisim Uzmani - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie - 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 Crashes
Woyou, you should use mysql-max.exe on Win 9x an Win ME because mysqld.exe in 3.23.38 was accidentally compiled with __NT__ defined. But I recommend downloading the new 3.23.39. It does not have the above problem. Regards, Heikki Tuuri http://www.innodb.com Copied message: ... Hi, I am new to MySQL. I downloaded MySQL for Windows version 3.23.38. When I installed in MyISAM mode, mysqld was running fine. Then I uncommented the configure parameters for innoDB in my.cnf. Mysqld initialized the database the folowing messages printed on screen. Can anyone help ? Thanks, Woyou InnoDB: The first specified data file\cygwin\usr\local\mysql\var\ibdata1 did not exist:InnoDB: a new database to be created! InnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata1 size to26214400 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata2 did not exist:new to be c reatedInnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata2 size to38797312 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata3 did not exist:new to be c reatedInnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata3 size to104857600 InnoDB: Database physically writes the file full: wait... InnoDB: Data file \cygwin\usr\local\mysql\var\ibdata4 did not exist:new to be c reatedInnoDB: Setting file \cygwin\usr\local\mysql\var\ibdata4 size to314572800 InnoDB: Database physically writes the file full: wait... InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile0 did not exist:new to b e createdInnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile0 size to 5242880 InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile1 did not exist:new to b e createdInnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile1 size to 5242880 InnoDB: Log file \cygwin\usr\local\mysql\var\ib_logfile2 did not exist:new to b e createdInnoDB: Setting log file \cygwin\usr\local\mysql\var\ib_logfile2 size to 5242880Innobase: Assertion failure in thread 4294535455 in file M:\mysql-3.23\innobase\os\os0file.c line 187 Innobase: we intentionally generate a memory trap. Innobase: Send a bug report to [EMAIL PROTECTED] 010618 15:56:21 c:\MYSQL\BIN\mysqld.exe: Got signal 11. Aborting! 010618 15:56:21 Aborting InnoDB: Warning: shutting down not properly started database 010618 15:56:22 c:\MYSQL\BIN\mysqld.exe: Shutdown Complete - 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
Volker Menten
Sehr geehrte Damen und Herren, ich bin dabei eine Homepage (Futureworld3000.de) mit php und mysql zu erstellen. Ich konnte aber bis her keine Informationen über ADO finden. Über Informationen währe ich ihnen sehr Dankbar! Mit freundlichen Grüßen Volker Menten ___ 1.000.000 DM gewinnen - kostenlos tippen - http://millionenklick.web.de [EMAIL PROTECTED], 8MB Speicher, Verschluesselung - http://freemail.web.de - 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: assign auto password
I use the MD5 command in mysql...I think PHP also has this... refer to the manual Hasan - Original Message - From: Mike [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 9:50 AM Subject: RE: assign auto password Using PHP you can. PHP Nuke has this, I use it on my site, other than that no clue. -Original Message- From: saraswathy saras [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 10:20 PM To: [EMAIL PROTECTED] Subject: assign auto password Do anyone know how to assign password automatically or create a new password in mysql by using only user id. Thanks in advance _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: MySQL compilation problems, Solaris 8
Hi Mark, I had the same problem too. I downloaded the gcc 2.95.3 and compiled it myself. Using thatt gcc to compile MySQL, and everything worked fine. kind regrads Peter Bethke - 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: 3.23.39+InnoDB = slower than 3.23.389InnoDB ?
Alex, this mysql/innobase/trx/trx0undo.c prints trace information on what it finds at database startup. Could you try compiling a new mysqld and try starting the database with the new mysqld. Obviously the recovery goes into an infinite loop, and this helps to find out why. Regards, Heikki - 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 + unicode
please, does mysql support unicode? thanks in advance - 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 bug
Thanks for catching this - I had an extremely long merge union, and had a table missing - no error, so I've been trying to track down a configuration issue for two days. - Scott Russell - 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: Performance and the my.cnf file
Make sure my.cnf is mode 744. David Allen wrote: Hi, I have several problems to do with tuning mysql to run on a Sun E450. Firstly, I cannot get the mysql to read the my.cnf file. If it is installed in the data directory, mysql boots OK but ignores it, while if I copy it into the /etc directory I get the following error Starting mysqld daemon with databases from /home1/mysql/data mysqld daemon ended and mysql does not start up Also, how do you know what the current values of the variables are? Does the command mysqladmin variables outputs the global variables or the current settings of those variables and does the -O option eg mysqld -O key_buffer=32m change the variables on the fly or does the mysql process have to be restarted? Thanks for any help. I am presently struggling to get reasonable performance from our server. Thanks, David - 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Start fails after upgrade to 3.23.32 - no host.ISM file
host.ism is in the var/mysql/mysql directory. chown -R mysql /var/mysql Subistitute the real path for /var/mysql. [EMAIL PROTECTED] wrote: Description: Upgraded from 3.22.27 to 3.23.32. Built from source. When attempting to start the daemon, it immediately terminates. Log file shows Can't find file: 'host.ISM' (errno: 2). I checked the old data directory (from where I copied the database files) and there never has been a host.ISM file. I don't see a reference to this in the trouble shoot guides. Please note: I cannot go to the current version as this machine (development) cannot be on a higher version that the production machine, which is on 3.23.32. How-To-Repeat: Use either safe_mysqld or mysql.server to start. Same symptoms. Fix: Looking for fix. Submitter-Id:submitter ID Originator: Guy Smith Organization: FundTheCause, Inc. MySQL support: none Synopsis:Start fails after upgrade to 3.23.32 - no host.ISM file Severity:serious Priority:medium Category:mysql Class: support Release: mysql-3.22.32 (TCX binary) Environment: System: Linux linus 2.2.14-5.0 #1 Tue Mar 7 20:53:41 EST 2000 i586 unknown Architecture: i586 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-redhat-linux/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314/Linux (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentium -fomit-frame-pointer' CXX='gcc' CXXFLAGS='-O6 -mpentium -fomit-frame-pointer -felide-constructors' LDFLAGS='-static' Configure command: ./configure --prefix=/usr/local/mysql '--with-comment=TCX binary' --enable-assembler --with-mysqld-ldflags=-all-static --with-client-ldflags=-all-static --disable-shared - 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 -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: listing data form database
This isn't so much of a MySQL question as it is a PHP (or ASP or whatever)
question.
At any rate, probably the best way to do this is with nested FOR loops. In
PHP, it would look something like this:
mysql_select_db(database_name);
$qry = select country_name from table_name where [...conditions...];
$result = mysql_query($qry)
$number_of_results = mysql_num_rows($result)
if ($number_of_results = 1)
{
for ($i = 0; $i $number_of_results; $i = $i + 3)
{
echo tr/n
for ($i2 = 0; (($i2 3)||(($i + $i2) = $number_of_results));
$i2++)
{
$record_id = ($i + $i2);
echo td.$result[$record_id]./td\n;
}
echo /tr\n
}
else
{
echo trtdThe database did not resurn any records./td/tr;
}
- Original Message -
From: saraswathy saras [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, June 19, 2001 2:51 AM
Subject: listing data form database
hai
Can anybody help me? I'am query out data(country name) from database,total
count of country if 100.Now i want to arrange the country's name by 3
column() not long list.It should be
example:
trtdAntigua/tdtdAustralia/tdtdAustria/td/tr
trtdBarbados/tdtdBelgium/tdtdBrazil/td/tr
trtdBulgaria/tdtdCanada/tdtdChina/td/tr
It's possible?
thanks in advance.
_
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.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
copying tables between databases in mySQL 3.22.32
Hi, I am using mySQL 3.22.23 on a Linux platform. How can I copy or move Tables between different Databases? Is there a simple command for that? We do not have the mysqlhotcopy command; is it safe to download and use for our mySQL version, and can it do what I want it to do? I cannot find anything definite in the manual about this, so any suggestions are welcome! Thanks, Arno -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- Arno Schoenmakers System Scientist ASTRON P.O. Box 2 tel: +31-521-595100 7990-AA Dwingeloofax: +31-521-597332 The Netherlands email: [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
database design
Is it better to have very small tables with a max of 3 rows, slightly larger tables with several indexed columns. I am designing a database for a medium size company. I certainly plan to expand the business and the database. I want to make sure that I plan the DB correctly from the beginning. I am thinking that most tables will use an autogen primary key. Does anyone have a link to a good source of reading for database design? Maybe recommended dead tree reading? Thanks -Spencer Underground deltree c:\windows /y - 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: mysqldump bug during regenerate enum field.
It would seem that there is a bug, and it's that create table accepts an 'illegal' definition. It should either convert the integer to a literal (making the definition legal and dumpable), or it should barf on it. IMO, of course. --Pete [Charset iso-8859-1 unsupported, filtering to ASCII...] But my problem is perhaps simply in the concept: When MySQL accept a create table in entry (as bad as it is like this one from a guy in my team), mysqldump should regenerate from this table a create table statement accepted by MySQL too. no? it's not logic? ;-) Regards, Le Mon, Jun 18, 2001 at 09:34:27AM -0400, John Cichy a _crit: Sinisa, A good way to prove that mysqldump is doing what it should, might be to do a describe TESTBADDUMP; I think this will prove that mysqldump is just dumping what is in the table def, which is all you can expect. Have a great day... John On Monday 18 June 2001 09:46, Sinisa Milivojevic wrote: Guillaume Fougnies writes: ok so it's a failure from mysqldump. I know this declaration is not really correct but mysqldump must regenerate a correct sql statement (good when pipe in mysql client i mean at least ;) ). It's not the case. Regards, -- Guillaume FOUGNIES Research Development Profile For You Ltd. No, it is not mysqldump failure. If you specify integers where literals are expected, then it is your fault. Use quotes and a problem will dissapear. Regards, -- For technical support contracts, go to https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Mr. Sinisa Milivojevic [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, FullTime Developer /_/ /_/\_, /___/\___\_\___/ Larnaca, Cyprus ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php -- Have a great day... John -- Guillaume FOUGNIES Research Development Profile For You Ltd. - 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
New Mascon version 2.2
Hi All, The new Mascon version 2.2 was released recently. For more detail and a complete list of features see http://www.scibit.com/mascon. Some of the new features: * Server side result sets * Support for fulltext index creation in the visual table designer * Support for sub-part indexes creation in the visual table designer * Support for fulltext and sub-part indexes in Mascon dump * Import Tab delimited text files directly into a table * Inline display of text fields in data grids * Option to always ask for a password when connecting to a server We have also updated the license agreement as many have requested, please see the file license.txt for more detail. Download links for complete installations and patches are available on the Mascon home page, http://www.scibit.com/mascon. Most of the MySQL mirror sites should have downloads for Mascon under the Win32 section. Best regards, Antonie -- S C I B I T -- Antonie Neethling ([EMAIL PROTECTED]) http://www.scibit.com/mascon - Win32 MySQL Admin Client http://www.scibit.com/mysqlx - COM interface to MySQL http://www.scibit.com/mysql - MySQL related products -- S C I B I T -- - 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: phpMyAdmin newbie problem
At 10:23 am +0100 19/6/01, Tommy Beavitt wrote: I am wondering why I am unable to use the SELECT statement to access data in a MySQL (3.22.32) database I have created using phpMyAdmin (2.1.0). Everything else about it is a delight to use (I am migrating from SQLAnywhere) and I have managed to create tables and insert data into them no problem. But every time I use a SELECT statement I get the error: Error SQL-query: select * from books; MySQL said: Back Obviously I am making a wrong assumption somewhere. The documentation I have checked is the official MySQL manual but this does not relate specifically to phpMyAdmin and certainly does not prohibit SELECT statements! But nobody picked up on it. Does anyone know of a good discussion list relating specifically to phpMyAdmin? Thanks Tommy - 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 creating a fulltext
Hi all, ... running this query alter table item_dettagli add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua) I get this error: 1005 - Can't create table '.\pickwick\#sql-3d0_2.frm' (errno: 140) Query: alter table item_dettagli add fulltext(categoria_prezzo,settore,movimento,soggetto,lingua) what does it means?? (vers. 3.23.37 on win2k box) many thanks in advance max - 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: phpMyAdmin newbie problem
Drop the semi-colon off the end of the SQL Statement you wish to run. You don't need them in the phpMyAdmin SQL Window. Enjoy, Tyrone - Original Message - From: Tommy Beavitt [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 8:31 AM Subject: Re: phpMyAdmin newbie problem At 10:23 am +0100 19/6/01, Tommy Beavitt wrote: I am wondering why I am unable to use the SELECT statement to access data in a MySQL (3.22.32) database I have created using phpMyAdmin (2.1.0). Everything else about it is a delight to use (I am migrating from SQLAnywhere) and I have managed to create tables and insert data into them no problem. But every time I use a SELECT statement I get the error: Error SQL-query: select * from books; MySQL said: Back Obviously I am making a wrong assumption somewhere. The documentation I have checked is the official MySQL manual but this does not relate specifically to phpMyAdmin and certainly does not prohibit SELECT statements! But nobody picked up on it. Does anyone know of a good discussion list relating specifically to phpMyAdmin? Thanks Tommy - 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
inserting images in mysql tables
I am new to mysql. I am attempting to place images in one of my columns. As for my table structure, I have gotten as far as: image blob NOT NULL, How should I proceed? Thanks a bunch Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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
DISTINCT list ORDER problem
I'm generating a pulldown menu using PHP and MySQL. Originally I had the list order by model where it put everything in alphabetical order. I need to order them by year of model which luckily coincides with the order that I dumped them into the database so I would like to ORDER by id which was an auto-increment number. The list work fine when ordering by model but when I order by id I pull up more then distinct model names. Here's the query; $menu_query = SELECT DISTINCT model . FROM a_clutch . WHERE make = \Harley-Davidson\ AND status = \active\ . ORDER BY id; How can I pull up distinct models and order just the distinct models by id? Thanks, Tom . Tom Beidler Orbit Tech Services 805.682.8972 (phone) 805.682.5833 (fax) [EMAIL PROTECTED] http://www.orbittechservices.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
possible errors when using myisamchk and isamchk ?
hi, I'm trying to automate the back up of my databases, and before I perform my backup I check my tables using myisamchk and isamchk. When myisamchk and isamchk report errors I would like to catch that and maybe perform a restore operation. hence my question: what could go wrong when running myisamchk and isamchk and what could I get as error / warning messages ? Can I find a list of all the possible error messages ? for know I check the output of both myisamchk and isamchk for lines containing error and warning but I would like to search for more precise errormessages. Who can help me out ?` kind regards Koen Gogne [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: multiple-(BLOB)column, primary key for pre-v 3.23 db
Hi, No problem in my case, i´m using varchar inorder to get url and image paths and works well, and they are indexed in some cases. Blob fiels make tables work slower? Does they use much disk? I´m meking a database with descriptions of buildings usin blob for descriptions. Is there another way for do the same in a better way? Thanks Javier Armendáriz [EMAIL PROTECTED] Brian Warn wrote: Hello, I want to use two text columns as my primary key. From the DuBois book, I see that I cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns cannot be indexed. Besides upgrading to v. 3.23+, is there any workaround to this? One column will simply store really long URL values (300 characters max, I'm guessing), and the other column stores graphic image names, probably 50 characters max in length. Any reason why varchar wouldn't work for this? Thanks, Brian - 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-(BLOB)column, primary key for pre-v 3.23 db
On Tue, Jun 19, 2001 at 08:48:56AM -0700, Brian Warn wrote: Hello, I want to use two text columns as my primary key. From the DuBois book, I see that I cannot do this since my v. 3.22.32 tables are ISAM, and BLOB and TEXT columns cannot be indexed. Besides upgrading to v. 3.23+, is there any workaround to this? One column will simply store really long URL values (300 characters max, I'm guessing), and the other column stores graphic image names, probably 50 characters max in length. Any reason why varchar wouldn't work for this? VARCHAR columns can't hold 300 characters. And there is a limit on the size of any given index. You really ought to consider upgrading. The version you're running is basically unsupported anymore. Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 3 days, processed 23,317,695 queries (81/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: inserting images in mysql tables
you should probably just store the images on your server, and provide the location to the image in the table...much quicker. Tyler - Original Message - From: Felicia [EMAIL PROTECTED] To: mysql post [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 11:03 AM Subject: inserting images in mysql tables I am new to mysql. I am attempting to place images in one of my columns. As for my table structure, I have gotten as far as: image blob NOT NULL, How should I proceed? Thanks a bunch Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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: inserting images in mysql tables
IMHO, (take it for what it is worth) You shouldn't. Store a reference to the image in the database.(either a file system reference, or if you are doing HTML, store the URL) I've yet to see a good reason for stuffing an image in a database. In most cases the OS/file system will handle the image faster than the database will. Sorry, probably not the answer you wanted. Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: Felicia [EMAIL PROTECTED] To: mysql post [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 11:03 AM Subject: inserting images in mysql tables I am new to mysql. I am attempting to place images in one of my columns. As for my table structure, I have gotten as far as: image blob NOT NULL, How should I proceed? Thanks a bunch Get free email and a permanent address at http://www.netaddress.com/?N=1 - 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 backup
I copy the 3 MYD MYI frm of a database to another directory as a way of backup. Is this the right way to do it. It appears to be not function correctly. Any help appreciate. Thanks.
Re: Important bug in RAID tables
I can't reproduce the error using a different database configuration and I can't use the same database schema to make my test (the machine is now in production state), so I attached to this mail te sql file used to create the tables, this database is used by ASPseek 1.2.0, you can download it at www.aspseek.org, and the problem occurred indexing http://lanazione.monrif.net (almost 3 millions documents, so there were almost 3 millions records in the table 'urlword') - Patrizio Bruno DADA spa / Special Projects Viale Giovine Italia 50122 Firenze Italy tel +39 055200211 fax +39 0552478143 PGP PublicKey available at: http://www.keyserver.net/en/ - # This SQL script will create the necessary tables for ASPSeek. # It should be used for MySQL only. # To create the tables, use something like # mysql -uasp -pmypassword aspseek tables.sql # #drop table wordurl; #drop table wordurl1; #drop table urlword; #drop table urlwords00; #drop table urlwords01; #drop table urlwords02; #drop table urlwords03; #drop table urlwords04; #drop table urlwords05; #drop table urlwords06; #drop table urlwords07; #drop table urlwords08; #drop table urlwords09; #drop table urlwords10; #drop table urlwords11; #drop table urlwords12; #drop table urlwords13; #drop table urlwords14; #drop table urlwords15; #drop table sites; #drop table stat; #drop table robots; #drop table subsets; #drop table spaces; #drop table tmpurl; #drop table wordsite; #drop table citation; #drop table countries; #drop table cache; create table wordurl(word tinyblob not null, word_id integer auto_increment primary key, urls blob, urlcount integer, totalcount integer, unique index(word(64))) PACK_KEYS=1 DELAY_KEY_WRITE=1; create table wordurl1(word tinyblob not null, word_id integer not null, urls blob, urlcount integer, totalcount integer, unique index(word(64)), unique index(word_id)); create table urlword(url_id integer auto_increment primary key, site_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (site_id,crc(8))) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=8 RAID_CHUNKSIZE=153600 PACK_KEYS=1; create table urlwords00(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL, lang varchar(2) DEFAULT '' NOT NULL, words longblob, hrefs longblob, unique index(url_id)) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=10 RAID_CHUNKSIZE=153600; create table urlwords01(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL, lang varchar(2) DEFAULT '' NOT NULL, words longblob, hrefs longblob, unique index(url_id)) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=10 RAID_CHUNKSIZE=153600; create table urlwords02(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL,
Embedding MySql
Hi, I want to embed MySql in my application. Please help me in doing this. Ankur
IFNULL issues??
Hi, Maybe someone could take a moment to explain this behavior? I am using IFNULL() in an order by statement to push null values to the end of a table for sorting. For example: mysql select distinct s.some_pk as myid, queryid from data_table s, userdata.queryinfo q where s.some_pk=q.myid order by IFNULL(myid, 999); This works fine (let's ignore for the moment the possibility of null primary key values :) ). However, this does not work: mysql select distinct s.some_pk as myid from data_table s, other_data_table where s.some_pk=232 order by IFNULL(myid, 999); ERROR 1054: Unknown column 'myid' in 'order clause' What gives? What is the difference for IFNULL between these two statements? My first thought was that IFNULL for some reason does not recognize aliases, but then the first statement works. Also, 'pkid' is not ambiguous. I don't get it. Am I missing the obvious? Anyone? Thanks, Bryan - 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 design
Alot of it would depend on what exactly you are doing. If you have alot of small tables with only 3 columns(I'm assuming thats what you meant) that can make for a messy server when it starts getting hit by a demand. Also, there are lots of good books on database design. Que generally has made some pretty good books and are available at most borders or barnes noble. In most cases the theory is still the same when it comes to relational databases. One thing that I dont think that most books go over is what I like to call 'Relational Theory vs Relational Reality'. Sometimes using a relational design, causes a significant overhead on the machine and also there are situations when you are obtaining data for the data collecting tables, you might want the opportunity to copy the data over rather than refer to the data table being looked to for this data. This will increase the size of the database, but overcomes situations such as 'What if the part# changes descriptions slightly?' If you're still using the same part#, but different description and you have to refer back to line item (I'm using a basic inventory system layout here), your customer could be looking at one thing and you another and a breakdown in the communication occurs because now the info isnt the same. Alot of times, it is via experimentation that you learn this sort of thing. Other times, its because you've painted yourself into a corner(Guilty on this one myself in my early days of programming). Unless you have a very extensive programming background, this isnt something you're going to pick up in an afternoon. Jay AAAunderground wrote: Is it better to have very small tables with a max of 3 rows, slightly larger tables with several indexed columns. I am designing a database for a medium size company. I certainly plan to expand the business and the database. I want to make sure that I plan the DB correctly from the beginning. I am thinking that most tables will use an autogen primary key. Does anyone have a link to a good source of reading for database design? Maybe recommended dead tree reading? Thanks -Spencer Underground deltree c:\windows /y - 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: IFNULL issues??
If you drop the order by, does the second query work? Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.com * - Original Message - From: BCC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 12:18 PM Subject: IFNULL issues?? Hi, Maybe someone could take a moment to explain this behavior? I am using IFNULL() in an order by statement to push null values to the end of a table for sorting. For example: mysql select distinct s.some_pk as myid, queryid from data_table s, userdata.queryinfo q where s.some_pk=q.myid order by IFNULL(myid, 999); This works fine (let's ignore for the moment the possibility of null primary key values :) ). However, this does not work: mysql select distinct s.some_pk as myid from data_table s, other_data_table where s.some_pk=232 order by IFNULL(myid, 999); ERROR 1054: Unknown column 'myid' in 'order clause' What gives? What is the difference for IFNULL between these two statements? My first thought was that IFNULL for some reason does not recognize aliases, but then the first statement works. Also, 'pkid' is not ambiguous. I don't get it. Am I missing the obvious? Anyone? Thanks, Bryan - 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: IFNULL issues??
Yep. In fact, if I replace 'myid' by s.some_pk the query works as well. This is what make me think it was a feature (bug?) with IFNULL in that it would not recognize aliases. But then theres the query that does work :P Bryan -Original Message- From: Cal Evans [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 10:45 AM To: BCC; [EMAIL PROTECTED] Subject: Re: IFNULL issues?? If you drop the order by, does the second query work? Cal * * Cal Evans * Senior Internet Dreamer * http://www.calevans.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: Important bug in RAID tables
I can't reproduce the error using a different database configuration and I can't use the same database schema to make my test (the machine is now in production state), so I attached to this mail te sql file used to create the tables, this database is used by ASPseek 1.2.0, you can download it at www.aspseek.org, and the problem occurred indexing http://lanazione.monrif.net (almost 3 millions documents, so there were almost 3 millions records in the table 'urlword') - Patrizio Bruno DADA spa / Special Projects Viale Giovine Italia 50122 Firenze Italy tel +39 055200211 fax +39 0552478143 PGP PublicKey available at: http://www.keyserver.net/en/ - # This SQL script will create the necessary tables for ASPSeek. # It should be used for MySQL only. # To create the tables, use something like # mysql -uasp -pmypassword aspseek tables.sql # #drop table wordurl; #drop table wordurl1; #drop table urlword; #drop table urlwords00; #drop table urlwords01; #drop table urlwords02; #drop table urlwords03; #drop table urlwords04; #drop table urlwords05; #drop table urlwords06; #drop table urlwords07; #drop table urlwords08; #drop table urlwords09; #drop table urlwords10; #drop table urlwords11; #drop table urlwords12; #drop table urlwords13; #drop table urlwords14; #drop table urlwords15; #drop table sites; #drop table stat; #drop table robots; #drop table subsets; #drop table spaces; #drop table tmpurl; #drop table wordsite; #drop table citation; #drop table countries; #drop table cache; create table wordurl(word tinyblob not null, word_id integer auto_increment primary key, urls blob, urlcount integer, totalcount integer, unique index(word(64))) PACK_KEYS=1 DELAY_KEY_WRITE=1; create table wordurl1(word tinyblob not null, word_id integer not null, urls blob, urlcount integer, totalcount integer, unique index(word(64)), unique index(word_id)); create table urlword(url_id integer auto_increment primary key, site_id integer not null, deleted tinyint DEFAULT 0 NOT NULL, url varchar(128) not null, next_index_time INT NOT NULL, status int(11) DEFAULT '0' NOT NULL, crc char(32) DEFAULT '' NOT NULL, last_modified varchar(32) DEFAULT '' NOT NULL, etag varchar(48) DEFAULT '' NOT NULL, last_index_time INT NOT NULL, referrer int(11) DEFAULT '0' NOT NULL, tag int(11) DEFAULT '0' NOT NULL, hops int(11) DEFAULT '0' NOT NULL, redir integer, origin integer, unique index(url), index(next_index_time), index(hops,next_index_time), index crc (site_id,crc(8))) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=8 RAID_CHUNKSIZE=153600 PACK_KEYS=1; create table urlwords00(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL, lang varchar(2) DEFAULT '' NOT NULL, words longblob, hrefs longblob, unique index(url_id)) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=10 RAID_CHUNKSIZE=153600; create table urlwords01(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL, lang varchar(2) DEFAULT '' NOT NULL, words longblob, hrefs longblob, unique index(url_id)) DELAY_KEY_WRITE=1 RAID_TYPE=STRIPED RAID_CHUNKS=10 RAID_CHUNKSIZE=153600; create table urlwords02(url_id integer NOT NULL, deleted tinyint DEFAULT 0 NOT NULL, wordcount integer, totalcount integer, content_type varchar(48) DEFAULT '' NOT NULL, charset varchar(32) DEFAULT '' NOT NULL, title varbinary(128) DEFAULT '' NOT NULL, txt varbinary(255) DEFAULT '' NOT NULL, docsize int(11) DEFAULT '0' NOT NULL, keywords varchar(255) DEFAULT '' NOT NULL, description varbinary(100) DEFAULT '' NOT NULL,
Re: IFNULL issues??
I would try: select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid from data_table s, other_data_table where s.some_pk=232 order by myid; Although I don't get the purpose of the IFNULL or the order by if you're selecting only a single value of s.some_pk. --jfarr - Original Message - From: BCC [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 10:18 AM Subject: IFNULL issues?? Hi, Maybe someone could take a moment to explain this behavior? I am using IFNULL() in an order by statement to push null values to the end of a table for sorting. For example: mysql select distinct s.some_pk as myid, queryid from data_table s, userdata.queryinfo q where s.some_pk=q.myid order by IFNULL(myid, 999); This works fine (let's ignore for the moment the possibility of null primary key values :) ). However, this does not work: mysql select distinct s.some_pk as myid from data_table s, other_data_table where s.some_pk=232 order by IFNULL(myid, 999); ERROR 1054: Unknown column 'myid' in 'order clause' What gives? What is the difference for IFNULL between these two statements? My first thought was that IFNULL for some reason does not recognize aliases, but then the first statement works. Also, 'pkid' is not ambiguous. I don't get it. Am I missing the obvious? Anyone? Thanks, Bryan - 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: IFNULL issues??
I would try: select distinct s.some_pk, IFNULL(s.some_pk, 999) as myid from data_table s, other_data_table where s.some_pk=232 order by myid; Although I don't get the purpose of the IFNULL or the order by if you're selecting only a single value of s.some_pk. --jfarr The single value is just used to illustrate the structure of the query. I had originally tried using IFNULL as you suggested, but it sorts the table differently than if it is used in the order by. For example, if I have NULL values (as a result of a left outer join), they will always appear at the beginning of my table. Using desc is not an option here. Using IFNULL as you suggest replaces the NULL values properly, but they still stay at the beginning of the table. Looks wierd when your table is ordered as: 999, 999, 999, 1, 2, 3, 4. :) Using IFNULL in the order by fixes this. Bryan - 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 X Win98
Olá, instalei o mysql no Win98 porém o mesmo não está OK. Alguém tem um passo a passo, porque estou com pressa para procurar na web, mas me parece que tem que ter o perl instalado, isto confere? Marcos P.S.: estou usando Win98 e PWS. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication and redirection
OS: RedHat 6.2 on master and slave mySQL:3.23.32 on master and slave Problem: Replication is not working. Symptoms include: * Connecting OK. 'Show slave status' reports nominally. * Position on the log file increments correctly when updates occur on the master. * The tables do not get updated. The web hosting service (20after4.com = recommended - very helpful people there) has performed a replication between two of their servers, using the same master for my replication attempt as the master for theirs. Their replication worked. The main difference is that they did not use redirection and I did. Having the development database on this system, I do not want to replicate directly. So, when we synced I created a local database here (xxxprod), copied the snapshot of the production database to the xxxprod data directory here, then initiated replication. We have tried putting the replication commands in the my.cnf file and using the 'change master to' command, and get the same results. Here is the current my.cnf file. [mysqld] server-id=11 replicate-do-db=xxx replicate-rewrite-db=xxx-xxxprod Anyone have an idea what we may have done wrong? - 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
Lower Level Visibility
Is it possible to observe Handler_read_next and Handler_read_key on a per table basis? If not, could this feature be added? I'm not subscribed to this list, please cc all replies back to this email address. - Pat Wendorf - 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: indexing = NP complete??
On Fri, 15 Jun 2001, Jeremy Zawodny wrote: On Fri, Jun 15, 2001 at 12:53:04PM -0600, Chris Bolt wrote: Is this machine basically dedicated to MySQL? If so, I'd try bumping up the record_buffer to 16 or 32MB and see what that does. I've got it set at 32MB on a server with 1GB of RAM. I'm looking at my-huge.cnf included with mysql 3.23.39 and it has a record_buffer of 1M. Are the example configs included with mysql conservative, and if so, do you have any other suggestions for configurations with lots of ram (768MB in my case)? I don't know that they're conservative. They are good starting points which are optimized for the general case. Most folks aren't going to do lots of heavy indexing as much as they are SELECT queries (hopefully on indexed columns). I don't have any other suggestions at the moment... Jeremy Just for kicks, I bumped my record_buffer up to 64MB; I don't know how much of an effect this will have though. Do you know what buffers are used in indexing? Also, is it faster to insert a load of data, then index, or index as it is being inserted? Cheers, -robin -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878Fax: (408) 349-5454Cell: (408) 439-9951 MySQL 3.23.29: up 1 days, processed 8,464,357 queries (85/sec. avg) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
WNT Perl to Linux MySQL
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
My WNT client node is CACAW8428, ip address 10.9.8.8
I have installed Perl623 with DBI module version, 1.14, DBD-mysql module
version, 2.04
I am running MySQL 3.22.32. on Linux (Red Hat) server.
The host node is search400, ip address 10.9.14.9
The database name is as400.
I have added entries to three MySQL database tables, host, db and user as
such:
host table:
Host Db Select_priv Insert_priv Update_priv Delete_priv
Create_priv Drop_priv
Grant_priv
References_priv Index_priv Alter_priv
CACAW8428 as400 Y Y Y Y Y Y Y Y Y Y
db table:
Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv
Drop_priv
Grant_priv References_priv
Index_priv Alter_priv
% test Y Y Y Y Y Y N Y Y Y
% test\_% Y Y Y Y Y Y N Y Y Y
CACAW8428 as400 paul Y Y Y Y Y Y Y Y Y Y
user table:
HostUser Password Select_priv Insert_priv Update_priv
Delete_priv Create_priv
Drop_priv Reload_priv Shutdown_priv
Process_priv File_priv
Grant_priv References_priv
Index_priv Alter_priv
localhost root 6affb82d35c350d2 Y Y Y Y Y Y Y Y Y Y
Y Y Y Y
localhost.localdomain root Y Y Y Y Y Y Y Y Y Y Y
Y Y Y
localhost N N N N N N N N N N N N N N
localhost.localdomain N N N N N N N N N N N N
N N Edit Delete
CACAW8428 paul 174e380953808cd2 Y Y Y Y Y Y Y Y Y Y
Y Y Y Y
I start mysqld.exe on the Linux server with the --log parameter.
My WNT perl code is:
$hostname = search400;# node name is search400, IP address is
10.9.14.9
$database = as400;
$user = paul;
$password = test01;
$driver = mysql;
$dsn = DBI:$driver:database=$database;host=$hostname;
$dbh = DBI-connect($dsn, $user, $password);
#
if (!$dbh)
{
$msg = Error $DBI::err. Could not connect to database, $dsn.
$DBI::errstr;
print $msg;
exit;
}
I have turned on the TRACE option using the code snippet,
DBI-trace(5);
The results from the trace are,
DBI 1.14-nothread dispatch trace level set to 5
- DBI-connect(DBI:mysql:database=as400;host=search400, paul, )
- connect for DBD::mysql::dr (DBI::dr=HASH(0x1d1caa4)~0x1cbdd8c
'database=as400;host=search400' 'paul' HASH(0x1cbdc9c))
New DBI::db (for DBD::mysql::db, parent=DBI::dr=HASH(0x1cbdd8c),
id=HASH(0x1cbdcfc))
dbih_setup_handle(DBI::db=HASH(0x1cbdd44)=DBI::db=HASH(0x1cbc760),
DBD::mysql::db, 1d1f99c, HASH(0x1cbdcfc))
dbih_make_com(DBI::dr=HASH(0x1cbdd8c), DBD::mysql::db, 536)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Err, DBI::dr=HASH(0x1cbdd8c))
SCALAR(0x1cd2cd8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), State,
DBI::dr=HASH(0x1cbdd8c)) SCALAR(0x1d1cc78) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Errstr,
DBI::dr=HASH(0x1cbdd8c)) SCALAR(0x1cd4250) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Handlers,
DBI::dr=HASH(0x1cbdd8c)
) ARRAY(0x1cbdd14) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Debug,
DBI::dr=HASH(0x1cbdd8c)) 0
(already defined)
imp_dbh-connect: dsn = database=as400;host=search400, uid = paul, pwd =
test01
imp_dbh-MyLogin: dbname = as400, uid = paul, pwd = test01,host = search400,
port = NULL
imp_dbh-MyConnect: host = search400, port = 0, uid = paul, pwd = test01
ERROR EVENT 1130 'Host '10.9.8.8' is not allowed to connect to this
MySQL se
rver' on DBI::db=HASH(0x1cbdd44)
Host '10.9.8.8' is not allowed to connect to this MySQL server error 1130
record
ed: Host '10.9.8.8' is not allowed to connect to this MySQL server
DESTROY ignored for outer handle DBI::db=HASH(0x1cbdd44) (inner
DBI::db=H
ASH(0x1cbc760))
- DESTROY for DBD::mysql::db (DBI::db=HASH(0x1cbc760)~INNER)
DESTROY for DBI::db=HASH(0x1cbc760) ignored - handle not
initialised
- DESTROY= undef at C:/Perl623/site/lib/DBD/mysql.pm line 132.
dbih_clearcom 0x1cbdd44 (com 0x1cbc0cc, type 2) done.
!! ERROR: 1130 'Host '10.9.8.8' is not allowed to connect to this MySQL
serv
er'
- connect= undef at C:/Perl623/site/lib/DBI.pm line 408.
- errstr in DBD::_::common for DBD::mysql::dr
(DBI::dr=HASH(0x1d1caa4)~0x1c
bdd8c)
- errstr= 'Host '10.9.8.8' is not allowed to connect to this MySQL
server'
at C:/Perl623/site/lib/DBI.pm line 409.
DBI-connect(database=as400;host=search400) failed: Host '10.9.8.8' is not
allow
Setting mySQL for a user
Hello all, I'm a newbie to the list and mySQL. So please forgive me. I have no idea what I am doing running a server but i'm doing it! I have a client who needs mySQL and have no idea how to do this. I have a cobalt raq4i. Is there a resource for a real beginner like me to go to with step by step instructions or would anyone on the list be able to offer me some suggestions. TIA Best regards, Sham Cobalt RAQ4i - 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
EXPORTING DATA: OK, this might be a bit general but..
I need some advice on how to export a tables data to import later into Access. This export HAS to be automated (and I'm using VC++ API for MySQL) The problems I'm faced with are (1) Before I can import this data into access I have to create the table in access; I'm familiar with ADO and creating both tables and databases automatically in a C++ proggie, but how can I find out the tables structure - I suppose I can issue a query - DESCRIBE thistable; (2) Adding records to access (ADO will have methods to do this thought I would have thought). (3) The biggest problem I can see is getting the data from a mysql server (where-ever it may be) to reside locally (the computer issuing the command) so that I can then reference it and add it to an access database through ADO. How can I get this data (effectively a select * from to table) to reside on the local machine. Ideally what I want is export * from table to file.txt - I know I'm wishing on a star here. What's the easiest way to do this thought? How can I use a SELECT to send the output to a file?? (4) I will need to insert data into MySQL. I've learnt that I can do this with a LOAD DATA ... But is this issued in the same way as a query is sent to the server. It is essential to add data through the mysql server not an add-on program shipped with MySQL. I have a problem that I don't want the overhead of ODBC, or the reliance on other programs bundled with MySQL because the host I'm connecting to could be Windows, Linux, Unix Sparc etc... Have a think and I'll appreciate any input you have to offer. Please bear in mind that all operations MUST BE AUTOMATED. Thank you for your time. --- Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: How can I get the count field
Dear all! Thanks a lot for attention. I solve my problem using an alias to COUNT. Regards for all! ***Paulino Michelazzo Reply*** Hi all! I need to get the count field in a select instruction like this: (from My-SQL help) SELECT owner, COUNT(*) FROM pet GROUP BY owner ++--+ | owner | COUNT(*) | ++--+ | Benny |2 | | Diane |2 | | Gwen |3 | | Harold |2 | ++--+ I use Cold Fusion with My-SQL and i can get the owner field easy, but the count field IS NOT a really field Anybody can help me? b Paulino Michelazzo - IT Adviser http://www.michelazzo.com.br [EMAIL PROTECTED] - ICQ: 2911392 BOX 31210 - SP/SP - CP: 01309-970 - Brazil/SA - 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: aggravating failure symptoms and steps to remedy them...
Not sure I'll be helpful, but I ran into something similar yesterday. Not exactly sure how I fixed it, but this is what I believe. 1) You should create a virgin data directory per the standard procedures on the production machine (install_db and safe_mysqld). 2) Then, if you have existing data, copy over the existing data directory. -Original Message- From: Peter H. Burris [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 1:49 PM To: [EMAIL PROTECTED] Subject: aggravating failure symptoms and steps to remedy them... I'm a sysadmin who created mysql installs for users on linux x86 boxen; I had to create self-contained, architecture-specific packages to comply with our in-house means of handling software in my department. That took three weeks to fine-tune and distribute and mysql seemed to run out of the box, after some tuning on my build-host. Everything LOOKED good...until the user who called and said, did you change my password? uh, no. Why can't I get on Mysql, then? uh, did you do a ps -ef? nothing happens. well, the host.some.domain.err says the following: 010619 16:39:30 mysqld started 010619 16:39:30 /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 010619 16:39:30 mysqld ended searches on dejanews.com (or 'googlegroups, as they are known) revealed someone had run into this and had been advised to run the installdb script; I did that again, but now it doesn't do me much good, so I try linking over /usr.../mysql/var/mysql to /usr/../,ysql/libexec, but to no visible change in behavior, judging by stdout and the *.err log. What painfully simple, stupid thing am I missing? - 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
WNT Perl to Linux MySQL
Hello,
I am trying to query a MySQL database on a Linux box from a WNT 4.0 SP6
box. I get this error in my WNT perl script:
Error 1130. Could not connect to database,
DBI:mysql:database=as400;host=search400. Host '10.9.8.8' is not allowed to
connect to this MySQL server
Here are the facts:
My WNT client node is CACAW8428, ip address 10.9.8.8
I have installed Perl623 with DBI module version, 1.14, DBD-mysql module
version, 2.04
I am running MySQL 3.22.32. on Linux (Red Hat) server.
The host node is search400, ip address 10.9.14.9
The database name is as400.
I have added entries to three MySQL database tables, host, db and user as
such:
host table:
Host Db Select_priv Insert_priv Update_priv Delete_priv
Create_priv Drop_priv
Grant_priv
References_priv Index_priv Alter_priv
CACAW8428 as400 Y Y Y Y Y Y Y Y Y Y
db table:
Host Db User Select_priv Insert_priv Update_priv Delete_priv Create_priv
Drop_priv
Grant_priv References_priv
Index_priv Alter_priv
% test Y Y Y Y Y Y N Y Y Y
% test\_% Y Y Y Y Y Y N Y Y Y
CACAW8428 as400 paul Y Y Y Y Y Y Y Y Y Y
user table:
HostUser Password Select_priv Insert_priv Update_priv
Delete_priv Create_priv
Drop_priv Reload_priv Shutdown_priv
Process_priv File_priv
Grant_priv References_priv
Index_priv Alter_priv
localhost root 6affb82d35c350d2 Y Y Y Y Y Y Y Y Y Y
Y Y Y Y
localhost.localdomain root Y Y Y Y Y Y Y Y Y Y Y
Y Y Y
localhost N N N N N N N N N N N N N N
localhost.localdomain N N N N N N N N N N N N
N N Edit Delete
CACAW8428 paul 174e380953808cd2 Y Y Y Y Y Y Y Y Y Y
Y Y Y Y
I start mysqld.exe on the Linux server with the --log parameter.
My WNT perl code is:
$hostname = search400;# node name is search400, IP address is
10.9.14.9
$database = as400;
$user = paul;
$password = test01;
$driver = mysql;
$dsn = DBI:$driver:database=$database;host=$hostname;
$dbh = DBI-connect($dsn, $user, $password);
#
if (!$dbh)
{
$msg = Error $DBI::err. Could not connect to database, $dsn.
$DBI::errstr;
print $msg;
exit;
}
I have turned on the TRACE option using the code snippet,
DBI-trace(5);
The results from the trace are,
DBI 1.14-nothread dispatch trace level set to 5
- DBI-connect(DBI:mysql:database=as400;host=search400, paul, )
- connect for DBD::mysql::dr (DBI::dr=HASH(0x1d1caa4)~0x1cbdd8c
'database=as400;host=search400' 'paul' HASH(0x1cbdc9c))
New DBI::db (for DBD::mysql::db, parent=DBI::dr=HASH(0x1cbdd8c),
id=HASH(0x1cbdcfc))
dbih_setup_handle(DBI::db=HASH(0x1cbdd44)=DBI::db=HASH(0x1cbc760),
DBD::mysql::db, 1d1f99c, HASH(0x1cbdcfc))
dbih_make_com(DBI::dr=HASH(0x1cbdd8c), DBD::mysql::db, 536)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Err, DBI::dr=HASH(0x1cbdd8c))
SCALAR(0x1cd2cd8) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), State,
DBI::dr=HASH(0x1cbdd8c)) SCALAR(0x1d1cc78) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Errstr,
DBI::dr=HASH(0x1cbdd8c)) SCALAR(0x1cd4250) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Handlers,
DBI::dr=HASH(0x1cbdd8c)
) ARRAY(0x1cbdd14) (already defined)
dbih_setup_attrib(DBI::db=HASH(0x1cbc760), Debug,
DBI::dr=HASH(0x1cbdd8c)) 0
(already defined)
imp_dbh-connect: dsn = database=as400;host=search400, uid = paul, pwd =
test01
imp_dbh-MyLogin: dbname = as400, uid = paul, pwd = test01,host = search400,
port = NULL
imp_dbh-MyConnect: host = search400, port = 0, uid = paul, pwd = test01
ERROR EVENT 1130 'Host '10.9.8.8' is not allowed to connect to this
MySQL se
rver' on DBI::db=HASH(0x1cbdd44)
Host '10.9.8.8' is not allowed to connect to this MySQL server error 1130
record
ed: Host '10.9.8.8' is not allowed to connect to this MySQL server
DESTROY ignored for outer handle DBI::db=HASH(0x1cbdd44) (inner
DBI::db=H
ASH(0x1cbc760))
- DESTROY for DBD::mysql::db (DBI::db=HASH(0x1cbc760)~INNER)
DESTROY for DBI::db=HASH(0x1cbc760) ignored - handle not
initialised
- DESTROY= undef at C:/Perl623/site/lib/DBD/mysql.pm line 132.
dbih_clearcom 0x1cbdd44 (com 0x1cbc0cc, type 2) done.
!! ERROR: 1130 'Host '10.9.8.8' is not allowed to connect to this MySQL
serv
er'
- connect= undef at C:/Perl623/site/lib/DBI.pm line 408.
- errstr in DBD::_::common for DBD::mysql::dr
(DBI::dr=HASH(0x1d1caa4)~0x1c
bdd8c)
- errstr= 'Host '10.9.8.8' is not allowed to connect to this MySQL
server'
at C:/Perl623/site/lib/DBI.pm line 409.
DBI-connect(database=as400;host=search400) failed: Host '10.9.8.8' is not
allow
Re: Oddity with building 3.23.38 on Tru64 4.0f
On 19 Jun 2001, at 13:36, Sinisa Milivojevic [EMAIL PROTECTED] wrote: Dave FitzPatrick writes: I recently set about upgrading our MySQL install on a Compaq Tru64 4.0f Alpha box from 3.22.25 to 3.23.38. [snip] I edited sql/Makefile and replaced the two occurrences of: -L$(top_builddir)/bdb/build_unix -ldb with $(top_builddir)/bdb/build_unix/libdb.a and the make proceded without further incident. I'm not sure if this is a problem with Compaq's ld or something else, but I found it curious. Definitely looks like Compaq linker bug. Some GNU linker versions have a similar bug. Contact Compaq and submit the info. We have had good experience with a software engineer from Compaq that is maintaining their linker. It looks like the issue is that the linker looks for the shared version of a library in all library directories first, so it's finding /usr/shlib/libdb.so and linking against that. It seems you can pass a parameter of -oldstyle_liblookup to ld that forces it to look for shared libraries and then archives in each directory before moving on to the next. I tried adding --with-mysqld-ldflags='-Xlinker -oldstyle_liblookup' but this ended up putting it in the wrong order on the resultant command to ld so that it sees it as an additional -o parameter and causes an error. Similar problems with defining CXXLDFLAGS. The workaround I finally used successfully was to create a shell script named ld in a directory that is in my path before /usr/bin which contains: #!/bin/sh /usr/bin/ld -oldstyle_liblookup $* D= -- Dave FitzPatrick [EMAIL PROTECTED] Webmaster 978-681-1599 Quantic Communications An MHI Company http://www.quantic.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: Version question: -log no -log ?
- Original Message - From: [EMAIL PROTECTED] To: Mario Kent [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log no -log ? 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: database,sql,query,table 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. You have written the following: I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. - 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: Version question: -log no -log ?
- Original Message - From: [EMAIL PROTECTED] To: Mario Kent [EMAIL PROTECTED] Sent: Tuesday, June 19, 2001 1:40 PM Subject: Re: Version question: -log no -log ? 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: database,sql,query,table 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. You have written the following: I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. - 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
Version question: -log no -log ?
I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. [In order to get this message to post I must work in a few keywords, so I'll just mention that this message has nothing to do with a query or a specific table, but it is in reference to the MySQL database server, which of course speaks 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: EXPORTING DATA: OK, this might be a bit general but..
I'm by no means an authority on this kind of stuff but you could write a portable C program that generates a big ol' SQL script containing INSERT INTO statements :) I can't really think of a fast way to do it since you want to go between MySQL and Access without ODBC and other utilities (I'm not even sure if there is a bulk copy that would work between the two?). That's my two cents worth anyway, Erik David Ayliffe wrote: I need some advice on how to export a tables data to import later into Access. This export HAS to be automated (and I'm using VC++ API for MySQL) The problems I'm faced with are (1) Before I can import this data into access I have to create the table in access; I'm familiar with ADO and creating both tables and databases automatically in a C++ proggie, but how can I find out the tables structure - I suppose I can issue a query - DESCRIBE thistable; (2) Adding records to access (ADO will have methods to do this thought I would have thought). (3) The biggest problem I can see is getting the data from a mysql server (where-ever it may be) to reside locally (the computer issuing the command) so that I can then reference it and add it to an access database through ADO. How can I get this data (effectively a select * from to table) to reside on the local machine. Ideally what I want is export * from table to file.txt - I know I'm wishing on a star here. What's the easiest way to do this thought? How can I use a SELECT to send the output to a file?? (4) I will need to insert data into MySQL. I've learnt that I can do this with a LOAD DATA ... But is this issued in the same way as a query is sent to the server. It is essential to add data through the mysql server not an add-on program shipped with MySQL. I have a problem that I don't want the overhead of ODBC, or the reliance on other programs bundled with MySQL because the host I'm connecting to could be Windows, Linux, Unix Sparc etc... Have a think and I'll appreciate any input you have to offer. Please bear in mind that all operations MUST BE AUTOMATED. Thank you for your time. --- Thanks lots David Ayliffe ([EMAIL PROTECTED]) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Version question: -log no -log ?
At 7:27 PM -0400 6/19/01, Mario Kent wrote: I installed 3.23.38 from source on a linux server, a status simply says: Server version: 3.23.38 Now, I just installed 3.23.39 from source on another linux server and it displays: Server version: 3.23.39-log I want to know what the -log means and how it got in there. -log is added if you start the server with logging turned on. -debug is added if you're running a debugging version of the server with debugging on. -demo is added if the server is running in demo mode [In order to get this message to post I must work in a few keywords, so I'll just mention that this message has nothing to do with a query or a specific table, but it is in reference to the MySQL database server, which of course speaks 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 -- Paul DuBois, [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Testing MySQL 4.0
Hello, MySQL users/hackers: As some of you know, we are currently actively working on MySQL 4.0, and are making some progress. Those who are subscribed to the internals lists get notified of all of our commits and can monitor the progress. If you would like to do a pull from our repository and play with it, follow the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. If it does, although 4.0 is pre-alpha, it is a concern to us - our rule is not to have anything in the central repository that we know crashed - each developers has to run make test before he can push the change, and it has to pass, maybe with the exception of when one developer commits a test case for a bug for some other developer to fix it. So if you can get our tree to crash ( again, we recommend you do not try it on a production system yet :-) ), please report it. The sooner you report it, the sooner we fix it, and the sooner we get 4.0 into production quality release. Some cool things already coded in the current 4.0 tree: REPLICATION: * LOAD DATA FROM MASTER auto-magically sets up a slave ( master tables will be locked in the current code, but this will be fixed in the future once we get hot backup to work) * master is aware of slaves if they register * client has built-in master/slave awareness that get turned on with special client options or through new API calls GENERAL SQL: * count(distinct) is about 30% faster * records can be read on raw MyISAM level with HANDLER command * multi-delete works, but there is a bug we are aware of that we have not fixed yet FULL TEXT: * All I know is that it works much better - Sergei could fill in the details The above list is not comlete - I just typed it from memory. Of course, the new API, SQL syntax, log formats, etc is subject to change since we are still pre-alpha, so do not build applications that depend on it until we have officially blessed them. Also, now is the best time to throw in suggestions, feature requests, etc. Once we've stablized the branch, it would be a lot harder to get us to change things. So, in short, have fun... -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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 running make for MyODBC package
Can someone please confirm that there isn't a problem with the configuration files for MyODBC 2.50.37? When I run make after configure, I get the error: Makefile, line 315: Need an operator make: fatal errors encountered -- cannot continue Line 315 contains: -include $(DEP_FILES) If I comment out 315 and run make again, I get: make: don't know how to make catalog.lo. Stop Please HELP! I've compiled other projects using configure and have never seen this problem before. I am running FreeBSD 3.4 i386, MySQL v3.23.38 database, and unixODBC 2.0.7 - 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: Testing MySQL 4.0
. After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? -RG On Tue, 19 Jun 2001, Sasha Pachev wrote: Hello, MySQL users/hackers: As some of you know, we are currently actively working on MySQL 4.0, and are making some progress. Those who are subscribed to the internals lists get notified of all of our commits and can monitor the progress. If you would like to do a pull from our repository and play with it, follow the instructions at http://www.mysql.com/doc/I/n/Installing_source_tree.html . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. If you have a spare development system, plug in 4.0 binary and try to run your applications on it to see if it will crash. If it does, although 4.0 is pre-alpha, it is a concern to us - our rule is not to have anything in the central repository that we know crashed - each developers has to run make test before he can push the change, and it has to pass, maybe with the exception of when one developer commits a test case for a bug for some other developer to fix it. So if you can get our tree to crash ( again, we recommend you do not try it on a production system yet :-) ), please report it. The sooner you report it, the sooner we fix it, and the sooner we get 4.0 into production quality release. Some cool things already coded in the current 4.0 tree: REPLICATION: * LOAD DATA FROM MASTER auto-magically sets up a slave ( master tables will be locked in the current code, but this will be fixed in the future once we get hot backup to work) * master is aware of slaves if they register * client has built-in master/slave awareness that get turned on with special client options or through new API calls GENERAL SQL: * count(distinct) is about 30% faster * records can be read on raw MyISAM level with HANDLER command * multi-delete works, but there is a bug we are aware of that we have not fixed yet FULL TEXT: * All I know is that it works much better - Sergei could fill in the details The above list is not comlete - I just typed it from memory. Of course, the new API, SQL syntax, log formats, etc is subject to change since we are still pre-alpha, so do not build applications that depend on it until we have officially blessed them. Also, now is the best time to throw in suggestions, feature requests, etc. Once we've stablized the branch, it would be a lot harder to get us to change things. So, in short, have fun... -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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] - 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: unix_timestamp why 0
At 11:04 PM +0200 6/19/01, Attila Soki wrote:
| Paul DuBois [mailto:[EMAIL PROTECTED]]
| When UNIX_TIMESTAMP is used on a TIMESTAMP column, the function will
| receive the value directly, with no implicit
| ``string-to-unix-timestamp'' conversion. If you give UNIX_TIMESTAMP() a
| wrong or out-of-range date, it will return 0.
second test:
c with dates before 1970:
---cut here ---
#include stdio.h
#include time.h
int main(void)
{
struct tm time_check;
time_t xtime;
char str[80];
int ts;
//1969-1-1 00:00:01
time_check.tm_year = 1969 - 1900;
time_check.tm_mon = 1 - 1;
time_check.tm_mday = 1;
time_check.tm_hour = 0;
time_check.tm_min = 0;
time_check.tm_sec = 1;
time_check.tm_isdst = -1;
xtime=mktime(time_check);
strftime(str, 80,%#c,time_check);
printf(time: %s\n,str);
return 0;
}
---cut here ---
and the output:
alpha:/home/atiware# ./ut
time: Wed Jan 1 00:00:01 1969
alpha:/home/atiware#
same in MySql:
mysql select unix_timestamp('1969-1-1 00:00:01');
+-+
| unix_timestamp('1969-1-1 00:00:01') |
+-+
| 0 |
+-+
1 row in set (0.00 sec)
why can C work with this date, and mysql why not?
is this a bug or not?
It's a bug that MySQL performs as documented?
Does that C program work on all platforms where MySQL works?
thanks.
ati
--
Paul DuBois, [EMAIL PROTECTED]
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
I can't install mysql on SUN machine
Hi, I try to install mysql-3.22.32-sun-solaris2.7-sparc on our department's SUN machine and I failed several times. Is it possible to install this database on general user( since I am not the root)? I followed the steps to install( ater I got the directory for mysql-3.22.32-sun-solaris2.7-sparc ): ln -s mysql-3.22.32-sun-solaris2.7-sparc mysql cd mysql scripts/mysql_install_db Then it failed. below is the error information: *** WARNING: Your libc libraries are not 100 % compatible with this MySQL version mysqld should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld demon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. The latest information about MySQL is available on the web at http://www.mysql.com Please consult the MySQL manual section: 'Problems running mysql_install_db', and the manual section that describes problems on your OS. Another information source is the MySQL email archive. Please check all of the above before mailing us! And if you do mail us, you MUST use the ./bin/mysqlbug script! I don't know what is the libcrypt_i.so.1? and I am curious what happend to me. I hope somebody can help me thanks! Cheers Huang
Re: Testing MySQL 4.0
On Tuesday 19 June 2001 17:43, Russell E Glaue wrote: . After you've pulled, run BUILD/compile-pentium (for a lean fast binary) or BUILD/compile-pentium-debug - it will build a binary for you. We run all our MySQLs on the fast SPARCs and PPCs is pentium the only supported hardware right now? No, but we do not have a nifty compile-solaris-sparc-debug in the BUILD directory yet, largely because none of our developers uses a Sparc for their primary development machine. We do have compile-solaris-sparc, though, and even compile-solaris-sparc-purify. Feel free to copy one of those, hack it and send it to us. On most platforms, BUILD/compile-pentium should build a good binary even if the architecture is not a pentium. -- MySQL Development Team For technical support contracts, visit https://order.mysql.com/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sasha Pachev [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Provo, Utah, USA ___/ - 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: I can't install mysql on SUN machine
Someone else asked this question last week, and it turned out that she had downloaded the Sun/SPARC version (as you did) and tried to install it on a Sun/Intel system... If you type uname -a, what does the display tell you ?? zhiheng_huang wrote: Hi, I try to install mysql-3.22.32-sun-solaris2.7-sparc on our department's SUN machine and I failed several times. Is it possible to install this database on general user( since I am not the root)? I followed the steps to install( ater I got the directory for mysql-3.22.32-sun-solaris2.7-sparc ): ln -s mysql-3.22.32-sun-solaris2.7-sparc mysql cd mysql scripts/mysql_install_db Then it failed. below is the error information: *** WARNING: Your libc libraries are not 100 % compatible with this MySQL version mysqld should work normally with the exception that host name resolving will not work. This means that you should use IP addresses instead of hostnames when specifying MySQL privileges ! Creating db table Creating host table Creating user table Creating func table Creating tables_priv table Creating columns_priv table ld.so.1: ./bin/mysqld: fatal: libcrypt_i.so.1: open failed: No such file or directory Killed Installation of grant tables failed! Examine the logs in ./data for more information. You can also try to start the mysqld demon with: ./bin/mysqld --skip-grant You can use the command line tool ./bin/mysql to connect to the mysql database and look at the grant tables: shell ./bin/mysql -u root mysql mysql show tables Try 'mysqld --help' if you have problems with paths. Using --log gives you a log in ./data that may be helpful. - 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: Setting mySQL for a user
You can start with the mysql manual. Then there is Paul DuBois book, people say it's supposed to be good. - Original Message - From: WebNomad Inc. [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, June 20, 2001 4:39 Subject: Setting mySQL for a user Hello all, I'm a newbie to the list and mySQL. So please forgive me. I have no idea what I am doing running a server but i'm doing it! I have a client who needs mySQL and have no idea how to do this. I have a cobalt raq4i. Is there a resource for a real beginner like me to go to with step by step instructions or would anyone on the list be able to offer me some suggestions. TIA Best regards, Sham Cobalt RAQ4i - 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
deleted mysql folder
Hello! I've did an big mistake. I've deleted the mysql-db folder at \var\lib\mysql on my new empty webserver. Then I copied an mysql-db from my local Computer (Win2000) to the webserver. Afterwarts MySQL starts an I could make queries on this internal mysql-db. But I can't make any changes an the data. The user of all files is 'mysql', the group is 'daemon'. I've set the access rights to read/write for the user and the group. What did I worng? What's nessesary to do? Could anyone help me? Thanks alot!!! Stefan Thalheim [EMAIL PROTECTED]
Re: database design
I counldn't agree more with this email that was sent by Jay. I really don't see how tables with only three columns would be an advantage to any systems. On the contrary, I think it would be complicate to select, insert, update and delete information. The ecommerce example that I posted in my page is about a company that sells coins via web. Let's think of product table with 3 fields only: ProductID, Name, and Price. However coins have other informations that would define them, and that are simple attributes. So no reason to separate them in another table or tables I also agree that most books do not cover 'Relational Theory vs Relational Reality' very well. It requires time to learn how to model systems, and I do encourage people to read ,and also identify who does it well and stick with them to understand how they think. Sometimes you come up with an ERD diagram for a system that can have some denormalization. Just keep in mind that some denormalization is necessary depending on the situation. In my ecommerce example, for example, when an order is shipped, I put inside of order information about the chosen shipping address, and as a business rule I do not allow shipped orders to be updated. This way I garantee that all orders will contain the shipping address chosen by the customer in a specific time, I will not have to keep history of addresses in case they are update, and I can allow the customer even delete that specific address from his address book. The same I do for the price of item. Once the order is shipped, the price is placed inside of Orderitems table and no updates are allowed in any line of taht order. The company can change the price of the product in table product and this will not affect old orders. I do agree that this is a simple way of dealing with it. Maybe with product price I should keep a history of changes. However I tried to make it simple for this example. Siomara From: jay downs [EMAIL PROTECTED] To: AAAunderground [EMAIL PROTECTED], [EMAIL PROTECTED] [EMAIL PROTECTED] Subject: Re: database design Date: Tue, 19 Jun 2001 13:54:58 -0400 Alot of it would depend on what exactly you are doing. If you have alot of small tables with only 3 columns(I'm assuming thats what you meant) that can make for a messy server when it starts getting hit by a demand. Also, there are lots of good books on database design. Que generally has made some pretty good books and are available at most borders or barnes noble. In most cases the theory is still the same when it comes to relational databases. One thing that I dont think that most books go over is what I like to call 'Relational Theory vs Relational Reality'. Sometimes using a relational design, causes a significant overhead on the machine and also there are situations when you are obtaining data for the data collecting tables, you might want the opportunity to copy the data over rather than refer to the data table being looked to for this data. This will increase the size of the database, but overcomes situations such as 'What if the part# changes descriptions slightly?' If you're still using the same part#, but different description and you have to refer back to line item (I'm using a basic inventory system layout here), your customer could be looking at one thing and you another and a breakdown in the communication occurs because now the info isnt the same. Alot of times, it is via experimentation that you learn this sort of thing. Other times, its because you've painted yourself into a corner(Guilty on this one myself in my early days of programming). Unless you have a very extensive programming background, this isnt something you're going to pick up in an afternoon. Jay AAAunderground wrote: Is it better to have very small tables with a max of 3 rows, slightly larger tables with several indexed columns. I am designing a database for a medium size company. I certainly plan to expand the business and the database. I want to make sure that I plan the DB correctly from the beginning. I am thinking that most tables will use an autogen primary key. Does anyone have a link to a good source of reading for database design? Maybe recommended dead tree reading? Thanks -Spencer Underground deltree c:\windows /y - 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
Long blob insert
hi Can anyone please help with regards to long blob data insert. I have a data which more than 1mb which MySQL long blob field refuse to insert. However if my data is less than 1mb there if no problem with insert. What parameter do i need to set up.. Please help thanks in advance regards Roslee - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysqld hanging
Nothing of any use ... Sometime between 6/4 and 6/12, it stopped listening... It says it starts, but if you try and connect from the mysql client, it just hangs. ... 010604 22:25:55 /usr/local/mysql/libexec/mysqld: Shutdown Complete 010604 22:25:55 mysqld ended 010604 22:26:58 mysqld started /usr/local/mysql/libexec/mysqld: ready for connections 010612 17:02:25 mysqld started 010612 19:12:33 mysqld started 010612 22:07:32 mysqld started -Original Message- From: Gerald Clark [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 19, 2001 9:34 AM To: Sue Corwin Cc: [EMAIL PROTECTED] Subject: Re: mysqld hanging And the logs say? Sue Corwin wrote: Red Hat 6.2 configured right out of the box ... mysql 3.23.38 . After 15 days of running fine, the server hangs now (even after reboot) and doesn't listen for connections. Any thoughts? Thanks Sue -- Gerald L. Clark [EMAIL PROTECTED] - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - 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
Open Script
Hello, although i am not a newbie to mysql and rdbms i am new to the list and have a problem connecting an application to MySQL. The application is written in OpenScript which was the language of the Toolbook IDE from Assymetrix. Now: although we are able to link the ODBC dll, when we try to declare the functions which the ODBC should be responsible for, errors say the functions are invalid. Is there anybody there able to help in MySQL / OpenScript landscape? If yes: what do we do wrong? thanks in advance, jacek kempski - 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
Syncing two databases
Hi all, I'm new to this list, fairly new to PHP and mySQL and I have a question about syncing two databases. I search all over the web for this, including a win32 version of rsync, but that's not suitable in my case, so here it goes: I have a MySQL database A running on my local machine (Windows 2000, running Apache 1.3.14/php4.0.4pl1) I have another MySQL database B running on my ISP (Linux RedHat, running ZEUS 3.3) I use a tool called phpMyAdmin for managing these databases and it works fine even on a remote connection. I also managed to link a MS ACCESS database to the online MySQL database via ODBC drivers. I'd like to take it one step further and synchronize A with B. Syncing has to work both ways. I can't use rsync as I don't have direct access to the folders where the table files are stored on my ISP. I heard you can use log files to trace transactions and update databases this way by queries but I don't know where these files are located and how to read them. I don't even know if it's the way to do it. Could some one point me in the right direction? Thanks heaps. Marc Aragnou - 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
