SQL Image Viewer 2.4.0.132 released
SQL Image Viewer helps you retrieve, view, convert and export images and binary data stored in SQL Server, Firebird, MySQL, Oracle, SQLite, and various ODBC-supported databases (e.g. DB2 and PostgreSQL). It supports the following image formats: BMP, GIF, JPG, PNG, PSD, and TIFF, and recognises the following binary file types: PDF, HTML, XML, MP3, AVI, 7Z, BZ2, GZ, RAR, ZIP. More details are available from http://www.sqlimageviewer.com Thank you. Yeoh Ray Mond Associate, Yohz Software http://www.sqlimageviewer.com http://www.yohz.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
moving from 3.23.58 to 5.0.45
Hi are there any doc's on how to migrate DB in 3.23.58 format to 5.0.45 moving from a Fedora Core3 to Centos5.2 server. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
ORDER BY problem
Hi while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP ^R and gold_id=2 ORDER BY Company ASC on mysql server3.23.58 i get company result in ASC order. on mysql server4.1.22 i get non ASC order for companies. is there something on 4.1.22 i missed that effects ORDER BY? Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: ORDER BY problem
- Original Message - Subject: RE: ORDER BY problem Try your query with either back quotes around Company SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP ^R and gold_id=2 ORDER BY `Company` ASC Or no quotes around Company SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP ^R and gold_id=2 ORDER BY Company ASC -Original Message- From: Obantec Support [mailto:[EMAIL PROTECTED] Sent: Friday, July 11, 2008 9:29 AM To: mysql@lists.mysql.com Subject: ORDER BY problem Hi while testing an upgrade from 3.23.58 to 4.1.22 on an FC3 test box SELECT * FROM Contacts WHERE Categories=Services and BusinessCodes REGEXP ^R and gold_id=2 ORDER BY Company ASC on mysql server3.23.58 i get company result in ASC order. on mysql server4.1.22 i get non ASC order for companies. is there something on 4.1.22 i missed that effects ORDER BY? Mark Hi Rolando please only reply to the list. Ok fixed now by either method. I have chosen to leave the off. Thanks Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
u/g to 4.1.22 but now getting mysql_connect() error in php
Hi FC3 test box running mysql 3.23.58 and php 4.3.9 worked ok. (i know they are old but is only a local test box server for testing before i update a live version). installed mysql 4.1.22 and it starts up ok 080626 20:14:58 mysqld started 080626 20:14:59 InnoDB: Started; log sequence number 0 43634 /usr/local/mysql/libexec/mysqld: ready for connections. Version: '4.1.22' socket: '/var/lib/mysql/mysql.sock' port: 3306 Source distribution but now php fails to connect with log error from webserver (apache 2) [client 192.168.1.2] PHP Fatal error: Call to undefined function: mysql_connect() in /home/domain/domain10/web/includes/db_connect.php on line 2 also phpinfo() has no mysql section compared to before the mysql upgrade. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Mysql5.0 Connector J issue with Tomcat 4
Dear Person in charge: We recently replaced mysql 4.0.16 with the free version of mysql 5.0.45 and the access from Tomcat 4 to the database has stopped working. It says java.sql.SQLException: Communication failure during handshake. Is there a server running on 192.168.2.34:3306? The server is in fact running, database can be accessed through command line or other means (including HeidiSql). To ensure that we have the right connector, we have installed Connector J/ 5.1 (replaced connector 3.1). To solve the problem, we have looked into various docs on the web and made sure that enable-named-pipe is on. We believe there are at least two major solution: 1. Since the server.xml works fine with mysql database 4.0.16 or earlier, is it possible that we can download mysql4.0.16? It is currently not available on your website. 2. the Connector /J 5.0 and 5.1 should have taken care of all security issues and everything should have worked work fine, we believe. However, it probably needs some security parameters to set up properly. Could you please provide any specific docs in this regard? Do we also need any secific docs for Tomcat 4 as it may not work with mysql 5.0 (i.e. we may need tomcat 5). 3. Will your Enterprise version work fine with our current server.xml and mysql5.0? [NOTE - our current server.xml works fine with mysql 4.0.16). Look forward to hearing from you soon. Sincerely Vijay Kumar
mysql on a NAS
Hello, We recently moved to a new cluster plattform, setup by one external IT company at present (early stage): 2 XEON computers with a fibre channel link to a Network Storage. The mysql directories are located on the Network storage and mounted into /var/lib/mysql on each machine. So, every machine running an own mysql server, but sharing the directory. The used file system is OCFS (Oracle Cluster File System) When I played with the two servers yesterday (we are not really happy with the performance) I noticed, that the stats of each mysql server are the same. Even if I restart one server, the stats are not amended in any way - if I restart both servers the stats were reset. Now my questions: 1) is this installtion a common practise to share a mysql db with several servers (we might increase the number of servers) 2) is there a better, more performant way, to install mysql in a cluster ? 3) Just your general idea about this setup. Thanks Stefan Stonki Onken -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
DWHS inc.
Hello, Is there anything we can do to help the MySQL project, we are firm believers and would like to contribute in some way. We have a several 100 mps connections and server space. Thank you, Charles DWHS Inc. Manager http://www.dwhs.com http://www.dwhs.com/hostingforum/ https://dwhs.net/secure/ The message is meant to be kept confidential and by reading it you agree not to share it with public media or business competitors of DWHS Web Hosting. For more information on our privacy and regulations please call 866 660 HOST during normal business hours. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Thank you for your email support request
Thank you for your email support request. Our support team will respond with the recommended solution in the quickest time possible, but may be delayed due to the complexity of the problem or volume of requests for support. Once we have replied to your initial question, please be sure to use your e-mail's Reply feature to respond to Technical Support e-mails. By doing so, we keep the information from previous messages, which will assist the Technicians in resolving your problem in a timely manner. If this email is concerning WebDemo or WebInteractive you can call support at 800-200-2766 or you can go to the Live Support link located on the support page of www.linktivity.com. Please be at the machine that is having the problem. If this is a new install then connect from the server. If this email concerns serial numbers or verification keys the matter needs to be handled by our Customer Service Department. To expedite your request, please call them at 800-846-9726, as Technical Support does not respond to these requests. If you are an International Customer the request will be forwarded to our International Sales Representative to handle. Many answers can be found be searching our support site for Technical Notes, Bulletins, and FAQs. http://www.converging-technologies.com/ask.nsf/$$Search - Search Technical Notes http://www.converging-technologies.com/tsfaq.nsf - Search Bulletins, FAQs and more Thank you. Linktivity Technical Support
Adding InnoDB support
Hi 1 user has requested InnoDB support. can i simple get the mysql-max rpm an use yum to install over the existing mysql server. currently running FC3 with default 3.23.58 I would upgrade to 4.x but a lot of user databases and i am worried about loosing data, so for now a quick fix is in order. will my php users be effected or will their php mysql scripts work as before. (php4.3.11 default FC3 rpm) Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding InnoDB support
Hi I found upgrading info but no info on how to install a second mysql server. Mark - Original Message - From: Gleb Paharenko [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, September 12, 2005 12:42 PM Subject: Re: Adding InnoDB support Hello. Usually it is not so simple and many providers install another MySQL server and then clients move their applications to it. See: http://dev.mysql.com/doc/mysql/en/upgrade.html Use an official rpms or binaries from: http://dev.mysql.com/downloads/ Obantec Support [EMAIL PROTECTED] wrote: Hi 1 user has requested InnoDB support. can i simple get the mysql-max rpm an use yum to install over the existing mysql server. currently running FC3 with default 3.23.58 I would upgrade to 4.x but a lot of user databases and i am worried about loosing data, so for now a quick fix is in order. will my php users be effected or will their php mysql scripts work as before. (php4.3.11 default FC3 rpm) Mark -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.21/96 - Release Date: 10/09/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Adding InnoDB support
My original question was how to add InnoDB support to 3.23.58 server. It was suggested that i could run a second server. as i have FC3 i use yum to add / update programs. are you suggesting i get the source , unpack and build the server setting some configs to run it on a different port? Mark - Original Message - From: Hassan Schroeder [EMAIL PROTECTED] To: Obantec Support [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, September 12, 2005 4:51 PM Subject: Re: Adding InnoDB support Obantec Support wrote: I found upgrading info but no info on how to install a second mysql server. `tar xvfz` works the same for one or many :-) Do you have a specific question? -- Hassan Schroeder - [EMAIL PROTECTED] Webtuitive Design === (+1) 408-938-0567 === http://webtuitive.com dream. code. -- No virus found in this incoming message. Checked by AVG Anti-Virus. Version: 7.0.344 / Virus Database: 267.10.22/97 - Release Date: 12/09/2005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ANN] DBManager Professional 3.0.2 Released
We are pleased to announce the release of the DBManager Professional 3.0.2. This version is a major bug fix with a small number of new features: Fixes a.. Fixed Load Dump which affected most of the engines supported b.. Closing Workspace with other Views opened will close all views c.. Fixed COUNT(*) for Interbase/Firebird (Option UNCHECKED in Preferences) d.. Fix Set FIELD NULL doesn't show SQL/DDL to Output e.. Fixed CTRL-C, CTRL-V in the Datasheet View f.. Fixed Remove Server Message (Relationships not part of the catalog data) g.. Fixed Table Form (when field is hidden removes also the Label) (*) h.. Fixed DBCC Messages when it is too long (MSSQL/Sybase) generates exception (*) i.. ALTER TABLE ADD COLUMN (Now field is quoted to allow reserved words/SQLITE) j.. Added Conversion Table for MSAccess = MySQL. Many changes were made in the Conversion Table k.. Fixed Import Text Wizard (NULL values not reset for each record) l.. Fix Server Connect with a default database (SQLite) m.. Create/Alter/Drop Procedure referenced by Database.Procedure (MySQL) n.. Fixed Dump Wizard Exports Only Data Correctly (SQL/DDL) o.. Fixed Number Format for MySQL WebService (Datasheet StatusBar) p.. Dump Tables now Dumps triggers of the selected table correctly (SQLITE) q.. When Dumping only one table do not dump objects that are not table children New Features a.. Servers Sorted By Name b.. Added Role Support for Interbase/Firebird (Server Properties) c.. Added Collation Connection for MySQL (Server Properties) d.. Add Support for Table Collation (Datasheet View) e.. Add support for other character separators in Text Import Wizard f.. Added support for Sybase (*) (*) Enterprise Edition Only You can download the Freeware Edition directly from our website at http://www.dbtools.com.br/EN/downloads.php. What is DBManager Professional DBManager Professional is windows application to manage MySQL, PostgreSQL, SQLite, Interbase, Firebird, Xbase Tables, MSAccess (*), MSSQL Server (*), Sybase (*) and Oracle (*) (avaible soon) database servers. Here is some of its features: - Manage all objects in the database: tables, indexes, stored procedures, functions, user types, users, groups, etc - Create and Execute Queries in Query Designer and Query Builder - Import and Export data from/to MSAccess, ODBC, MSExcel, Paradox, Clipper, Dbase, FoxPro, Text Files, XML - Diagram Designer to build your database structure visually (*) - Form Builder (*) - Database Compare Wizard to keep two or more database syncronized (*) - Task Builder to automate data processing (*) - Database Documenter - Report Builder creates reports in HTML format (*) - Server, Database and Table Monitoring (*) - Web Script Generator creates scripts in PHP and ASP - True MDI Tab Views compatible with .NET - and much more (*) Enterprise Edition Only For the full list of features please check http://www.dbtools.com.br/EN/dbmanagerpro/ Best Regards, DBTools Software http://www.dbtools.com.br -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
[ANN] Webyog releases FREE edition of SQLyog
Hello, Webyog, the creator of SQLyog - the most popular GUI for MySQL has released SQLyog v4.0. Starting from v4.0, SQLyog is available in two editions: SQLyog and SQLyog Enterprise. SQLyog is FREE for personal and commercial use. SQLyog contains all features of SQLyog Enterprise - except the following Power Tools: * HTTP / SSH Tunneling - Manage MySQL even if your ISP disallows remote connections * Data Synchronization - Zero install MySQL Replication * Schema Synchronization - Keep test and production databases in sync * Notification Services - Send formatted resulsets over email at regular intervals * ODBC Import - Wizard driven painless migration to MySQL Please visit the following link for to view the feature comparison between SQLyog and SQLyog Enterprise. http://www.webyog.com/sqlyog/featurematrix.html Thanks for your attention! Webyog Support http://www.webyog.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23
Description: When I do 'SHOW PROCESSLIST' on my server currently, the line for 'system user' is as follows: ++-+--+-+-++---+--+ | Id | User| Host | db | Command | Time | State | Info | ++-+--+-+-++---+--+ | 495801 | system user | none | NULL| Connect | 4294967211 | Reading master update | NULL | A few minutes before, and for a number of days, it had been displaying very low ( 100s) numbers. Subtracting the number from 2 ** 32 gives what looks like a sensible figure, so this may be a signed/unsigned bug. How-To-Repeat: Hard to say; MySQL has been up for approaching 64 days - not sure if that's significant. Doing SLAVE STOP; SLAVE START; has no effect. Fix: Unknown (except to work around it as shown above). Submitter-Id: submitter ID Originator:root Organization: NewsNow Publishing Limited MySQL support: none Synopsis: SHOW PROCESSLIST displays incorrect slave latency in MySQL 3.23 Severity: non-critical Priority: medium Category: mysql Class: sw-bug Release: mysql-3.23.49 (Source distribution) (actually debian 'woody' stable distribution package) Environment: Machine: Dell PowerEdge 2650 2xPIV Xeon 2.6 GHz w. PERC 3/Di RAID controller OS: Debian GNU/Linux 'woody/stable' distribution, with custom-compiled kernel 2.4.24. System: Linux craven 2.4.24dell-poweredge-2650 #1 SMP Tue Jan 6 13:09:17 GMT 2004 i686 unknown Architecture: i686 Some paths: /usr/bin/perl /usr/bin/make /usr/bin/gcc /usr/bin/cc GCC: Reading specs from /usr/lib/gcc-lib/i386-linux/2.95.4/specs gcc version 2.95.4 20011002 (Debian prerelease) Compilation info: CC='gcc' CFLAGS='' CXX='c++' CXXFLAGS='' LDFLAGS='' LIBC: lrwxrwxrwx1 root root 13 Apr 24 2003 /lib/libc.so.6 - libc-2.2.5.so -rwxr-xr-x1 root root 1153784 Apr 8 2003 /lib/libc-2.2.5.so -rw-r--r--1 root root 2391002 Apr 8 2003 /usr/lib/libc.a -rw-r--r--1 root root 178 Apr 8 2003 /usr/lib/libc.so Configure command: ./configure --prefix=/usr --exec-prefix=/usr --libexecdir=/usr/sbin --datadir=/usr/share --sysconfdir=/etc/mysql --localstatedir=/var/lib/mysql --includedir=/usr/include --infodir=/usr/share/info --mandir=/usr/share/man --enable-shared --with-libwrap --enable-assembler --with-berkeley-db --with-innodb --enable-static --enable-shared --enable-local-infile --with-raid --enable-thread-safe-client --without-readline --with-unix-socket-path=/var/run/mysqld/mysqld.sock --with-mysqld-user=mysql --without-bench --with-client-ldflags=-lstdc++ --with-extra-charsets=all Output from 'mysqladmin extended-status': +--++ | Variable_name| Value | +--++ | Aborted_clients | 1451 | | Aborted_connects | 83 | | Bytes_received | 2448140052 | | Bytes_sent | 2623702023 | | Com_admin_commands | 0 | | Com_alter_table | 14 | | Com_analyze | 0 | | Com_backup_table | 0 | | Com_begin| 0 | | Com_change_db| 3 | | Com_change_master| 1 | | Com_check| 0 | | Com_commit | 0 | | Com_create_db| 1 | | Com_create_function | 3 | | Com_create_index | 0 | | Com_create_table | 2 | | Com_delete | 822956 | | Com_drop_db | 0 | | Com_drop_function| 0 | | Com_drop_index | 0 | | Com_drop_table | 0 | | Com_flush| 2 | | Com_grant| 2 | | Com_insert | 444024318 | | Com_insert_select| 21493 | | Com_kill | 0 | | Com_load | 0 | | Com_load_master_table| 0 | | Com_lock_tables | 0 | | Com_optimize | 0 | | Com_purge| 0 | | Com_rename_table | 2 | | Com_repair | 0 | | Com_replace | 7483359| | Com_replace_select | 0 | | Com_reset| 0 | | Com_restore_table| 0 | | Com_revoke | 0 | | Com_rollback | 0 | | Com_select | 256096442 | | Com_set_option | 6 | | Com_show_binlogs | 0 | | Com_show_create | 0 | | Com_show_databases | 28 | | Com_show_fields | 2306 | | Com_show_grants | 0
Re: Excel file
Please read the attached file. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: To Re-write complex query with JOINS
hi vijay, You can use order by group by commands in the queries.. Thanks and Regs, - Aman. On Mon, 19 Jan 2004, Vijay Patel wrote: Hello friends, I have a problem with one of the JOIN query here. Below is a brief description of the problem. tablename : test RecordId EffectiveDate othertableidvalue - - 1 2004-01-10 1 10 2 2004-01-20 1 20 3 2004-01-20 2 70 4 2004-01-10 2 80 Now I want to use a single SQL query to find a result where there exist one record for each unique othertableid where the record selected for the othertableid should be the recent one with regard to EffectiveDate. That is from the above records, I want to select Records with RecordId = 2 and 3 because they are the recent one for othertableid = 1 and 2 respectively. Please be sure that I want to retrive all fields including RecordId. The result should not depend on any other fields but EffectiveDate only. I am using MySQL 4.0.12 and it does not support SUBQUERIES which is now given support in latest MySQL edition. But I have read in the manual of MySQL that any SUBQUERY SQL statement can be written with proper JOINS. Can you help me. Vijay. __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: 4.1.1 not an update or upgrade of 4.1.0
Hi, I also faced this kind of error in sub query, any solution for this?: -Aman. On Mon, 19 Jan 2004, Director General: NEFACOMP wrote: Hi group, I have discovered this morning a strange behaviour of MySQL 4.1.1 When the SUB-SELECT contains more than one field, it does not work (this works very well with 4.1.0 ) For example: SELECT field1 FROM Table1 WHERE (field2,field3) IN (SELECT field2,field3 FROM Table2) The above query works as expected with mysqld-nt.exe 4.1.0 (on WinXP) but it does not work with mysqld-nt.exe 4.1.1 (on WinXP). This problem causes unexpected results as the recordset comes empty (on 4.1.1) while it comes with rows with 4.1.0 and no error is returned!!! Maybe it is a known bug! Thanks, __ NZEYIMANA Emery Fabrice NEFA Computing Services, Inc. P.O. Box 5078 Kigali Office Phone: +250-51 11 06 Office Fax: +250-50 15 19 Mobile: +250-08517768 Email: [EMAIL PROTECTED] http://www.nefacomp.net/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: converting tables MyISAM to InnoDB
Unknown Sender [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Hi, I recently upgraded from MySQL v3.23 to MySQL 4, and converted my tables from MyISAM to InnoDB by using the ALTER TABLE command. I did this for 16 tables. I know that MyISAM creates seperate data/index files for each table and InnoDB uses a single file for data and log. My question is, once Ive converted the tables from MyISAM to InnoDB, can I delete the .MYI and .MYD files for the tables ? Thanks Those files should be deleted automatically by MySQL, but if you still got them, you can delete them, but make sure you really moved to InnoDB type before deleting them. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
InnoDB file data size against MyISAM files data sizes
Hello, My HDD is running low and I MyISAM tables are keep crashing... I think that converting to InnoDB will be more stable, but what about the data files sizes? convertion to InnoDB will need more or less disk space than MyISAM? -thanks, Eli -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting a particular row from GROUP BY
Michael Shuler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] What would be the rules for deciding if id 3 should be fr or de? if 'en' does not exist, then it does not matter which language is returned (even be the first available language in the rows order in the DB). But would be also helpful to know if say I want to retrieve one language from this order: en, fr, de. -thanks, Eli -Original Message- From: ighen [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 4:50 PM To: [EMAIL PROTECTED] Subject: Getting a particular row from GROUP BY Hello, I have the next table (the primary key is id+language): || id || language ||title|| --- 1 de{some_text} 1 en{some_text} 1 fr{some_text} 2 fr{some_text} 2 de{some_text} 2 en{some_text} 3 fr{some_text} 3 de{some_text} I want to group all rows with the same id, and sort the grouped rows with the title field of the 'en' language. I use the next query: SELECT * FROM table GROUP BY id,language HAVING language='en' ORDER BY title; This returns: 1, en 2, en How can I do that it will return me the following? 1, en 2, en 3, fr I also tried the next query: SELECT * FROM table GROUP BY id,language='en' ORDER BY title; but it returned me twice the id 1 and 2. thanks in advance, -Eli --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Getting a particular row from GROUP BY
Thanks for your help, but it is not giving the result. The problem is that when you make GROUP BY id then the row representing the group is the first row in the group, and adding ORDER BY ... after the group by part just orders the grouped rows, but the grouped rows are in the wrong languages, therefore ordering is not solving the problem. I need to get a row from the middle of the group and not the first default row in the group. Might be the solution lies in HAVING clause, but then I got 2 rows with same id... -thanks, Eli Michael Shuler [EMAIL PROTECTED] wrote in message news:[EMAIL PROTECTED] Try: SELECT * FROM table GROUP BY id ORDER BY language=en DESC, language DESC (I didn't set up your table on my sever to test this but this should work) See http://www.mysql.com/doc/en/Sorting_rows.html down at the bottom near the user comments someone is doing the same kind of thing. Hope this helps! Mike -Original Message- From: ighen [mailto:[EMAIL PROTECTED] Sent: Sunday, December 21, 2003 5:34 PM To: Michael Shuler Subject: Re: Getting a particular row from GROUP BY - Original Message - From: Michael Shuler [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: 'ighen' [EMAIL PROTECTED] Sent: Monday, December 22, 2003 1:18 AM Subject: RE: Getting a particular row from GROUP BY What would be the rules for deciding if id 3 should be fr or de? if 'en' does not exist, then it does not matter which language is returned (even be the first available language in the rows order in the DB). But would be also helpful to know if say I want to retrieve one language from this order: en, fr, de. -thanks, Eli Hello, I have the next table (the primary key is id+language): || id || language ||title|| --- 1 de{some_text} 1 en{some_text} 1 fr{some_text} 2 fr{some_text} 2 de{some_text} 2 en{some_text} 3 fr{some_text} 3 de{some_text} I want to group all rows with the same id, and sort the grouped rows with the title field of the 'en' language. I use the next query: SELECT * FROM table GROUP BY id,language HAVING language='en' ORDER BY title; This returns: 1, en 2, en How can I do that it will return me the following? 1, en 2, en 3, fr I also tried the next query: SELECT * FROM table GROUP BY id,language='en' ORDER BY title; but it returned me twice the id 1 and 2. thanks in advance, -Eli --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.554 / Virus Database: 346 - Release Date: 12/20/2003 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
RE: Excel 2 CSV into phpMyAdmin
I save as CSV (MS-DOS). I then import into MySQL using SqlYog and the following parameters: Line terminator \r\n Delimiter , Strings Optionally surrounded by That gives me a successful import every time. I have tried other variations and achieved same results as you - 'jumbled' data. Greg -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Tuesday, 23 September 2003 15:29 To: [EMAIL PROTECTED] Subject: Excel 2 CSV into phpMyAdmin is there a trick to saving Excel spreadsheets into a CSV format that will import into MySQL or phpMyAdmin reliably? my CSV files get jumbled up, if they load in at all. There is a bug i have been told concerning columns that contain alphanumeric and just numeric fields. I use Excel [office 2k version] on Win2k to create my CSV files. and the target apps and database is phpMyAdmin 2.5.3-rc3 with MySQL 3.23.56 -- Regards, Carmoda [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: A little SQL query help
- Original Message - From: Nils Valentin [EMAIL PROTECTED] To: Obantec Support [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Sunday, July 27, 2003 2:05 AM Subject: Re: A little SQL query help Hi Mark, 2003 7 27 06:09Obantec Support : Hi I have a database supplied to me that was excel but now uploaded to mysql. (the data is out of my hands.) i need to search for 1 of 2 categories against 3 fields with user inputted data. example Categories=Lessor , searchtype = BusinessCity searchdata = (user input) $sql = SELECT * FROM Contacts WHERE Categories=\$calltype\ and $searchtype LIKE \$searchdata%\; there are 2 Categories supplied via 2 different pages which load the same form and use call to determine Category. $searchtype is 1 of 3 text boxes against which searchdata is passed. I need to get all columns hence the * but need $searchdata to try and match all of text in the $searchtype column. using the LIKE \$searchdata%\ gets me only from start of test i.e. Fin will find Financial from Financial Text Widgets but not Financial from Widgets Text Finance How about LIKE \$%searchdata%\ ? I am not sure if you really need the $ there. If it is for php than it might be o.k there, but for MySQL I believe you don't need it in your case (if understood correctly what you want to do ;-) So please try also this : LIKE '%searchdata%' Best regards Nils Valentin Tokyo/Japan using php as my chosen language. Mark -- --- Valentin Nils Internet Technology E-Mail: [EMAIL PROTECTED] URL: http://www.knowd.co.jp Personal URL: http://www.knowd.co.jp/staff/nils Hi I was sure i tried the %string%. I need the $ since $searchdata is a php variable. \%$searchdata%\ works just fine. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
A little SQL query help
Hi I have a database supplied to me that was excel but now uploaded to mysql. (the data is out of my hands.) i need to search for 1 of 2 categories against 3 fields with user inputted data. example Categories=Lessor , searchtype = BusinessCity searchdata = (user input) $sql = SELECT * FROM Contacts WHERE Categories=\$calltype\ and $searchtype LIKE \$searchdata%\; there are 2 Categories supplied via 2 different pages which load the same form and use call to determine Category. $searchtype is 1 of 3 text boxes against which searchdata is passed. I need to get all columns hence the * but need $searchdata to try and match all of text in the $searchtype column. using the LIKE \$searchdata%\ gets me only from start of test i.e. Fin will find Financial from Financial Text Widgets but not Financial from Widgets Text Finance using php as my chosen language. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Cannot get example to work
Hi http://www.mysql.com/doc/en/Fulltext_Search.html the create and insert of data went ok but when i do SELECT * FROM articles WHERE MATCH (title,body) AGAINST ('database'); i get SQL-query I am using RH8.0 and mysql 3.23.56 and php 4.3.2 I connect ok and my other code works SELECT term, explanation FROM Glossary ORDER BY term ASC What i am ultimately working to is a typical A to Z set of links to anchors. I have the code working to display the Terms and Explanations with anchor for each new letter but now i am trying to select from the terms based on A-Z. All letters will be displayed but some letters do not have terms will not have links. Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
diff between 7.2 and 8.0 rights?
Hi I have 2 servers both with 3.23.56-1 installed via rpm's proteus2 which is running RedHat 7.2 on 1 cpu and has been in use for over 1 year works as expected. [EMAIL PROTECTED] [/var/lib/mysql]# mysqladmin status Uptime: 515357 Threads: 1 Questions: 2412696 Slow queries: 782 Opens: 19654 Flush tables: 1 Open tables: 64 Queries per second avg: 4.682 [EMAIL PROTECTED] [/var/lib/mysql]# however proteus2a 1week old and running RedHat 8.0 (dual cpu) [EMAIL PROTECTED] mysql]# mysqladmin status mysqladmin: connect to server at 'localhost' failed error: 'Access denied for user: '[EMAIL PROTECTED]' (Using password: NO)' [EMAIL PROTECTED] mysql]# I have read documentation and tried various but cannot seem to resolve the problem. Any ideas? Mark -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Data query by date
Hi all. I have spent some time studying the manual and previous posts, trying to get a grip on the whole date_format issue... I am VERY new to MySQL having been converted from an ADO/DAO environment with Access dBs... Where I am having trouble is coming up for a syntax to SELECT * FROM tableA WHERE ba_id_num = 'ABC12345' AND ba_make_date = '2003-25-2' ba_id_num = varchar(8) ba_make_date = datetime Even though I can see several rows from the CC, the query returns 0... I have unsuccessfully attempted to use the DATE_FORMAT function also. Any hint of where I am going wrong would be greatly appreciated ;-) Jeff - Before posting, 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 Installation
I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -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
RE: MysQL Installation
Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 2:17 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MysQL Installation Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -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 - Before posting, 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 Installation
I know this is OT a bit, but now I need to either re-compile PHP to get mysql to work or maybe upgrade from an RPM since I am on 4.1.2 - or do I need to do this at all? Even at rpmfind.net is seems hard to distinguish what it is I need. Is there anyway to get a 'complete' PHP rpm somewhere? Thanks! -Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 5:12 PM To: '[EMAIL PROTECTED]' Cc: [EMAIL PROTECTED] Subject: RE: MySQL Installation Oh, okay. Sorry about that, the RedHat rpm's puts the admin binary in the server package, but MySql.com has it in the client's: $ rpm -qlp MySQL-client-3.23.53a-1.i386.rpm | grep admin /usr/bin/mysqladmin /usr/share/man/man1/mysqladmin.1.gz sql, query ~Kelly W. Black PS IN the future check out http://www.rpmfind.net/ -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 12:51 PM To: Black, Kelly W [PCS] Cc: [EMAIL PROTECTED] Subject: RE: MysQL Installation Well hells bells! Would that be the 'Client programs (i386) (2.3M)' mentioned on the download page? :) Thanks, Mike -Original Message- From: Black, Kelly W [PCS] [mailto:kblack05;sprintspectrum.com] Sent: Friday, November 08, 2002 2:17 PM To: '[EMAIL PROTECTED]'; [EMAIL PROTECTED] Subject: RE: MysQL Installation Mysqladmin is seperate rpm ~K Black -Original Message- From: SpyProductions Support Team [mailto:support;spyproductions.com] Sent: Friday, November 08, 2002 11:13 AM To: [EMAIL PROTECTED] Subject: MysQL Installation I just installed the most recent version of MySQL with an RPM (through webmin interface), but it doesn't seem to have installed a mysqladmin.anyone know why? :) Thanks! -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 - Before posting, 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: rename database
From what I heard, yes. If you stop MySQL, then rename the dir/database. It may work. Worked for me (did it about 3 months ago). HTH, Ricardo. - Original Message - From: Jorge Martinez [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, September 27, 2002 11:57 AM Subject: rename database Exists any way to rename a database ? Thanks Jorge 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
error updating table
Hi, we have an application that connect to MySQL via MyODBC. Sometimes, we have this error: [TCX][MyODBC] Got error 5 from table handler and MySQL drops. When it comes back up, it first gives an error with BDB tables (the type we use): 020911 15:10:17 bdb: page 0: illegal page type or format 020911 15:10:17 bdb: PANIC: Invalid argument then I have to start over. Versions are: MySQL-Max-NT-2.23.52 MyODBC-2.50.39 TIA, Ricardo. - Before posting, 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 statement problem
Shouldn't this come up with a list of names from each table that matches? SELECT * FROM table1,table2 WHERE table1.name = table2.name; Does anyone see anything wrong with this query? It keeps giving me an empty set - but there definitely matches. I even did a LIKE instead of =, takes longer, but comes out the same. I triple checked the data, and it is *exactly* the same! Help! Thanks! :) -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
SQL Sorting
Hi, I work with cyrillic alphabet (Russian) and found that SQL query ORDER BY towns with Russian entries doesn't work properly. Is there an easy way to resolve this and sort rows by Russian alphabet? Vyacheslav - Before posting, 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
SQL-query
Hello, A real SQL-query works well SELECT MAX(date_value) AS date_value FROM dates WHERE version_id='2' But the problem is, that I can't get a value of another column, i.e. the row in a table consists of three columns - id, date_value and version_id The task - to get a value of id column where date_value is the biggest while version_id is preset Thank you - Before posting, 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 transition
Hello, everybody! Please give me a hint at some resources about synchronization of two MySQL databases, situated in different places. The point is, I have my local and providers' versions of the same database. And need to synchronize them at a daily basis with the least traffic involved. Thanks, Vyacheslav. - Before posting, 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
Determining character set from table data
Hello, I am wondering if there is any way to determine the character set used for data in a table. For example, a single database has 10 tables, six with 'latin1' characters, two with 'cp1251' characters, and two with 'greek' characters. The character_set variable is set to 'latin1' on this database because most of the data is in the latin1 character set. However, the client programs will want to display the data from the non-latin1 tables correctly when they do a SQL query. Is there a way to determine the type of character used for data in a table apart from the character_set variable? Thanks, Matt Culbreth - Before posting, 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
Announcing native .NET provider to MySQL
Hello, This is an announcement of a new product that will interest some of you. I have completed work for the first Beta release of a native ADO.NET provider to MySQL. You can find the details at http://www.mattculbreth.com/eidmysql. Thank you, Matt Culbreth - Before posting, 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
databases under users dir
Hi Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Before posting, 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: databases under users dir
Hi Thanks for the tip! it works fine. Now all i need to do is modify my create database code to use $HOME/mysql and make symbolic link Mark -- Obantec Support www.obantec.net WebHosting and Domains Nominet UK Tag Holder - Original Message - From: Andreas Frøsting [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Saturday, March 09, 2002 10:07 PM Subject: RE: databases under users dir Hi, Anyone know if its possible to have mysql databases under $HOME for users. I am running RH7.2 and have virtualhosts under apache 1.3.22 so i am hoping i can put databases under each user account in order to control (quota's) etc. You can put them under each users homedir and symlink to them. I've used that method a couple of times where I had some pretty large tables taking up too much space on a particular partition. Remember to shut down mysql before moving the databases and remember to preserve ownership and rights to the files. :wq //andreas http://phpwizard.dk (in Danish only) - Before posting, 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
Getting Data From One Table Based On Another - Agh!
Looking through the MySQL stuff online, I still can't come up with a statement to pull data from one table based on data from another. Table1 Contains: orderid Table2 Contains: orderid otherfield1 otherfield2 I want to get the data from table 2 based on a matching orderid first pulled from table1. Anyone have any ideas? Either this isn't able to be done, or I am (and I'm not) not advanced enough to understand the SQL statement needed. So far, I have tried a number of them that haven't worked. Any ideas? Thanks! -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
RE: Is The MySQL Mailing List On Crack?
Jeremy Zawodny wrote : I'm getting duplicate messages separated by several hours. Am I alone in this, or are others seeing it too? Jeremy -- Jeremy D. Zawodny, [EMAIL PROTECTED] Technical Yahoo - Yahoo Finance Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 685-5936 MySQL 3.23.47-max: up 5 days, processed 189,890,555 queries (402/sec. avg) Hi, Me too... I am even seeing one week old messages ! Me too! I'm even seeing messages from *next* week! -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
Granting Privileges
Hey there! Hoping someone can help me out when it comes to granting privileges for a user in MySQL. Basically, I have granted privileges to a user who I do not want to have root access and I want to minimize his access to only his databases. Using the MySQL manual, I granted him basic privileges for just such. However, he is asking for privileges to be able to use CHECK, ANALYZE, and REPAIR table. He has privileges for OPTIMIZE. So I'm not sure how to grant him these privileges, or whether that would open a big security whole in MySQL if I did. I've checked the manual, but it is rather unspecific about these things. In fact, I couldn't find what References_priv represented privileges for either, so maybe that is it? Thanks for any and all help! -Mike [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
User/database permissions
This is going to be a very basic question, so please excuse me. I have a MySQL server running, but when I added users I inadvertently gave them all permissions to everything. They can all access every one else's databases and make what ever changes they want and even delete. How do I lock it down where they only have rights to their own? I don't even know how to view what users are there, much less change their rights. I've been looking in the documentation online, but it seems to assume that I know more than I do. Thank you in advance. -MWhitaker - Before posting, 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
many connection errors
MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Warning: MySQL Connection Failed: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Couldn't Connect To Database Server This effected all users since they all use 'localhost' I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors sample 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) ends I did a search and found the info to clear the error but i am not sure what causes it. Mark - Before posting, 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: many connection errors
Hi i have php4.0.6 Can't see why i should change apache as i don't see that as the problem. is it a know issue in MySQL that 3.23.45 fixes? if not i don't upgrade everytime there is a new release. The server has been up since april this year and this is first time the error has happened. It is prob caused by more of my users having php forums. What i need to find out is root of the cause Mark - Original Message - From: [EMAIL PROTECTED] To: Support [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Friday, November 30, 2001 3:50 PM Subject: Re: many connection errors Support wrote: MySQL 3.23.39 RH6.2 Apache 1.3.12 2 weeks ago mysql stopped with the following example error.(repeated on other sites that use mysql on my server) Warning: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Warning: MySQL Connection Failed: Host 'localhost' is blocked because of many connection errors. Unblock with 'mysqladmin flush-hosts' in /home/domain/domain42/web/drwho/php/common.php on line 18 Couldn't Connect To Database Server This effected all users since they all use 'localhost' I ran 'mysqladmin flush-hosts'. Looking at the logs i see quite a few errors sample 011130 6:08:54 Aborted connection 58760 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 6:18:20 Aborted connection 56028 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:06:12 Aborted connection 71509 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) 011130 9:12:56 Aborted connection 66603 to db: 'modderz_db1' user: 'modderz' host: `localhost' (Got timeout reading communication packets) ends I did a search and found the info to clear the error but i am not sure what causes it. Mark Hello, Have you ever tried MySQL 3.23.45, php 4.0.6 and Apache 1.3.20 ? Edward. - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail [EMAIL PROTECTED] To unsubscribe, e-mail [EMAIL PROTECTED] Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
New flavor of Got an error reading communication packets
Greetings - I believe I have a new flavor of this error. I am running mysql Ver 11.13 Distrib 3.23.36, for redhat-linux-gnu (i386) on Red Hat Linux release 7.0 (Guinness) Kernel 2.4.2-2smp on an i686 (the database host) I have two machines running mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) on Red Hat Linux release 7.0 (Guinness) Kernel 2.2.16-22 on an i586 (the client hosts) The 586 boxes are running ICRADIUS version 0.17b build Feb 1 2001 which (used to) connect through a Perl DBI interface. One of the client machines is connected on a full duplex 100MBps Fast Ethernet network, the second of the two is connected through dual frame relay T1's to our router and then through the Fast Ethernet. When RADIUS starts it continually tries to connect to the 686 database host. The .err file starts generating error messages similar to: 011127 4:39:31 Aborted connection 9961 to db: 'radius' user: 'radius' host: `radius2.aix.cc' (Got an error reading communication packets) Now for the new stuff -- If I attempt to connect to the database host via the mysql command line client with the same username and password it works from both the local and remote hosts. I can see the databases, select the desired database and run queries with expected results. I also use the database host to authenticate my mail users using pam_mysql and this works fine. This machine is running mysql Ver 11.12 Distrib 3.23.32, for redhat-linux-gnu (i386) on Red Hat Linux release 7.0 (Guinness) Kernel 2.2.19pre16ext3 on a 2-processor i686 It is connected on the same switched Fast Ethernet. I've searched the mail archives and found some answers indicating that the full duplex connection is the issue. This setup has worked perfectly for over a year on the existing hardware. We first started having issues with the remote machine (the one on the other end of the frame relay T1's) In an effort to fix that machine I restarted mysql on the database host (several times :-/ ) After the first restart the local machine (the one directly connected to the Fast Ethernet) started generating the same errors. To my knowledge the server and client configurations have not changed. I have power cycled all the affected equipment (database host, client host and the intervening Fast Ethernet Switch) all with no effect. I also tried upping the connect_timeout and net_read_timeout, again, with no effect. In an effort to get my system back up I tried ftp'ing the radius database files from the database host to the client host and use the local server. The local server also generates pretty much the same message: 011127 5:02:25 Aborted connection 211 to db: 'radius' user: 'radius' host: `localhost' (Got an error reading communication packets) I'm pretty sure that I *DON'T* have a network problem as I can telnet among the hosts just fine and I can connect to the web interface of ICRADIUS and see the same sad story in the logs. The ftp of some very large files (52MB and 92MB) ran normally with a consistent 840K/s transfer rate. I'm running out of rabbits here and didn't find the fix in the 223 hits that searching the mail list archives for Error reading communication packets will return. I thought I'd submit this to the list for your consideration. My users will be waking up soon and the are *NOT* going to be happy that they can't login. *ANY* assistance would be greatly appreciated. I'd prefer not to recompile this stuff...after all it worked before and restarted just fine *THREE* times last week...but I won't go into that 1/2g Please reply to [EMAIL PROTECTED] as I am not subscribed to the list. A virtual beverage to the clever person with the clue. Thank you, in advance, for your assistance. Regards Mike PS. I'm off to deja.com to try the same search as suggested in one of the posts to this list. - Before posting, 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
3.23 and 3.22 API incompatibles?
I'm using Free Pascal 1.0.4 and MySQL 3.22.32 System is RedHat 7.2 (but the same is on RH 6.2) The Free Pascal package contains mysql unit which makes able to pipe sql queryes from pascal to mysql. All worked fine until 3.22.32. But in 3.23.xx (tested on 3.23.38 and 3.23.44),the error with incorrect mysql_close(sock) is occuring after ever call to mysql. Below is gdb calls stack: (gdb) run Starting program: /home/mazay/dl-utils/uncalls From 18:00 to 18:59 total records add to UNCALLS : 0 Program received signal SIGSEGV, Segmentation fault. __libc_free (mem=0xb07d1) at malloc.c:3136 3136malloc.c: No such file or directory. in malloc.c (gdb) where #0 __libc_free (mem=0xb07d1) at malloc.c:3136 #1 0x40039722 in my_no_flags_free () from /usr/lib/mysql/libmysqlclient.so.10 #2 0x4003676d in mysql_close () from /usr/lib/mysql/libmysqlclient.so.10 #3 0x0805ba1e in mysql_query () #4 0x0805c591 in mysql_query () #5 0x0804862f in mysql_query () (gdb) Anybody have any ideas? Maybe errors caused by changes in mysql C API ? Will thanks for your advice. - Before posting, 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 the Installation of MySql 3.23 on Linux 7.1
hai , We are tryin to get the MySql running on a Intel based Linux box, with microkernel 2.2.16. when i try to install using the MySql using the RPM, it threw a message stating tht the installation is finished and the mysqladmin is not copied. when we try to uninstall the same, i get a message that the package is not installed. at this point i tried to reinstall the MySql and i got a message that Mysql 3.23 is already installed. it would be helpful if anyone could throw some light on this.. regards Support - Before posting, 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
Changement de l adresse du support Technique.
Madame, Monsieur, Suite à notre rachat par VERIO Leader Mondial de l'hébergement cette adresse n'est plus valide. Pour joindre notre support vous devrez désormais suivre cette procédure : 1/ envoyez vos emails à l'adresse suivante : « [EMAIL PROTECTED] » 2/ Le sujet devra être libellé de la façon suivante : - Formule Platinum : vous devez mettre le nom principal de votre formule dans le sujet précédé par «DSI-». Ce nom est celui qui apparaît en haut de votre tableau de bord platinum ou lorsque vous tapez en SSH/Telnet «uname -n». Par exemple « DSI-adar43.adarweb.com ». - Serveur dédié : indiquez en majuscule l'identifiant du serveur précédé de «DSI-». Par exemple « DSI-COB549 », « DSI-LINUX1608 », « DSI-SUN00665 »... - Autre formule : indiquez simplement le nom de domaine concerné précédé de « DSI- ». Par exemple « DSI-verio.fr ». Vous recevrez alors une réponse indiquant que votre email a été pris en compte. Chaque requête reçoit alors un numéro qui vous permet de suivre son évolution et qui donne au service technique de meilleures possibilités de suivi, dans le but de vous apporter un service plus efficace. Cordialement, VERIO France - Before posting, 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: Unknown column in 'where clause' error
Hello, Your field(column) is a CHAR and therefore the parameter to it should be in single quotes: Change your query to: SELECT * FROM customers WHERE Customer_No = 'CMET3558539239' * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: 18 June 2001 19:44 To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, 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: Unknown column in 'where clause' error
You are using PHP. Well PHP is not ASP :-) clever and you can enclose your variable in single quotes as in: $customer_select=SELECT * FROM customers WHERE Customer_No = '$id'; Hope this helps. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: 18 June 2001 20:14 To: '[EMAIL PROTECTED]' Subject: RE: Unknown column in 'where clause' error Thanks for the suggestions, but this is actually a variable that is passed via a URL. For example: http://localhost/cus-lookup.php?id=CMET3558539239 Then in the code it looks like this: $customer_select=SELECT * FROM customers WHERE Customer_No = $id; How can I 'put quotes around' a variable? Ryan Shrout -Original Message- From: Bill Elvis Gibbs [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 3:20 PM To: Shrout, Ryan Subject: RE: Unknown column in 'where clause' error WHERE Customer_No = 'CMET3558539239' you need to use quotes when trying to reference data that is not 100% numeric, otherwise MySQL thinks you are trying to reference a column. Bill Elvis Gibbs goEbusiness.com - putting e-motion in your business email - [EMAIL PROTECTED] work - 301-668-5090 cell - 301-748-6938 -Original Message- From: Shrout, Ryan [mailto:[EMAIL PROTECTED]] Sent: Monday, June 18, 2001 2:44 PM To: '[EMAIL PROTECTED]' Subject: Unknown column in 'where clause' error Here is the full error I am getting when running the query included: Failed Query: SELECT * FROM customers WHERE Customer_No = CMET3558539239 1054 : Unknown column 'CMET3558539239' in 'where clause' Here's the problem, I know that Customer_No exists. I can see it in the database. This code works fine when using a Customer_No such as 15 or 153, something numeric. The field itself is defined as a CHAR (50). Any ideas what is causing this? It happens with every Customer_No in this format and gives the same error. Ryan Shrout - Before posting, 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
MySQL 4 and WINDOWS
Hello, Has anyone managed to compile the BETA version of MySQL 4 for Windows? I have downloaded the source however, it appears to be for LINUX or UNIX. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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
Pound (£) Symbol and MySQL
Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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: Pound (£) Symbol and MySQL
Hello All, I have tried the settings as suggested in this FORUM like using htmlentities etc... however, my pound sign in the database is displayed as: ú Any more tips help etc... -Original Message- From: technical Support [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 21:53 To: [EMAIL PROTECTED] Subject: Pound (£) Symbol and MySQL Hello All, When I insert data submitted via a web page into mySQL, the pound (£) symbol gets converted to something like 8916. I am using PHP and Apache on the Server side. Has anyone else encountered this strange problem? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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
Oracle 2 MySQL
Hello, Does anyone know of any tool that will take an ORACLE database and port it to mySQL? * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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: Fulltext Strange Results...
Do you know roughly when this will be done. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * -Original Message- From: Sergei Golubchik [mailto:[EMAIL PROTECTED]] Sent: 20 May 2001 22:44 To: technical Support Subject: Re: Fulltext Strange Results... Hi! On May 20, technical Support wrote: I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? It's still in todo. Regards, Sergei -- MySQL Development Team __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, http://www.mysql.com/ /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ - Before posting, 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
Fulltext Strange Results...
Hello, I did the following query against my indexed table: select * from indexed_table where match(indexed_col) against ('oracle +sybase +london') It returned 16 rows of which only 4 rows included all words. I then did: select * from indexed_table where match(indexed_col) against ('+oracle +sybase +london') It returned 4 rows which is the desired or expected results. I then did: select * from indexed_table where match(indexed_col) against ('+oracle +sybase +london -oracle') Nothing was returned. I then went on to do this: select * from indexed_table where match(indexed_col) against ('oracle and sybase and london') This returned over 200 rows rather than the expected 4. This was done against mySQL v4.0. Can someone please explain the ambiguities. Joe B. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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
Fulltext and phrases
I have just done this: select * from indexed_table where match(indexed_col) against ('visual basic') This returns rows with either visual or basic. I read phrase searching was allowed in mySQL v4.0? Can someone please advise. * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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
Fulltext and 2 to 3 character words...
Hello, I have just downloaded version 4 of mySQL. Compiled it with ft_min_word_len = 0. However, my a query like select * from table_name where match(col) against('asp') returns nothing, when a similar like query returns several rows of data. Also a query like select * from table_name where match(col) against('pl/sql') also returns nothing. Is this a bug or am I doing something wrong? Pls, help!!! * * Visit http://www.computerstaff.net - Computer Jobs at all LEVELS * * - Before posting, 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
TheCasino.com: Registration Confirmation
TheCasino.com - Serving ''Winners'' Since 1999!! Dear MySQL List, Congratulations and welcome to TheCasino.com!! To confirm, you have successfully registered as a Real Player. From now on, every time you log on your Email Address will appear automatically. And for security, you will need to supply your: Password: lists If you have not already had a chance to play some of the CasinoSystem Games, our Progressive Jackpot is now US$13662.57 - and growing!! Now might be a good time to win some cash!! Give it a try... http://www.TheCasino.com ...then click on the 'Progressive Jackpot' link at the top of the screen. And then select 'Real Money Games'. Go for the US$13662.57 Jackpot now!! Please do let us know if we can ever be of assistance! Regards, The Support Staff TheCasino.com Corporation http://www.TheCasino.com [EMAIL PROTECTED] TheCasino.com - Better Than Life! (TM) ''Now With 100% Bonus on Every Deposit!!'' - Before posting, 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
TheCasino.com: You have been removed!
http://www.TheCasino.com: Better Than Life! (tm) Since 1999 - Now With 100% "Buffer Bonuses" On All Deposits!! Dear [EMAIL PROTECTED], This email is to confirm that we have "removed" you from our mailing list - per your request! You will no longer be considered for TheCasino.com Monhtly Prize Drawings. Please let us know if we can be of further assistance. The Support Staff TheCasino.com, Corp. [EMAIL PROTECTED] http://www.theCasino.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
TheCasino.com: You have been removed!
http://www.TheCasino.com: Better Than Life! (tm) Since 1999 - Now With 100% "Buffer Bonuses" On All Deposits!! Dear [EMAIL PROTECTED], This email is to confirm that we have "removed" you from our mailing list - per your request! You will no longer be considered for TheCasino.com Monhtly Prize Drawings. Please let us know if we can be of further assistance. The Support Staff TheCasino.com, Corp. [EMAIL PROTECTED] http://www.theCasino.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
[ANN] MySQL Studio v0.7 Released.
** After months of development We are proud to announce the first public version of MySQL Studio. http://dba-tools.com/ MySQL Studio provides an extremely easy to use interface to MySQL servers. A straight-forward and easy-to-use interface. MySQL Studio combines a list-view/editor and a tree-view of the content in one window. It lets you easily navigate the database data and structure and modify database without much fuss. This simple and intuitive interface has much been copied but never reached the same usability level. MySQL Studio interface leaves out all text-based information about database structure and data. Instead of scuffling with SQL scripts and obscure commands, you can concentrate on more important things - design of your database. Everything you need is right there at your finger tips. With MySQL Studio you can easiliy create and administer MySQL database, including such tasks as updating table's structure and query optimization. Download a full-functional Demo version from: http://www.dba-tools.com/downloads.php?file=studiotrial.exe View screenshots at: http://www.dba-tools.com/products.php Best regards, MySQL Studio Development Team DBA Tools http://dba-tools.com/