Re: [ANN] Blue World Announces Lasso vs PHP White Paper
Another thread pointed out that this runs on doze and Mac, I would venture to say a lot if not most, on this list are *nix people, so the have gotton bad press and have not targeted the correct userbase. Myself, if you spam me, I will not look at you products. spam kills! John On Thursday 07 March 2002 15:34, Todd Williamsen wrote: You think Blue World getting the point yet? Maybe they are thinking twice about spamming mailing lists with their products? Maybe a better target is Microsoft's .NET boards since both products are about the same price -Original Message- From: Jonathan Hilgeman [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 2:00 PM To: '[EMAIL PROTECTED]' Subject: RE: [ANN] Blue World Announces Lasso vs PHP White Paper Ah, the keywords with commercial add-ons. Notice the plurality, as well. I wonder which add-ons and how many total add-ons were considered in making this cost estimate. I also wonder if most of us would even need more than one commercial add-on at most. - Jonathan -Original Message- From: Cathy Cunningham (Blue World Lasso Evangelist) [mailto:[EMAIL PROTECTED]] Sent: Thursday, March 07, 2002 12:37 PM To: Chuck PUP Payne; [EMAIL PROTECTED] Subject: Re: [ANN] Blue World Announces Lasso vs PHP White Paper At 1:19 PM -0500 3/7/02, Chuck \PUP\ Payne wrote: But who wants to pay. Get a clue that's why PHP, PERL, and other Open Source Lang., are widely more used. If you do a true comparison in features, you'll see that a PHP-based solution (with commercial add-ons) costs over three times the cost of Lasso. Then there's also the (TCO) total cost of ownership where due to productivity gains in using Lasso, developers end up saving lots of time (e.g. money) compared with using other tools. Then there's also the fact that when you buy Lasso Professional 5, you're also supporting MySQL AB as each copy purchased puts money in their pockets. And, this is a good thing to ensure the future vitality (and growth) of the MySQL market. It also gives you peace of mind in knowing that you have a commercial license of MySQL, which can help ease liability and other concerns that may otherwise be present in certain organizations who may have concerns using just GPL products. Then there's the issue of quality. With Lasso Professional 5, no stone remains unturned with respect to ensuring Web developers have the highest quality offering both in terms of features, documentation, support materials and more. CC - 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 license problem on Windows
All releases of MySQL were GPL'd, see article: http://www.mysql.com/news/article-23.html John On Wednesday 06 March 2002 15:17, Zengfa Gao wrote: Hi,: I heard that when we use MySQL on windows, we need to pay fees. But I can't find anything on MySQL document to talk about this. Do you know this problem? Thanks a lot! Zengfa __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.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: Generating SQL code?
Take a look at mysqldump John On Tuesday 19 February 2002 12:14, Sterling J. Anderson wrote: I am going to be copying some tables from one DB to another and was wondering if it is possible to have MySQL output the SQL Create Table syntax? I know there are products that will do that (ie. MyPHPAdmin) but can MySQL do it? I'd rather not put anything extra on my server. Thanks. Sterling J. Anderson 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 - 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: When does the timestamp field gets updated?
Only the first TIMESTAMP field gets updated when an updat to a record is made, so if you want to maintain the time a record was created, and when it was updated, use two timestamp fields, the first field will be the time updated, but to do this you must initialize the second timestamp field with NOW() when the record is created. John On Friday 15 February 2002 14:20, George Labuschagne wrote: Hi all, If one uses the timestamp data type for a column inside a table, when executing an update query on said table on a spesific record, will the timestamp column be updated as well or will it retain its first value? Thanks for any info in advance, George mysql, query, 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 - 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: PostgreSQL
On Wednesday 06 February 2002 12:29, Alok K. Dhir wrote: The way I look at it, MySQL gives you a choice of table types, so you can pick the one best suited to the task at hand. For raw speed where you can do without transactions, you can go with MyISAM. Otherwise you have Innobase. I'm not sure where/why db3 fits in, haven't been bothered to look into it yet. I have to agree, I like having the choice, I have some applications that I feel would be hurt by the overhead of transactions. I have other applications that were more difficult to develop without transactions. Now I can have my cake and eat it too. Choice, one of the main reasons I switched to Linux, and now, one of the main reasons I'm happy I chose MySQL in the first place! John On the other points, you are correct. Can't wait for subselects... -Original Message- From: [EMAIL PROTECTED]=20 [mailto:[EMAIL PROTECTED]] On Behalf Of Trond=20 Eivind Glomsr=F8d Sent: Wednesday, February 06, 2002 12:10 PM To: Sinisa Milivojevic Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: PostgreSQL =20 =20 On Wed, 6 Feb 2002, Sinisa Milivojevic wrote: =20 Trond Eivind Glomsr=F8d writes: Vernon A Webb [EMAIL PROTECTED] writes: =20 Anyone know the difference between MySQL and PostgreSQL? =20 PostgreSQL has a lot of features MySQL don't have yet=20 (transactions=20 everywhere, foreign keys, subselects, stored procedures,=20 triggers,=20 etc), while MySQL is heavily optimized for handling big loads of=20 simple SQL. =20 But MySQL has transactions and foreign keys. =20 I said everywhere - you need to use Innobase to get foreign=20 keys, and=20 innobase/db3 to get transactions. =20 --=20 Trond Eivind Glomsr=F8d Red Hat, Inc. =20 =20 - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) =20 To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail=20 [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php =20 - 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: select woes
You must also define the tables you want to 'look' at in the 'FROM' clause On Wednesday 30 January 2002 12:08, George M. Ellenburg wrote: Hello. If anyone has a quick moment, I would appreciate some suggestions with regards to the following select statement: SELECT widget_src FROM widgets WHERE items.foo='abc123' and item_details.item_type='I' and items.item_detail_id=foo.item_detail_id; Upon execution, I'm getting ERROR 1109: Unknown table 'items' in where clause. However, widgets, items and item_details all exist, in the same database. In looking at the MySQL manual, section 6.4.1 (SELECT syntaxt), the following is written: You can refer to a column as col_name, tbl_name.col_name, or db_name.tbl_name.col_name. which I'm doing, and all tables referenced are in the same database. Here's the following output from mysql status: mysql status -- mysql Ver 11.15 Distrib 3.23.44, for -freebsd4.4 (i386) Connection id: 295 Current database: test_database Current user: root@localhost Current pager: stdout Using outfile: '' Server version: 3.23.44 Protocol version: 10 Connection: Localhost via UNIX socket Client characterset:latin1 Server characterset:latin1 UNIX socket:/tmp/mysql.sock Uptime: 5 days 20 hours 55 min 10 sec Threads: 1 Questions: 13038 Slow queries: 0 Opens: 200 Flush tables: 1 Open tables: 7 Queries per second avg: 0.026 -- mysql If anyone has any suggestions or pointers to nudge me in the right direction, I'd be most appreciative. --George Ellenburg - 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
Debian and MySQL
Hi all, I'm doing some experimenting with debian, has anybody created any .deb packages for MySQL? TIA, John - 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
In possibility 1, if the database is truly running on local, you should be able to: a)mysqldump --all-databases all_that_dump.sql b)mysql (logon stuff for remote machine) all_that_dump.sql Because the database is running on local the client (mysql) should also be loaded. Have a great day... John On Wednesday 25 July 2001 13:23, Stefan Hinz wrote: Dear Jay, 1st possibility: a) mysqldump --all-databases all_that_dump.sql b) FTP all_that_dump.sql to remote machine c) [on remote machine:] mysql all_that_dump.sql 2nd possibility: Like above, but using PhpMyAdmin (www.phpmyadmin.com) for writing to (a) and reading from (c) dump file. You won't have to ftp the dump file as you can read it from the local machine. 3rd possibility: ftp the database directories from local to remote machine. You need to have MyISAM tables (extensions: .MYI and .MYD), not ISAM tables if there are different operating systems on those two machines. Datadir for all databases is usually /var/lib/mysql on Linux machines and C:\mysql\data on Windows machines. Regards, -- Stefan Hinz Geschäftsführer / CEO iConnect e-commerce solutions GmbH # www.js-webShop.com www.iConnect.de # Gustav-Meyer-Allee 25, 13355 Berlin # Tel: +49-30-46307-382 Fax: +49-30-46307-388 - Original Message - From: Jay McGarry [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Wednesday, July 25, 2001 4:57 PM Subject: Mysql what's the easiest way to transfer a local database to a remote one? - 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: mysqldump bug during regenerate enum field.
Try quoting (' ') the 0 in your create: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '0' ); -^ You should then get the result you want. Have a great day... John On Monday 18 June 2001 08:54, [EMAIL PROTECTED] wrote: mysqldump regenerates a bad sql statement from a bad initial create table. When you create this table for example (ok it's not a really nice definition): CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default 0 ); desc TESTBADDUMP; ++---+--+-+-+---+ | Field | Type | Null | Key | Default | Extra | ++---+--+-+-+---+ | e_test | enum('0','1') | | | | | ++---+--+-+-+---+ and use mysqldump to regenerate the sql statement, you obtain: CREATE TABLE TESTBADDUMP ( e_test enum('0','1') NOT NULL default '' ); this new declaration is not correct and refused by MySQL. MySQL accept the value '' for insert but not for create table. I'm not sure if it's normal to authorize empty values in enum. If this is normal, the bug is in mysqldump. Originator: Guillaume Fougnies Organization: Profile For You Ltd. MySQL support: licence Severity:non-critical Priority:low Category:mysql Class: sw-bug Release: mysql-3.23.39 (Source distribution) System: Linux db-am-001 2.2.19 #3 SMP lun jun 18 10:53:11 CEST 2001 i686 unknown Architecture: i686 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/i686-pc-linux-gnu/egcs-2.91.66/specs gcc version egcs-2.91.66 19990314 (egcs-1.1.2 release) Compilation info: CC='gcc' CFLAGS='-O6 -mpentiumpro -s' CXX='c++' CXXFLAGS='-O6 -mpentiumpro -s' LDFLAGS='' LIBC: lrwxrwxrwx 1 root root 13 Jun 12 11:15 /lib/libc.so.6 - libc-2.1.3.so -rwxr-xr-x 1 root root 4101005 Sep 3 2000 /lib/libc-2.1.3.so -rw-r--r-- 1 root root 20268874 Sep 3 2000 /usr/lib/libc.a -rw-r--r-- 1 root root 178 Sep 3 2000 /usr/lib/libc.so Configure command: ./configure --with-libwrap --enable-thread-safe-client --enable-assembler --disable-large-files --without-debug --with-mysqld-user=db --without-raid --disable-large-files --prefix=/usr/local/mysql-3.23.39 --localstatedir=/usr/local/mysql_var - 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 - 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.
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 - 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 on large database..
Hello I created a perl script that might help. Because I like to have a full backup of my databases and table backups (I know I can split the full backup, but I'm too lazy ;), I created a perl script that queries MySQL for the table names in the database and then creates a shell script with individual mysqldump commands for each table, after it creates the script it executes it. I think this will help in this case because it is only asking MySQL to dump one table at a time. With 10,000 tables the script will run for a long time, but at least it will be automated. Contact me off the list and I will be glad to send it to you. Have a great day... John Someone please correct me if my idea of how mysqldump runs (i.e. it will still attempt to open all files) is incorrect. On Friday 15 June 2001 13:36, Dan Nelson wrote: In the last episode (Jun 15), SDiZ Cheng said: When i use mysqldump, seems that MySQL will open all the tables in the database. But, what i have is: a database will over 10,000 tables .. I get a Too much opened file error on this.. I think increasing open_file_limit is not possible, because of the limit of the OS itself.. Which OS are you running? You should be able to open 2 files (index+data) on most Unixes with a little tuning. It may be slow, but it should work. Alternatively, you can temporarily move tables 1000 at a time into another directory, mysqldump them, and move them back. - 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: Suggestion For List Management
Jeff, This has been discussed before and I find it easier to just sort by the 'from' header in the message. Check the archives for more disscussion. Have a great day... John On Thursday 22 February 2001 06:08, Jeff Gannaway wrote: Here's an idea for the list memebers and list master Since a lot messages have undescriptive subjects ("Help", "Check This", "What's This?", etc...) I think it would be a good idea to set up the majordomo to add a tag to each subject line like the PHP list does. For instance Subj: Help become: Subj: [MYSQL] Help I've only been on the list for a day and a half. However I'm a memeber of 3 high-volume lists and I can tell that adopting this technique would make my life easier, and presumably other list memebers too. It definitely makes it easier to sort through your e-mails. Anyway, that's my 2 -Jeff Gannaway [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
Re: [win32,mysql v. 3.23.32]Now() function and ERROR in enum
Christian, a DEFAULT value in a CREATE (or ALTER) statement must be a static value, try using a TIMESTAMP field instead. To use 'ERROR' in as an 'ENUM' DEFAULT it must be included in the definition, i.e. ENUM('ERROR','TRUE') Hope this helps... John On Thursday 08 February 2001 09:09, Christian Ribeaud wrote: Hi, I tried the following code: CREATE TABLE news (... published date DEFAULT 'NOW()' NOT NULL, ..., showIt ENUM('TRUE') DEFAULT ERROR, ...); and I was surprised to get an '-00-00' as date after doing a SELECT. I would like that the table put automatically the today's date for every INPUT as default value. What is wrong? Another question, 'showIt ENUM('TRUE') DEFAULT ERROR' did not work but 'showIt ENUM('TRUE','FALSE') DEFAULT FALSE' worked fine. I would like to have something like bits or boolean values in my table. How to achieve this? Thanks for the help and have a nice day. Greetings, christian - 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