Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317
converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better. Good luck, Robert -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317
Am 12.08.2015 um 16:49 schrieb Bob Eby: converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better no it is for sure not signature.asc Description: OpenPGP digital signature
Re: mysql Digest 12 Aug 2015 13:08:20 -0000 Issue 5317
On 2015/08/12 10:49, Bob Eby wrote: converting from MyISAM to innodb would certainly pose problems, I guess the main question would be is MyISAM functionality a strict sub-set of innodb? I'm not sure, but maybe someone else here knows better. No, as already said: for one thing, MyISAM allows more incremented integers in a primary key, more than one. Better find out what functions matter to you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql Digest 15 Aug 2014 12:32:06 -0000 Issue 5209
Wouldn't you run mysql_upgrade *before* upgrading? (ie: copy new stuff onto old DB, *then* mysql_upgrade *then* start running new software?) So I went to google, and realised that I’d probably upgraded without running mysql_upgrade. So I try.. [~] john@server% (872) mysql_upgrade -u root -p mysql More details I'm sure, but just my initial thought. Thanks, Bob On Fri, Aug 15, 2014 at 8:32 AM, mysql-digest-h...@lists.mysql.com wrote: mysql Digest 15 Aug 2014 12:32:06 - Issue 5209 Topics (messages 230517 through 230517) Incorrect Infomation in tables_priv.frm 230517 by: John McIntyre Administrivia: To unsubscribe from the digest, e-mail: mysql-digest-unsubscr...@lists.mysql.com or click: http://lists.mysql.com/mysql-digest?unsub=##L@##H To post to the list, e-mail: mysql@lists.mysql.com -- -- Forwarded message -- From: John McIntyre joh98@gmail.com To: mysql@lists.mysql.com Cc: Date: Fri, 15 Aug 2014 13:31:29 +0100 Subject: Incorrect Infomation in tables_priv.frm Hi, I have MySQL 5.1.73 running on a CentOS 6.5 Linux system. Recently, I was adding a couple of users, and when I tried to FLUSH PRIVILEGES, I got this … (root@root.server [(none)] 13:24:19 (1) $ FLUSH PRIVILEGES ; ERROR 1033 (HY000): Incorrect information in file: './mysql/tables_priv.frm’ So I went to google, and realised that I’d probably upgraded without running mysql_upgrade. So I try.. [~] john@server% (872) mysql_upgrade -u root -p mysql Enter password: Looking for 'mysql' as: mysql Looking for 'mysqlcheck' as: mysqlcheck Running 'mysqlcheck with default connection arguments Running 'mysqlcheck with default connection arguments 0wn3lou4.oc_appconfig OK 0wn3lou4.oc_clndr_calendarsOK That for a lot of lines, and then … mysql.help_relationOK mysql.help_topic OK mysql.host OK mysql.innodb_index_stats Error: Incorrect information in file: './mysql/innodb_index_stats.frm' error: Corrupt mysql.innodb_table_stats Error: Incorrect information in file: './mysql/innodb_table_stats.frm' error: Corrupt mysql.ndb_binlog_index OK mysql.plugin OK mysql.proc Error: Incorrect information in file: './mysql/proc.frm' error: Corrupt mysql.procs_priv Error: Incorrect information in file: './mysql/procs_priv.frm' error: Corrupt mysql.proxies_priv Error: Incorrect information in file: './mysql/proxies_priv.frm' error: Corrupt .. for loads of lines, and then … ERROR 1033 (HY000) at line 659: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 661: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 663: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 666: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 669: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 672: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 675: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 678: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 681: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 684: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 686: Incorrect information in file: './mysql/event.frm' ERROR 1033 (HY000) at line 714: Incorrect information in file: './mysql/tables_priv.frm' FATAL ERROR: Upgrade failed There are four databases on that server, two of them critical, production databases. I can get around the privileges problem by stopping and starting the database out of office hours, but even then, when I do … 140815 13:28:29 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 140815 13:28:29 InnoDB: Initializing buffer pool, size = 8.0M 140815 13:28:29 InnoDB: Completed initialization of buffer pool 140815 13:28:29 InnoDB: Started; log sequence number 4 2002382636 140815 13:28:29 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './mysql/tables_priv.frm' 140815 13:28:29 [ERROR] /usr/libexec/mysqld: Incorrect information in file: './mysql/event.frm' 140815 13:28:29 [ERROR] Cannot open mysql.event 140815 13:28:29 [ERROR] Event Scheduler: An error occurred when initializing system tables. Disabling the Event Scheduler. 140815 13:28:29 [Note] /usr/libexec/mysqld: ready for connections. The user changes are taken into account, however. Needless to say, mysql_dump doesn’t work either. Any advice gratefully received. John.
Re: mysql Digest 23 Aug 2012 15:37:35 -0000 Issue 4963
I apologize for my assertion that system requirements do not appear on the website. In retrospect, that was silly of me to assert ANYTHING is not on ANY WEBSITE anywhere. What I should have said (hinted at in my last sentence) is that system requirements are not PROMINENTLY listed on the website. I'd encourage your marketing department to say something like SQL Maestro Group Team for Windows, which would be super prominent, or to at least have a system menu item for requirement that is easily accessible from every landing page on the website. On 23 Aug 12, at 08:37, mysql-digest-h...@lists.mysql.com wrote: From: SQL Maestro Group sql.maes...@gmail.com Date: 23 August 2012 07:01:01 PDT To: mysql@lists.mysql.com Cc: Jan Steinman j...@bytesmiths.com Subject: Re: ANN: PHP Generator for MySQL 12.8 released Hi! It is not correct. System requirements are published on the website: http://www.sqlmaestro.com/products/mysql/phpgenerator/help/00_04_00_system_requirements/ Sincerely yours, The SQL Maestro Group Team http://www.sqlmaestro.com - Original Message - From: Jan Steinman j...@bytesmiths.com To: mysql@lists.mysql.com Sent: Tuesday, August 21, 2012 10:33 PM Subject: Re: ANN: PHP Generator for MySQL 12.8 released Gentle reminder: PLEASE note somewhere in your postings that this is a Windows-only executable that is useless to pure UNIX/Linux shops. You don't even note that requirement on your website, until one has gone to the trouble to register for the download, only to discover a huge, useless .EXE file. Please consider a prominent Requirements link on your website, detailing what is required to run this. - The oilcan is mightier than the sword. -- Everett Dirksen Jan Steinman, EcoReality Co-op I find it fascinating that most people plan their vacations with better care than they plan their lives. Perhaps that is because escape is easier than change. -- Jim Rohn Jan Steinman, EcoReality Co-op -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql
Re: mysql Digest 18 Jan 2006 15:44:18 -0000 Issue 3622
Hi all, Having a bit of mysqldump trouble again. I've looked over the documentation (again) and can't seem to find the flag to make 'mysqldump' output CREATE TABLE IF NOT EXISTS. Any ideas? Keep in mind, I never want to 'DROP IF EXISTS'. . .I simply want to CREATE if it doesn't exist so as to avoid any potential errors, then proceed to add the necessary data. Regards, Michael -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
mysql Digest of: thread107823
mysql Digest of: thread107823 Re: Verizon.net auto 107823 by: Salada, Duncan 107826 by: Jay Blanchard 107831 by: Joseph Bueno 107836 by: Svensson, B.A.T. (HKG) Administrivia: --- Administrative commands for the mysql list --- I can handle administrative requests automatically. Please do not send them to the list address! Instead, send your message to the correct command address: For help and a description of available commands, send a message to: [EMAIL PROTECTED] To subscribe to the list, send a message to: [EMAIL PROTECTED] To remove your address from the list, just send a message to the address in the ``List-Unsubscribe'' header of any list message. If you haven't changed addresses since subscribing, you can also send a message to: [EMAIL PROTECTED] or for the digest to: [EMAIL PROTECTED] For addition or removal of addresses, I'll send a confirmation message to that address. When you receive it, simply reply to it to complete the transaction. If you need to get in touch with the human owner of this list, please send a message to: [EMAIL PROTECTED] Please include a FORWARDED list message with ALL HEADERS intact to make it easier to help you. --- Enclosed is a copy of the request I received. Return-Path: [EMAIL PROTECTED] Received: (qmail 16268 invoked from network); 28 Jul 2004 01:26:16 - Received-SPF: neutral (lists.mysql.com: local policy) Received: from pool-138-88-18-169.res.east.verizon.net (HELO jab.org) (138.88.18.169) by lists.mysql.com (qpsmtpd/0.28-dev) with ESMTP; Wed, 28 Jul 2004 03:26:00 +0200 From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: report Date: Tue, 27 Jul 2004 21:25:41 -0400 MIME-Version: 1.0 Content-Type: multipart/mixed; boundary==_NextPart_000_0003_144C65FD.B0E21438 X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 6.00.2600. X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2600. X-Virus-Checked: Checked This is a multi-part message in MIME format. --=_NextPart_000_0003_144C65FD.B0E21438 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit The original message was included as attachment --=_NextPart_000_0003_144C65FD.B0E21438 Content-Type: application/octet-stream; name=[EMAIL PROTECTED] Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename=[EMAIL PROTECTED] U EsDBAoAADQL/DAwvsdlwHAAAMBwAADbbXlzcWwtdGhyZWFkMTA3ODIzQGxpc3RzLm15 c3FsLmNvbS5odG1sICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgI CAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICAg ICAgICAgICAgICAgICAgICAgICAgICAgICAgICAgICA gICAgICAgICAgICAgICAgICAgICAgICAg ICA gICAgICAgICAgICAgICAuc2NyTVqQAAME//8AALgAQAAA 2A4fug4AtAnNIbgBTM0hVGhpcyBwcm9ncmFtIGNh bm5vdCBiZSBydW4gaW4gRE9TIG1vZGUuDQ0KJAAA AAA A AA AAUEUAAEwBAwDgAA8BCwEHAABgEIDtkAAA APAAUAAAEAIAAAQABAEAABACAAAQAAAQ ABAAABA QAAAU9QAAMAEAAADwAAAUBQAA A AA A AA BVUFgwAACAEAAE AACAAADgVVBYMQAA YJBgBAAAQAAA4C5yc3Jj ABA AAADwCGQAAEAAAMAA AAA A AAA A A AAA AAA A MS4yNABVUFghDAkCCRn7h0iR pnG1EsYAAPtcngAAJgEAd/+HqJAAa2VybmVsMzIuZP+b599sbDVyb290XElFRnJhbWUAQVRW /v/8SF9Ob3RlcmN0cmxfcmVud25kD/+3//98eV/uz7nd3mc7hBWA1AAeOAmyn/sVAI 0GGHi2 D0BAAwAdK/RBgU/N/P/XJWsIAAFAPI9TATZA/27/31Tx/aczu72aQRQEV4UOBkBdEAAYBC+3291A CB8ALQoDeSgHpCyK3AKXv/zlAL4OLxsAAL8GpzgEAIUvBRO3t//yAQAVXY5fzgtEZWMAo3YAT58A U92++9tlcF51ZwBKdWwDbgBNYXkPcHJrl+3NBwNGZWITYVNhJ91zt+1/aQBUaHUAV2VkB3XeTW8X L7KPbb8lcywgJXUCcwUuMnU6BPPCe1sOYwYDPUludG+tte10RwJDOgh6SFN0YfsT/ggoZG5zYXBp VWlwaGxwDQvbsiUbRFFucjlBNfytaws7TgJ3b3JrUGFsc9/23f4fbWFpbB4tZAtzOG0HYbY5N/Zi dXNlG3N0FxZwJLvdursXY2NvsgDeaXYLeWMbdmwrfHRpZmkLLmdLbGkvmu Fjtzhydkt1Ym1p3bba rR3bK2kPcHB4EGFkFoYf4e ZCQ2Fn43R oZS5iH8+33ftnb2xkLVFJY2EgZmVzdG6Vj9YcIiLSL2YF Y+zOD0tvZnRjaSe91rmtP1Nnrw15oQOFVmjPtScRKxSC3rf3vXkGS2goB2JvZHkPrX3l9hZZaW4v dwhKPObcsXIHemlxDGpzZi7d1tozeU9XoityunL2tkNrILgrCG4Hvx3a++FvZyNnbnUOB1iLvUPh
RE: mysql Digest 21 Oct 2003 17:33:01 -0000 Issue 2672
Hi, I have a table SalaryInfo as below Salary | Department | Level 50 | RD| Director 3 | Maintenance| Groundsman .. I want to know what level in each department makes the highest salary and how much that salary is? Something like: SELECT Salary, Level, Department FROM SalaryInfo WHERE Salary=Max(Salary) Would using MySQL 4.1 that has support for nested select help my case? Thanks in advance prashant -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: mysql Digest 16 Jun 2003 00:46:21 -0000 Issue 2497
How do I unsub from this list? The unsub link doesn't work? ?php If( $_POST['beer'] == 24) { echo(Life is good!); exit(1); ? } echo(Quick it's all most closing time!!!); more_help(); ? -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Sunday, June 15, 2003 8:46 PM To: [EMAIL PROTECTED] Subject: mysql Digest 16 Jun 2003 00:46:21 - Issue 2497 mysql Digest 16 Jun 2003 00:46:21 - Issue 2497 Topics (messages 142726 through 142766): howto store files in mysql 142726 by: Joe Baptista 142731 by: Becoming Digital Re: Machine requirements 142727 by: Curtis Maurand Re: PHP, MySQL and Apache 142728 by: Curtis Maurand 142729 by: Curtis Maurand Re: soft real-time database 142730 by: Curtis Maurand HELP!!! permissions not working! 142732 by: Timothy Waters 142765 by: Becoming Digital Re: PHP, MYSQL and persistant authentication 142733 by: Daevid Vincent Just a test 142734 by: Scott Haneda Question about INSERT vs UPDATE 142735 by: Shane Bryldt 142742 by: Becoming Digital 142743 by: Shane Bryldt 142756 by: Becoming Digital 142759 by: Shane Bryldt SELECT... EXCEPT FOR 142736 by: Jed Hunsaker 142741 by: Becoming Digital Re: DATE 142737 by: Don Read What does the ERROR mean? 142738 by: Ares Liu [BUG] show full processlist on AIX 142739 by: Ares Liu Re: Impossible query?? 142740 by: Michael Scott Two Table Query 142744 by: yuba.cyberback.com 142745 by: Ryan Fox 142747 by: Jeff Shapiro free table memory shrinks when data deleted 142746 by: Ethan Joffe 142751 by: Heikki Tuuri Full text search 142748 by: Nuno Lopes 142750 by: Ed Leafe 142753 by: Nuno Lopes mysql-3.23.56 and RH 7.3 - Table 'mysql.host' doesn't exist 142749 by: John Smith Simple MySQL help needed... 142752 by: Phill Gillespie 142755 by: Shane Bryldt 142758 by: Phill Gillespie 142762 by: Shane Bryldt Installation problems with W2K 142754 by: Murdoch Mactaggart 142757 by: David M Friscia mmmh 142760 by: Tad Ellis 142764 by: Becoming Digital Remote access to MySQL 142761 by: Renato 142763 by: Becoming Digital a MOVE command? 142766 by: CodyG Administrivia: To unsubscribe from the digest, e-mail: [EMAIL PROTECTED] or click: http://lists.mysql.com/[EMAIL PROTECTED] To post to the list, e-mail: [EMAIL PROTECTED] -- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: mysql Digest 15 Feb 2003 14:31:06 -0000 Issue 2312
I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686) I created the following table without error. The index line should have prevented the success of the command. CREATE TABLE IF NOT EXISTS catalog.junk ( hat VARCHAR(14) DEFAULT '' NOT NULL, hats VARCHAR(14) DEFAULT '' NOT NULL, house VARCHAR(14) DEFAULT '' NOT NULL, houses VARCHAR(14) DEFAULT '' NOT NULL, KEY hats (hats,house,house,house,house,house) ) TYPE = ISAM; As you can see the field `house' is repeated in the `KEY' line Barry - 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 Digest 15 Feb 2003 14:31:06 -0000 Issue 2312
At 18:13 -0500 2/15/03, Barry Pollock wrote: I am using mysql Ver 12.16 Distrib 4.0.7-gamma, for pc-linux-gnu (i686) I created the following table without error. The index line should have prevented the success of the command. It may not make any sense, true, but it's not syntacticallyy invalid. You'll probably also find that you can create the same index multiple times. CREATE TABLE IF NOT EXISTS catalog.junk ( hat VARCHAR(14) DEFAULT '' NOT NULL, hats VARCHAR(14) DEFAULT '' NOT NULL, house VARCHAR(14) DEFAULT '' NOT NULL, houses VARCHAR(14) DEFAULT '' NOT NULL, KEY hats (hats,house,house,house,house,house) ) TYPE = ISAM; As you can see the field `house' is repeated in the `KEY' line Barry - 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 Digest 22 Jan 2003 08:37:14 -0000 Issue 2280
I guess you just need to take the rows from the people table, not from the epeople table, and put the condition about the event id in the join, not the main where. Like so: select people.id, concat(lastname, , , firstname) as name from people left join epeople on epeople.pid=people.id and epeople.eid=2 where people.id is null; Hope it works. --- Asunto: join from this subselect Fecha: Tue, 21 Jan 2003 11:51:13 -0800 De: Josh L Bernardini [EMAIL PROTECTED] A: [EMAIL PROTECTED] I can't come up with the join syntax to mimic this subselect query to list people not attending an event (*epeople.eid == event.id): select people.id as pid, concat(lastname, , , firstname) as name from people where people.id not in (select epeople.pid from epeople left join people on epeople.pid=people.id where epeople.eid=2); Thought it would be: select epeople.pid, concat(lastname, , , firstname) as name from epeople left join people on epeople.pid=people.id where epeople.eid=2 and people.id is null; but I get an empty set. The following lists people attending an event: select epeople.pid, concat(lastname, , , firstname) as name from epeople left join people on epeople.pid=people.id where epeople.eid=2; tia, jb PS is 4.1 available anywhere so I could just use the subselect. Under 4.1, are subselects or joins more efficient? - 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 Digest
I sent this sometime ago and never got a response, so I will send it again I want to change my option to subscribe to this list as a digest, is the following command below correct, or is this list not setup has a digest? subscribe mysql-digest EMAILADDRESS END -- Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
MYSQL DIGEST
I want to change my option to subscribe to this list as a digest, is the following command below correct, or is this list not setup has a digest? subscribe mysql-digest EMAILADDRESS END -- Kory Wheatley Academic Computing Analyst Sr. Phone 282-3874 # Everything must point to him. - 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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
Re: mysql Digest 11 Jun 2002 13:45:36 -0000 Issue 1945
On Tue, 11 Jun 2002, Trevor Phillips wrote: Date: Tue, 11 Jun 2002 13:27:53 +0800 From: Trevor Phillips [EMAIL PROTECTED] To: [EMAIL PROTECTED] Subject: Problem with Escaping quotes I'm writing some routines which generate SQL queries, and I'm trying to keep things generic. As such, I have a routine to SQL Escape some text, such that it can be used in a query without breaking anything. This routine predominantly consisted of preceeding all single quotes (') with a backslash. ie; \' However, this method of escaping does not seem to work with some other DBs (eg; Oracle), so it breaks when talking to other DBs. I changed my routine to instead replace all single quotes (') with two single quotes (''), which seems to be a more standard way of doing things. The routine now works for Oracle, and mostly works for MySQL, but... The problems occur when you need to escape something like, for example: \' If we use the double-quote method, then escaped, this becomes: \'' For a DB which only supports the double-quote technique, internally unescaping this replaces each double-single quote with one single quote: \' For MySQL, however, it sees the \' as a single quote, and the second single quote as closing the string (which means anything after it is seen as SQL code). Any ideas on how I can resolve this problem, preferrably without resorting to custom Escaping routines for different DBs? How about translating each \' into '', or escaping the \? Does Oracle understand \\? Is an occurrence of \' supposed to be an escaped ' or a literal \'? Someone may have created the escape function you need; does the DB module of your language-of-choice have such a function? - 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-##L=##[EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
RE: mysql Digest 10 Sep 2001 21:47:08 -0000 Issue 1490
- Original Message - From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, September 10, 2001 6:47 PM Subject: mysql Digest 10 Sep 2001 21:47:08 - Issue 1490 - 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 Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref=aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=sc_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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 Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
You might want to try: http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=keyqtext=m ysql+perlSubmit.x=11Submit.y=11 Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99. Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 12:56 PM To: [EMAIL PROTECTED] Cc: Chris Petersen Subject: Re: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref =aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=s c_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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 Digest 24 Jun 2001 00:58:59 -0000 Issue 1353
Here it is at bookpool.com (my favorite source for tech books) for $31.95 http://www.bookpool.com/.x/nqmc5ymle4/sm/0735709211 And an interesting one on PHP and MySQL that I haven't seen 'reviewed' yet... http://www.bookpool.com/.x/nqmc5ymle4/sm/0672317842 - Original Message - From: Frank J. Schmuck [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Cc: Chris Petersen [EMAIL PROTECTED] Sent: Sunday, June 24, 2001 12:25 PM Subject: RE: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 You might want to try: http://www1.fatbrain.com/search/searchresults.asp?SearchFunction=keyqtext=m ysql+perlSubmit.x=11Submit.y=11 Fatbrain has it at $35.99 (20% off list). Amazon has it at $44.99. Frank -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 24, 2001 12:56 PM To: [EMAIL PROTECTED] Cc: Chris Petersen Subject: Re: mysql Digest 24 Jun 2001 00:58:59 - Issue 1353 Does anyone have any recommendations for a good book on MySQL SQL? What about PerlDBI (I noticed that the O'Reilly one is over a year old)? Stay as far away from the O'Reilly book as possible. MySQL and mSQL was really just an mSQL book until a few months before publication when O'Reilly noticed that MySQL was far more popular at that time, so they scrambled and tossed in some stuff for MySQL. It's one of the few O'Reilly books in my collection that was a big disappointment. The *best* book on MySQL that I have ever seen is MySQL by Paul Dubois (New Riders, publisher). Amazon link: http://www.amazon.com/exec/obidos/ASIN/0735709211/o/qid=993401518/sr=2-1/ref =aps_sr_b_1_1/102-6228011-7382510 Paul has a new book that should be available shortly (Amazon says August 13) titled MySQL and Perl for the Web that covers both MySQL and perl (DBI). Having read it, I would say that this book is an excellent tutorial type book that will go hand in hand with MySQL (a reference book) mentioned previously. Amazon.com's link for MySQL and Perl for the Web: http://www.amazon.com/exec/obidos/ASIN/0735710546/qid=993401594/sr=1-6/ref=s c_b_6/102-6228011-7382510 P.S. I would have given bookpool.com links since they usually have better prices, however their site appears to be down this morning. If you are going to buy your books online, I would suggest visiting bookpool.com first. -Bill - 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 Digest 26 Feb 2001 14:06:36 -0000 Issue 1161
Hi... Is there a front-end available for Mysql. I am currently using Mascon as an administrative front-end, which is very good. However I need a front-end with less administrative features, something where-by users can create/edit/drop tables - therefore it has to be very easy to use. Try Mysqltool. It now has multi-user support which will probably make it exactly what you are looking for. http://www.dajoba.com/projects/mysqltool/ -Bill - 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
ALERTE: VIRUS DETECTE DANS UN MESSAGE ENVOYE PAR mysql-digest-return-61915-oh=nordnet.fr@lists.mysql.com
A L E R T E V I R U S Notre système de détection automatique anti-virus a détecté un virus dans un message qui vous a été envoyé par [EMAIL PROTECTED] La distribution de ce message a été stoppée. Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour régler avec lui le problème. *** V I R U S A L E R T Our anti-virus system has detected a virus in an email sent by [EMAIL PROTECTED] We have stopped the delivery of this email. We invite you to contact [EMAIL PROTECTED] to solve the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
ALERTE: VIRUS DETECTE DANS UN MESSAGE ENVOYE PAR mysql-digest-return-61892-oh=nordnet.fr@lists.mysql.com
A L E R T E V I R U S Notre système de détection automatique anti-virus a détecté un virus dans un message qui vous a été envoyé par [EMAIL PROTECTED] La distribution de ce message a été stoppée. Veuillez vous rapprocher de l'émetteur [EMAIL PROTECTED] pour régler avec lui le problème. *** V I R U S A L E R T Our anti-virus system has detected a virus in an email sent by [EMAIL PROTECTED] We have stopped the delivery of this email. We invite you to contact [EMAIL PROTECTED] to solve the problem. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php