InnoDB Question
Hi There, (mysql, query) From the online manual I see: -- innodb_data_file_path Paths to individual data files and their sizes. The full directory path to each data file is acquired by concatenating innodb_data_home_dir to the paths specified here. The file sizes are specified in megabytes, hence the 'M' after the size specification above. Do not set a file size bigger than 4000M, and on most operating systems not bigger than 2000M. InnoDB also understands the abbreviation 'G', 1G meaning 1024M. The sum of the sizes of the files must be at least 10 MB. -- This implies that I have to preguess how large each data file will be. Now, I understand with MyISAM tables that they just grow until they fill up your filesystem or hit some OS limit such as the 2Gb limit in Linux 2.4.X. A few questions: 1) If I setup InnoDB with a 500Mb data file then suddenly run out of space could I: * seemlessly just stack another data file by adjusting my startup options * seemlessly just make the data file larger by changing the file size (i.e. don't add another datafile, just increase the file size) 2) Is there a way to make this more dynamic? * what if a user wants to add a 10Mb blob into my database, but the datafile has only 5Mb of space left for data... (with MyISAM tables they just seem to grow as needed) DSL -- Con te partiro, su navi per mari Che io lo so, no, no non esistono piu Con te io li vivro. (Sartori F, Quarantotto E) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 in left join
Hello mysql team, Server info: Release: mysql-3.23.52 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 1 day 14 hours 59 min 28 sec Threads: 1 Questions: 430690 Slow queries: 11 Opens: 58 Flush tables: 1 Open tables: 38 Queries per second avg: 3.068 System: Linux ic-tm-s-slave-0001.intercaf.ru 2.4.7-10enterprise #1 SMP Thu Sep 6 16:48:20 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc Let's say I have 2 tables: create table eee(cid int not null primary key, l varchar(10)); create table ddd(cid int not null, c int not null, amount int); And some data: insert into eee values(1,'1'); insert into eee values(2,'2'); insert into eee values(3,'3'); insert into eee values(4,'4'); insert into eee values(5,'5'); insert into ddd values(2,1,10); insert into ddd values(2,2,100); insert into ddd values(2,3,1020); insert into ddd values(4,1,1020); insert into ddd values(4,2,1020); insert into ddd values(4,3,1020); The problem is: when I issue the query: select e.cid,sum(d.amount),sum(dd.amount) from eee e left join ddd d on d.cid=e.cid and d.c=2 and d.c=3 left join ddd dd on dd.cid=e.cid and dd.c=3 group by e.cid; I've got: +-+---++ | cid | sum(d.amount) | sum(dd.amount) | +-+---++ | 1 | 0 | 0 | | 2 | 1120 | 2040 | | 3 | 0 | 0 | | 4 | 2040 | 2040 | | 5 | 0 | 0 | +-+---++ while I shuld get quite other result: +-+---++ | cid | sum(d.amount) | sum(dd.amount) | +-+---++ | 1 | 0 | 0 | | 2 | 1120 | 1020 | | 3 | 0 | 0 | | 4 | 2040 | 1020 | | 5 | 0 | 0 | +-+---++ See the difference in the 3rd columns??? -- Best regards, Roman mailto:[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: InnoDB locks disappear
Heikki, Unfortunately it is not that easy. I've set the innodb_lock_wait_timeout to 1 because I want locks to fail quickly, so my program can move on to the next request. In pseudocode: Fetch a bunch of requests with status=unprocessed Try to obtain a lock through a select * from x for update If lock: process If lock-timeout: move on to the next request. This works perfectly except that the locks disappear suddenly for no good reason at all. This takes far longer than the innodb_lock_wait_timeout. On second thought, it doesn't seem to be a timer at all, because the locks don't end sooner if I step through my program in the debugger. I'm not sure, but it seems to take a number of queries to do it. Could InnoDB release locks after x failed attempts to lock the same row? The Inno Lock Monitor is supposed to be useful for debugging, does the report in my original post contain anything that could cause this? I think that the table locks seem fishy since I only use record locks at that point in my code. Could there be something wrong with that? Wouter Zelle --- Part of the INNODB MONITOR OUTPUT -- TABLE LOCK table rosetta/request trx id 0 370099 lock_mode IX RECORD LOCKS space id 0 page no 50 n bits 80 table rosetta/request index PRIMARY trx id 0 370099 lock_mode X Record lock, heap no 1 RECORD: info bits 0 0: len 9; hex 73757072656d756d00; asc supremum.;; Record lock, heap no 2 RECORD: info bits 0 0: len 8; hex 80c5; asc . ...;; 1: Record lock, heap no 10 RECORD: info bits 0 0: len 8; hex 80e8; asc ...Þ;; 1: Suppressing further record lock prints for this page TABLE LOCK table rosetta/rosetta_user trx id 0 370099 lock_mode IX RECORD LOCKS space id 0 page no 53 n bits 288 table rosetta/rosetta_user index P RIMARY trx id 0 370099 lock_mode X Record lock, heap no 220 RECORD: info bits 0 0: len 8; hex 8d28; asc ...(;; 1: --- the default for innodb_lock_wait_timeout is 50 seconds in recent versions. It may be that the manual at www.mysql.com is outdated and claims it is infinite. A lock wait timeout rolls back the whole transaction and releases all locks. You should check the return value of your queries and look if they are reporting lock wait timeouts or other errors. I would really appreciate some help, Wouter Zelle Best regards, Heikki Tuuri Innobase Oy --- Order technical MySQL/InnoDB support at https://order.mysql.com/ See http://www.innodb.com for the online manual and latest news on InnoDB -- - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
problem with date/time column
hi, i have a date/time column. i insert into it using now(). works fine. now i want a query where data/time is either today or yesterday. how should i do it? thanks/erick __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in left join
Roman, try to execute this query: select e.cid,d.amount,dd.amount from eee e left join ddd d on (d.cid=e.cid and d.c=2 and d.c=3) left join ddd dd on (dd.cid=e.cid and dd.c=3) and after that try to group by them manualy. What do you have as result? Best regards, Mikhail. - Original Message - From: Roman Menshikov [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 9:47 AM Subject: error in left join Hello mysql team, Server info: Release: mysql-3.23.52 (Official MySQL RPM) Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 3.23.52 Protocol version10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 1 day 14 hours 59 min 28 sec Threads: 1 Questions: 430690 Slow queries: 11 Opens: 58 Flush tables: 1 Open tables: 38 Queries per second avg: 3.068 System: Linux ic-tm-s-slave-0001.intercaf.ru 2.4.7-10enterprise #1 SMP Thu Sep 6 16:48:20 EDT 2001 i686 unknown Architecture: i686 Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc Let's say I have 2 tables: create table eee(cid int not null primary key, l varchar(10)); create table ddd(cid int not null, c int not null, amount int); And some data: insert into eee values(1,'1'); insert into eee values(2,'2'); insert into eee values(3,'3'); insert into eee values(4,'4'); insert into eee values(5,'5'); insert into ddd values(2,1,10); insert into ddd values(2,2,100); insert into ddd values(2,3,1020); insert into ddd values(4,1,1020); insert into ddd values(4,2,1020); insert into ddd values(4,3,1020); The problem is: when I issue the query: select e.cid,sum(d.amount),sum(dd.amount) from eee e left join ddd d on d.cid=e.cid and d.c=2 and d.c=3 left join ddd dd on dd.cid=e.cid and dd.c=3 group by e.cid; I've got: +-+---++ | cid | sum(d.amount) | sum(dd.amount) | +-+---++ | 1 | 0 | 0 | | 2 | 1120 | 2040 | | 3 | 0 | 0 | | 4 | 2040 | 2040 | | 5 | 0 | 0 | +-+---++ while I shuld get quite other result: +-+---++ | cid | sum(d.amount) | sum(dd.amount) | +-+---++ | 1 | 0 | 0 | | 2 | 1120 | 1020 | | 3 | 0 | 0 | | 4 | 2040 | 1020 | | 5 | 0 | 0 | +-+---++ See the difference in the 3rd columns??? -- Best regards, Roman mailto:[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
synopsis of the problem (one line)
Description: I can't run both the scripts mysql and mysqladmin to set up the root password for my database. How-To-Repeat: When I run this command; ./mysqladmin -u root password 'pegasus' ld.so.1: ./mysqladmin: fatal: libmysqlclient.so.6: open failed: No such file or directory Killed Fix: I don't know how to fix this problem. Submitter-Id: submitter ID Originator:Azrinsyah MIRZA-ASFIAN Organization: MySQL support: [none | licence | email support | extended email support ] Synopsis: Severity: Priority: Category: mysql Class: Release: mysql-3.22.25 (Source distribution) Environment: System: SunOS murang 5.8 Generic_108529-15 i86pc i386 i86pc Architecture: i86pc Some paths: /bin/perl /usr/local/bin/make /usr/local/bin/gmake /usr/local/bin/gcc /usr/ucb/cc GCC: Reading specs from /usr/local/bin/../lib/gcc-lib/i386-pc-solaris2.8/3.2/specs Configured with: ../gcc-3.2/configure --prefix=/usr/local/apps/gcc-3.2 --enable-version-specific-runtime-libs Thread model: posix gcc version 3.2 Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' Configure command: ./configure Perl: This is perl, version 5.005_03 built for i86pc-solaris - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: error in left join
Roman, Wednesday, September 04, 2002, 10:47:18 AM, you wrote: RM Server info: RM Release: mysql-3.23.52 (Official MySQL RPM) RM Server: /usr/bin/mysqladmin Ver 8.23 Distrib 3.23.52, for pc-linux-gnu on i686 RM Copyright (C) 2000 MySQL AB MySQL Finland AB TCX DataKonsult AB RM This software comes with ABSOLUTELY NO WARRANTY. This is free software, RM and you are welcome to modify and redistribute it under the GPL license RM Server version 3.23.52 RM Protocol version10 RM Connection Localhost via UNIX socket RM UNIX socket /var/lib/mysql/mysql.sock RM Uptime: 1 day 14 hours 59 min 28 sec RM Threads: 1 Questions: 430690 Slow queries: 11 Opens: 58 Flush tables: 1 Open tables: 38 Queries per second avg: 3.068 RM System: Linux ic-tm-s-slave-0001.intercaf.ru 2.4.7-10enterprise #1 SMP Thu Sep 6 16:48:20 EDT 2001 i686 unknown RM Architecture: i686 RM Some paths: /usr/local/bin/perl /usr/bin/make /usr/bin/gmake /usr/bin/gcc /usr/bin/cc RM Let's say I have 2 tables: RM create table eee(cid int not null primary key, l varchar(10)); RM create table ddd(cid int not null, c int not null, amount int); RM And some data: RM insert into eee values(1,'1'); RM insert into eee values(2,'2'); RM insert into eee values(3,'3'); RM insert into eee values(4,'4'); RM insert into eee values(5,'5'); RM insert into ddd values(2,1,10); RM insert into ddd values(2,2,100); RM insert into ddd values(2,3,1020); RM insert into ddd values(4,1,1020); RM insert into ddd values(4,2,1020); RM insert into ddd values(4,3,1020); RM The problem is: when I issue the query: RM select e.cid,sum(d.amount),sum(dd.amount) RM from eee e RM left join ddd d on d.cid=e.cid and d.c=2 and d.c=3 RM left join ddd dd on dd.cid=e.cid and dd.c=3 RM group by e.cid; RM I've got: RM +-+---++ RM | cid | sum(d.amount) | sum(dd.amount) | RM +-+---++ RM | 1 | 0 | 0 | RM | 2 | 1120 | 2040 | RM | 3 | 0 | 0 | RM | 4 | 2040 | 2040 | RM | 5 | 0 | 0 | RM +-+---++ RM while I shuld get quite other result: RM +-+---++ RM | cid | sum(d.amount) | sum(dd.amount) | RM +-+---++ RM | 1 | 0 | 0 | RM | 2 | 1120 | 1020 | RM | 3 | 0 | 0 | RM | 4 | 2040 | 1020 | RM | 5 | 0 | 0 | RM +-+---++ RM See the difference in the 3rd columns??? It shouldn't be. Look: mysql select * - from eee e - left join ddd d on d.cid=e.cid and d.c=2 and d.c=3 - left join ddd dd on dd.cid=e.cid and dd.c=3; +-+--+--+--++--+--++ | cid | l| cid | c| amount | cid | c| amount | +-+--+--+--++--+--++ | 1 | 1| NULL | NULL | NULL | NULL | NULL | NULL | | 2 | 2|2 |2 |100 |2 |3 | 1020 | | 2 | 2|2 |3 | 1020 |2 |3 | 1020 | | 3 | 3| NULL | NULL | NULL | NULL | NULL | NULL | | 4 | 4|4 |2 | 1020 |4 |3 | 1020 | | 4 | 4|4 |3 | 1020 |4 |3 | 1020 | | 5 | 5| NULL | NULL | NULL | NULL | NULL | NULL | +-+--+--+--++--+--++ 7 rows in set (0.01 sec) If you group and sum d.amount and dd.amount, what result do you get? -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: Re: Install questions
Matt, Wednesday, September 04, 2002, 12:43:51 AM, you wrote: MTW On Tue, 2002-09-03 at 05:24, Victoria Reznichenko wrote: MTW I just installed MySQL from RPM and can connect to it via shell using MTW the MySQL command, but I can't get anything else to connect to it. MTW MySQL Connection Failed: Can't connect to local MySQL server through MTW socket '/tmp/mysql.sock' (2) Check if MySQL server is running. If so, find where mysql.sock is located (/var/lib/mysql ?) and specify path to the socket for the client. Or you can also create a symlink. MTW Mysql.sock is located at: MTW /var/lib/mysql/mysql.sock MTW and I've ne'er had to change this in php before, and see no place to MTW enter that info in php.ini... any other thoughts? 1. Check [MySQL] section of the php.ini, you can find mysql.default_socket here. 2. You can specify another path to the socket file for the MySQL server with --socket=# mysqld option. 3. You can just create a symbolic link -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: InnoDB Question
David, Wednesday, September 04, 2002, 9:34:55 AM, you wrote: From the online manual I see: DL -- DL innodb_data_file_path DL Paths to individual data files and their sizes. The full directory path DL to each data file is acquired by concatenating innodb_data_home_dir to DL the paths specified here. The file sizes are specified in megabytes, DL hence the 'M' after the size specification above. Do not set a file size DL bigger than 4000M, and on most operating systems not bigger than 2000M. DL InnoDB also understands the abbreviation 'G', 1G meaning 1024M. The sum DL of the sizes of the files must be at least 10 MB. DL -- DL This implies that I have to preguess how large each data file will be. DL Now, I understand with MyISAM tables that they just grow until they DL fill up your filesystem or hit some OS limit such as the 2Gb limit in DL Linux 2.4.X. DL A few questions: DL 1) If I setup InnoDB with a 500Mb data file then suddenly run out of DL space could I: DL * seemlessly just stack another data file by adjusting my startup DL options Yes. DL * seemlessly just make the data file larger by changing the file size DL(i.e. don't add another datafile, just increase the file size) No. DL 2) Is there a way to make this more dynamic? DL * what if a user wants to add a 10Mb blob into my database, but the DL datafile has only 5Mb of space left for data... DL(with MyISAM tables they just seem to grow as needed) Since 3.23.50/4.0.2 you can specify datafile as auto-extending: http://www.mysql.com/doc/en/InnoDB_start.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with date/time column
its select date_sub(now(),INTERVAL 1 DAY) - Original Message - From: Erick Papadakis [EMAIL PROTECTED] To: mysql [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 1:25 PM Subject: problem with date/time column hi, i have a date/time column. i insert into it using now(). works fine. now i want a query where data/time is either today or yesterday. how should i do it? thanks/erick __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Replication (think it works) ;-)
When I do mysql show processlist; I get the following | 18966 | replicate | smtp.lantic.net | NULL | Binlog Dump | 2069 | Slave connection: waiting for binlog update | NULL | +---+---+--++-+---+-+- What worries me is this Slave connection: waiting for binlog update Need I be worried? Is this also right ? The position on both is not the same.(quoted below) 2081006--Master 2139693--Slave mysql show master status; +---+--+--+--+ | File | Position | Binlog_do_db | Binlog_ignore_db | +---+--+--+--+ | ais-rad02-bin.001 | 2081006 | | | +---+--+--+--+ 1 row in set (0.00 sec) mysql show slave status; +---+-+-+---+---+ | Master_Host | Master_User | Master_Port | Connect_retry | Log_File | Pos | Slave_Running | Replicate_do_db | Replicate_ignore_db | Last_errno | Last_error | Skip_counter | +---+-+-+---+---+ | 196.25.84.193 | replicate | 3306| 60| ais-rad02-bin.001 | 2139693 | Yes | radius | | 0 || 0| +---+-+-+---+---+ 1 row in set (0.00 sec) - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
redistributing mysql
Hello I'm writing a small database application on top of mysql. It is almost finished and now I'm thinking about how to distribute it. I am thinking of making two separate distibutions, one without mysql that you can use if the database server is located on a different computer, and a standalone version that has mysql already in it and for which you don't need to worry about setting up a mysql server. Ideally they would have to download and unzip just one file and then it should work already. My questions are: - is this possible? - is this allowed? (my application is probably going to be open-source) - Any tips for making this work? The application is written in java using JDBC and it should be cross-platform but my main concern is getting it working under windows. thanks in advance, Martijn van Iersel __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with date/time column
Hi Erick, i have a date/time column. i insert into it using now(). works fine. now i want a query where data/time is either today or yesterday. how should i do it? Calculate the date required (yesterday and/or today) and then add a time component of midnight (all zeroes) to make up a date-time value. Then it is a matter of performing a WHERE calculated_time column_value. If you are planning on performing date arithmetic you may want to consider moving from date-time format to UNIX format timestamps. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Filemaker database to MYSQL
Has anyone created a plugin or script that will allow me to convert my filemaker database to MYSQL Thanks Brian Leyland - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with date/time column
Instead why don't you try select date_sub(now(), INTERVAL 1 DAY) Karthik. - Original Message - From: DL Neil [EMAIL PROTECTED] To: Erick Papadakis [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 3:09 PM Subject: Re: problem with date/time column Hi Erick, i have a date/time column. i insert into it using now(). works fine. now i want a query where data/time is either today or yesterday. how should i do it? Calculate the date required (yesterday and/or today) and then add a time component of midnight (all zeroes) to make up a date-time value. Then it is a matter of performing a WHERE calculated_time column_value. If you are planning on performing date arithmetic you may want to consider moving from date-time format to UNIX format timestamps. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 Query
Hi Jed,
Though this works,when I tried to insert an inner query in that,it is
giving an error in syntax.Can u please help me in thi matter?I gave the
query as follows:
select TO_DAYS(CURDATE()) - TO_DAYS(select dates from userregistration
where userid like 'abhilas');
Abhilash
Hello, Abhilash,
If you just want the number of days between two dates, you don't need
FROM_DAYS. FROM_DAYS gives you a date. This should be all you need:
Select TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30');
HTH,
Jed
On the threshold of genius, [EMAIL PROTECTED] wrote:
Hi,
My intention is to get the datedifference(in no of days) between
the
current date and a previously entered date which is in a table(of
course
this date is lower in value than the current date).When I used this
query:
select FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'));
Here the problem comes is that it is checks first the year,then the
month
and then the days;and if anywhere it finds that the difference is a
negative
value,it prints as follows:
-+
FROM_DAYS(TO_DAYS(CURDATE()) - TO_DAYS('2001-08-30'))
-+
-00-00 |
-+
So how can I rectify this problem?
Abhilash
-
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail mysql-unsubscribe-
[EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
-
This message was sent using Endymion MailMan.
http://www.endymion.com/products/mailman/
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
foreign keys
Is it in Mysql 4 possible to use foreign keys? If yes, how can I create two tables with foreign keys and use them? Thanks ilyas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with date/time column
Karthik, Instead why don't you try select date_sub(now(), INTERVAL 1 DAY) You suggested this earlier. Are you simply repeating the comment or asking me (cf the original poster) a question? Herewith an assumption that you want to maximise your learning. Obviously I can't answer for Erick. However his statement of requirement is/was where data/time is either today or yesterday. So let's try to understand some terms/specficiations... Take yesterday. To me (in British Summer Time TZ), yesterday began at midnight of 3September, and finished 24-hours later (others can argue the seconds!) - and apologies to anyone for whom my 'today' is already their 'yesterday'. Thus in SQL the term yesterday becomes a BETWEEN comparison. Today could also be considered a BETWEEN, but if all datetimes are in the past, it's not necessary to mention tonight's midnight or even NOW() - but if future dates are included, then BETWEEN it must be. Now let's examine DATE-SUB(). If you'll permit the use of my TZ, here's what it looks like: mysql select now() as MyTime, date_sub(now(), INTERVAL 1 DAY) as TimeBefore; +-+-+ | MyTime | TimeBefore | +-+-+ | 2002-09-04 12:11:32 | 2002-09-03 12:11:32 | +-+-+ 1 row in set (0.01 sec) As you can see, anything that happened during yesterday morning would NOT be included in such an expression. It WILL pick up anything that happened during the last one day/24-hours - both yesterday's and today's 'hours'! Q: Which is 'right'? A: Depends which suits Erick's requirement! Regards, =dn - Original Message - From: DL Neil [EMAIL PROTECTED] To: Erick Papadakis [EMAIL PROTECTED]; mysql [EMAIL PROTECTED] Sent: Wednesday, September 04, 2002 3:09 PM Subject: Re: problem with date/time column Hi Erick, i have a date/time column. i insert into it using now(). works fine. now i want a query where data/time is either today or yesterday. how should i do it? Calculate the date required (yesterday and/or today) and then add a time component of midnight (all zeroes) to make up a date-time value. Then it is a matter of performing a WHERE calculated_time column_value. If you are planning on performing date arithmetic you may want to consider moving from date-time format to UNIX format timestamps. Regards, =dn - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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
data migration
HI ALL, Does anyone know of a simple way of migrating JUST data from a sybase ASE server to mysql ? Please Help :) Thanks Tonino - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
EMS MySQL Export tool released
EMS HiTech company is very glad to announce the NEW software -- the MySQL Export tool! It is a cross-platform (Windows and Linux) product to export your data quickly from MySQL databases to any of 12 available formats, including MS Excel, MS Word, HTML, TXT, and more. MySQL Export includes a wizard, which allows you to set export options for each table visually destination filename, exported fields, data formats, and many more) and a command line utility to export data from tables and queries in one-touch. You can download both versions (for Windows and Linux) from http://www.mysqlexport.com/download.phtml Current version number of Windows edition is 1.0 and this version is fully ready-to-use. Version number of Linux edition is only 0.9 because we have tested it under Linux RedHat 7.2 with KDE interface only. On October 15, 2002 we are planning to release version 1.0. If you like this product you can preorder it right now with a 35% discount. Main MySQL Export features (for both platforms): - Export to 12 most popular formats: MS Excel, MS Word (RTF), HTML, XML, TXT, DBF, CSV, SYLK, DIF, LaTeX, SQL and Clipboard - All MySQL data types supported - Export from tables selected from different databases on one host - Adjustable parameters for each exported table, including: type and name of the result file, fields for export, data formats for all exported fields or for certain fields only, header and footer of the result file, column captions, width and alignment, and specific parameters for export to MS Excel, MS Word (RTF), HTML, XML, TXT, CSV and SQL - Possibility of saving/restoring export parameters to/from a template file - Command line utility to export data using the configuration file, which contains connection options, tables and queries, and template files with all the export options - And more. Please find details and screenshots at http://www.mysqlexport.com/ Note: If you are a registered user of our MySQL Manager, you can purchase MySQL Export with a significant discount. Just send us a written request at [EMAIL PROTECTED] and you will get the MySQL Export with a significant discount (full information is available at http://www.mysqlexport.com/purchase.phtml). We hope you will like our new software. Thank you for your attention. Best Regards, EMS HiTech Team http://www.ems-hitech.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: RE: query crashes 4.03 every time
Matthew, Monday, September 02, 2002, 10:25:40 PM, you wrote: [skip] thd-query at 0x88b3798 = SELECT DISTINCT * FROM b2posts WHERE 1=1 AND MM ID = 124 AND ((post_title LIKE '%%') OR (post_content LIKE '') OR MM (post_title LIKE '%%') OR (post_content LIKE '%%')) AND post_date MM '2002-08-31 14:31:55' AND post_category 0 ORDER BY post_date DESC thd-thread_id=539 [skip] It's a bug. Thank you for bug report. It is fixed in 4.0.4 -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: synopsis of the problem (one line)
Azrinsyah, Wednesday, September 04, 2002, 11:03:30 AM, you wrote: Description: AMA I can't run both the scripts mysql and mysqladmin to set up the AMA root password for my database. How-To-Repeat: AMA When I run this command; AMA ./mysqladmin -u root password 'pegasus' AMA ld.so.1: ./mysqladmin: fatal: libmysqlclient.so.6: open failed: No such file or directory AMA Killed Check where is libmysqlclient.so is located and specify path to the library with LD_LIBRARY_PATH environment variable. http://www.mysql.com/doc/en/Link_errors.html Fix: AMA I don't know how to fix this problem. Release: mysql-3.22.25 (Source distribution) 3.22.25 is outdated. I suggest you to upgrade MySQL server. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: problem with date/time column
Erick, Wednesday, September 04, 2002, 10:55:55 AM, you wrote: EP i have a date/time column. i insert into it using now(). works fine. EP now i want a query where data/time is either today or yesterday. EP how should i do it? Take a look at DATE and TIME functions such as CURDATE(), DATE_SUB(): http://www.mysql.com/doc/en/Date_and_time_functions.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Egor Egorov / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: SELECT DISTINCT w/LEFT JOIN segfault in 4.0.3
User,
Tuesday, September 03, 2002, 7:54:05 AM, you wrote:
Description:
UT A specific query in the format of:
UT SELECT DISTINCT a.*, b.* FROM privatemessage LEFT JOIN b ON (b.x = a.y);
UT Is causing a segfault. This worked fine in the 3.23 series.
Thanks for bug report! It's already fixed.
Here is a patch from Sinisa Milivoevic:
= sql/sql_base.cc 1.131 vs edited =
*** /tmp/sql_base.cc-1.131-30970Tue Sep 3 16:50:57 2002
--- edited/sql/sql_base.cc Tue Sep 3 22:33:13 2002
***
*** 1777,1785
--- 1777,1788
if (item-type() == Item::FIELD_ITEM
((Item_field*) item)-field_name[0] == '*')
{
+ uint elem=fields.elements;
if (insert_fields(thd,tables,((Item_field*) item)-db_name,
((Item_field*) item)-table_name,it))
DBUG_RETURN(-1); /* purecov: inspected */
+ if (sum_func_list)
+ sum_func_list-elements += fields.elements - elem;
}
else
{
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
__ ___ ___ __
/ |/ /_ __/ __/ __ \/ /Victoria Reznichenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net
___/ www.mysql.com
-
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail [EMAIL PROTECTED]
To unsubscribe, e-mail [EMAIL PROTECTED]
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: foreign keys
Ilyas, Wednesday, September 04, 2002, 2:27:27 PM, you wrote: IK Is it in Mysql 4 possible to use foreign keys? Foreign key constarints are supported in InnoDB tables (3.23 and 4.0) IK If yes, how can I create two tables with foreign keys and use them? Take a look at: http://www.mysql.com/doc/en/SEC447.html -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.net http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Victoria Reznichenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.net ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Problem with performance, any way to change the prioority of mysql?
Hi! We are running mysql (latest 3.x) on Windows 2000 Server. For some reasons I am not allowed to use Linux, so I have to fight my way through windows. All is working fine, I use the huge.cnf (server is P4 2.w with 1GB RAM) and performance is good. My problem is: When really huge calculations inside mysql are made, it uses up to 100% cpu, so the Apache Server is not able to deliver any more pages. I was not able to change the priority in Task Manager, neither do I find a switch for mysql to start the service with lower priority. Does someone have an idea how I can force the mysql-service to use priority lower than nornal OR to use a global lower priority inside mysql? Thx for advices, Jo - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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 'enum' column values
Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
urgent ...
Hi, I have did setup for MySQL - Innodb tables. But I am not getting support for row level locks. Whenever I am issuing a update the innodb tables are locking my tables. Please help me whether I need to set any variables in sqld file to get the support for row level locks ??? Regards, Sekhar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) 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: redistributing mysql
Martijn van Iersel wrote: Hello I'm writing a small database application on top of mysql. It is almost finished and now I'm thinking about how to distribute it. I am thinking of making two separate distibutions, one without mysql that you can use if the database server is located on a different computer, and a standalone version that has mysql already in it and for which you don't need to worry about setting up a mysql server. Ideally they would have to download and unzip just one file and then it should work already. My questions are: - is this possible? Yes. - is this allowed? (my application is probably going to be open-source) If your application's open source license is GPL-compatible, yes. Otherwise you need to purchase a commercial non-GPL license from MySQL AB. -Mark -- For technical support contracts, visit https://order.mysql.com/?ref=mmma __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Mark Matthews [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Full-Time Developer - JDBC/Java /_/ /_/\_, /___/\___\_\___/ Flossmoor (Chicago), IL USA ___/ www.mysql.com - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 'enum' column values
* mixo Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? I think you have to do a SHOW CREATE TABLE and parse the output. -- Roger 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: GRANT not working
I believe my problem was that I was omitting the word PRIVILEGES. I was doing just GRANT ALL ON... I also added *.* instead of * and @'localhost' and that got it working. Thanks to all who helped out. Andrew I personally have never had a problem with Redhat. Andrew try this: grant all privileges on *.* to 'amp'@'%' identified by 'blah' (with grant option) ; let me know if it works. - Original Message - From: Matt Hargraves [EMAIL PROTECTED] To: Andrew Pierce [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:22 PM Subject: Re: GRANT not working I believe that your problem is specifically with RedHat. I've ran it on just about every incarnation of Linux from Mandrake to Gentoo. The only one that I have ever had a problem getting MySQL to run on was RedHat 7.x and I've even run it on things like OpenMosix (www.openmosix.org) and Scyld. Tried RedHat versions from 7.0 to 7.3, none of them will run, install any other distro, it works from the start. Don't matter whether it's MySQL 3.x or 4.x, it won't work for me or anyone else I know with RedHat. Hope that helps you with your problem. Matt - Original Message - From: Andrew Pierce [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Tuesday, September 03, 2002 7:06 AM Subject: GRANT not working I have a new installation of RedHat 7.3 and MySql. I had MySql working great on a Mandrake 8.0 installation. Now that I have reloaded this box with RH, I cannot get setup and working. I can run mysql as root and get in. I ran the commands below: grant all on * to amp identified by 'blahdblah'; flush privileges; Now when I run mysql like this: $mysql -u amp -pblahdblah I get the following error: ERROR 1045: Access denied for user: 'amp@localhost' (Using password: YES) I have a sneaking suspicion about the host but I don't know how to fix it. Thanks for any help. Andrew - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql 'enum' column values
At 07:05 AM 9/4/2002, you wrote: Is there a way I can get what the allowed values of an 'enum' coulmn are in mysql? I want to eventually list these values in a list box or something similar? mixo, I can't see an easy way of getting the enum for a particular column. The best I could come up with (and hopefully someone can improve on this) is to execute a MySQLDump -d mydatabaseschema.txt and then use PHP (or whatever language you're using) to find the table.column name, search for enum(, parse out the values and put them into a text file or make an PHP include file out of it. Since this only needs to be done when the enum's have changed, and this process formats it properly for your language, loading the enum list will be quite fast at run time. I thought of using Describe table but that will wrap a long enum list onto several lines in columnar format and is much harder to parse than a MySQLDump. Mike - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
compiling 4.0.3 on OS X 10.2
iH getting the following after issueing ./configure --mandir=/usr/local/share/man/ --with-innodb make ld: Undefined symbols: _tgoto _tputs _tgetent _tgetflag _tgetnum _tgetstr make[2]: *** [mysql] Error 1 make[1]: *** [all-recursive] Error 1 make: *** [all-recursive-am] Error 2 anyone have the correct procedure for comiling under Jaguar? thanks - hcir - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
