Re: Creating new table from distinct entries

Hi, You will get a MySQL query syntax error number 1064 when you incorrectly use a reserved words in your query . * and DISTINCT cannot appear together. Check with the SELECT clause column list. Thanks ViSolve DB Team. - Original Message - From: Alan Milnes [EMAIL PROTECTED

Re: administrtor-user

administration console that enables you to easily administer your MySQL environment. http://www.softpedia.com/get/Internet/Servers/Database-Utils/MySQL-Administrator-for-Windows.shtml Thanks ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: Visolve DB Team [EMAIL

Re: administrtor-user

FROM user WHERE User='' and HOST='' Thanks ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 23, 2006 9:30 AM Subject: administrtor-user Can u guys tell me.. How can I be the administrator for the mysql and thenI I

Re: administrtor-user

Hi, On which platform? It do good in Linux and Unix. Thanks ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, October 23, 2006 10:05 AM Subject: Re: administrtor-user I am using sql 4.1.21

Re: bin-log with expire_logs_days

the required size is obtained and the new log is appended at the end (FIFO). For more information on this variable, http://bugs.mysql.com/bug.php?id=15580 http://bugs.mysql.com/bug.php?id=7236 Thanks ViSolve DB Team. - Original Message - From: George Law [EMAIL PROTECTED] To: mysql

Fw: bin-log with expire_logs_days

Hi, For Info about the 'expire-logs-days' bug fix and new release, http://www.developertutorials.com/mysql-manual/manual_News.html Thanks ViSolve DB Team. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: George Law [EMAIL PROTECTED]; mysql@lists.mysql.com Sent

Re: LOCK TABLES

LocalSettings.php, then go to the wiki). 2. --opt is enabled by default with mysqldump, and part of what it does it lock tables. So try the backup without lock tables, by adding --skip-lock-tables. Thanks ViSolve DB Team. - Original Message - From: mdpeters [EMAIL PROTECTED] To: mysql

Re: result set on prepared statements

Hi, Hope this link will be useful: http://mirrors.sunsite.dk/mysql/doc/refman/5.1/en/c-api-prepared-statement-functions.html Thanks ViSolve DB Team - Original Message - From: Roland Volkmann [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Sunday, October 15, 2006 5:59 PM Subject

Re: boolean search on phrase*

Hi The Boolen Search will itself satisfy your query. If you enclose the phrase within double quote (''), then the characters matches only rows that contain the phrase literally, as it was typed. Try removing quotes. Thanks ViSolve DB Team. - Original Message - From: C.R.Vegelin

Re: boolean search on phrase*

Hi, Try with + and * fulltext boolean operators. For instance, MATCH (Description) AGAINST('+olive oil*' IN BOOLEAN MODE) Thanks, ViSolve DB Team. - Original Message - From: C.R.Vegelin [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Thursday

Re: How do i initialize a new datadir in mysql ?

Hi, Create the initial databases and start the database with the following commands: shell mysql_install_db --datadir=/var/lib/mysql2 shell mysqld_safe --datadir=/val/lib/mysql2 Thanks ViSolve DB Team. - Original Message - From: Low Kian Seong [EMAIL PROTECTED] To: mysql

Re: Counting char in a column

('Characteristics', 'c') as count; which returns 3. For more reference http://dev.mysql.com/doc/refman/5.0/en/string-functions.html Thanks, ViSolve DB Team. - Original Message - From: Scott Hamm [EMAIL PROTECTED] To: 'Mysql ' mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 10:58

Re: Charset for SELECT ... INTO OUTFILE

results back. Conversion may be lossy if there are characters that are not in both character sets. Ref: http://dev.mysql.com/doc/refman/5.0/en/charset-connection.html Thanks ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 09

Re: Query Help plss

C:\\www\mysql\bin Thanks ViSolve DB Team. - Original Message - From: Renish To: Visolve DB Team ; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 10:07 AM Subject: Fw: Query Help plss - Original Message - From: Renish To: Visolve DB Team ; mysql

Re: Query Help plss

Hi, Hope this link will you. http://mysql.binarycompass.org/doc/refman/4.1/en/can-not-connect-to-server.html Thanks, ViSolve DB Team. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 11

Re: How to skip reading /etc/my.cnf by mysqld

. Thanks ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, October 07, 2006 11:41 AM Subject: How to skip reading /etc/my.cnf by mysqld Hi: I am trying to test mysql options and would like to have mysqld only read ~/.my.cnf instead

Re: Replication

://www.mysqlpress.com/doc/refman/5.0/en/replication-options.html Thanks ViSolve DB Team. - Original Message - From: Eric Anderson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, October 06, 2006 4:15 AM Subject: Replication I'm having a problem with my replication settings

Re: Can't set password for user

Hi, Check for the user in the 'User' Table of 'mysql' database. If there exists 'gamito' User in the User table, then set password will surely do. Verify: mysqluse mysql; mysqlselect * from user; Thanks ViSolve DB Team. - Original Message - From: Deckard [EMAIL PROTECTED

Re: Transactions in MySQL.

ViSolve DB Team - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, September 25, 2006 11:42 AM Subject: Transactions in MySQL. Hi All, How transactions and locking are handled in MYSQL? Is it a part of configuration? Or a query (lock tables

Urgent: parameter of my_hash_sort_simple

Hello, Could anyone explain me the parameter of the function my_hash_sort_simple in MySQL 5.0.20a. Which is called under strings/ctype-simple.c. Thanks, Prem

Re: Help with query

Hi, Try with FULLTEXT search. Alter the table to make the search columns as FULLTEXT columns, with MyISAM engine and retrieve the records using MATCH keyword. Ref:http://dev.mysql.com/doc/refman/5.0/en/fulltext-search.html Thanks, ViSolve DB Team. - Original Message - From: Ed

Re: Last Inserted ID Using LOAD DATA

Thanks ViSolve DB Team. - Original Message - From: Michael Stearne [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: Jim Ginn [EMAIL PROTECTED] Sent: Tuesday, September 19, 2006 10:11 PM Subject: Last Inserted ID Using LOAD DATA I have a group of updates that need to be done using LOAD DATA

Re: FIND DATA location

Hi, From the mysql itself try this -- mysql show variables; This will list data_home_dir path, arch_dir path, group_home_dir path,pid_file path, socket path etc. along with other variables. Thanks ViSolve DB Team. - Original Message - From: Hal Wigoda [EMAIL PROTECTED] To: mysql

Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?

for localhost. If you are using an old MySQL release that doesn't support --force, you have to remove the resolveip test in mysql_install with an editor. c.. Start mysqld with su instead of using --user. Thanks ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: MySql

Re: Null !?

hi, You can use DBNull. DBNull - First it returns true if such a value is null, then converts the value to an empty string if it is null. For instance, If dbval Is DBNull.value then return End If Thanks ViSolve DB Team. - Original Message - From: Roberto William Aranda-W Roman

Re: Moving database to another machine

Hi, Try, Compress - [Mac A] shell mysqldump -all -databases |gzip dbfilename.sql.gz UnCompress [Mac B] shell gunzip dbfilename.sql.gz | mysql -u user -p db Thanks ViSolve DB Team. - Original Message - From: Ratheesh K J [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday

Re: INNODB my.cnf

Hi, Attached is the sample my.cnf for Innodb engine type. Thanks, ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 7:31 PM Subject: INNODB my.cnf Hi All, I need some inputs regarding my.cnf : We are using

Re: Restarting MySQL on Solaris 8?

Hi, Try /usr/local/bin/mysqld_safe to start MySQL /usr/local/bin/mysqld_safe to start MySQL as a background process. Thanks. ViSolve DB Team. - Original Message - From: Jay Paulson [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 08, 2006 9:51 PM Subject

Re: Restarting MySQL on Solaris 8?

Hi, /usr/local/bin/safe_mysqld must do good with MySQL 3.23.49. The error may be due to either one. a. configuration file set up b. data directory - anything removed/modified - not enough disk space c. log file size Thanks, ViSolve DB Team. - Original Message - From: Visolve DB

Re: View hidden temporary files

creates a disk-based table in its tmpdir directory (often /tmp on Unix systems.) . mysql SHOW STATUS LIKE 'Created_tmp_%'; To find out how often that happens, compare the relative sizes of the Created_tmp_tables and Created_tmp_disk_tables counters. Thanks, ViSolve DB Team. - Original

Re: Understanding Query-Cache math...

and Qcache_lowmem_prunes status variables. Thanks ViSolve DB Team - Original Message - From: Christian Hammers [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, September 01, 2006 1:52 PM Subject: Understanding Query-Cache math... Hello I don't understand why query_cache_size

Re: IN ANY subqueries

) Hence the exact syntax to use is: Select fields from table where fieldname = ANY ( select fieldname from table); Ref: http://dev.mysql.com/doc/refman/5.0/en/any-in-some-subqueries.html Thanks ViSolve DB Team - Original Message - From: Ben Lachman [EMAIL PROTECTED] To: mysql

Re: Drop Index if Exists

Hello Adam,This is the exact syntax to drop the index.DROP INDEX index_name ON tbl_nameThanksVisolve DB Team . - Original Message - From: Adam Lipscombe [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, September 01, 2006 3:28 PM Subject: Drop Index if Exists Folks, Does

Re: Group By question

Hello , Another one alternate solution without join SELECT id,count(email) as No ,email FROM email GROUP BY email having count(email)1 Thanks Visolve DB Team. - Original Message - From: Peter Brawley To: Chris W Cc: MYSQL General List Sent: Thursday, August 31, 2006 3

Re: Doing sum's if certain conditions are true

' and code2'denied' group by code1 Thanks Visolve Db team - Original Message - From: Ian Barnes [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 29, 2006 3:26 PM Subject: Doing sum's if certain conditions are true Hi, I am trying to build a query that does a sum

Re: ALTER TABLE

Hi, Try this: To modify an existing field: ALTER TABLE doc MODIFY docts timestamp DEFAULT CURRENT_TIMESTAMP; or To add new field ALTER TABLE doc ADD docts timestamp DEFAULT CURRENT_TIMESTAMP; Thanks, ViSolve DB Team. - Original Message - From: Peter Lauri [EMAIL PROTECTED

Re: what should be the value of innodb_flush_log_at_trx_commit

, then only an operating system crash or a power outage can erase the last second of transactions. Ref: http://dev.mysql.com/doc/refman/5.0/en/innodb-parameters.html Thanks ViSolve DB Team - Original Message - From: Ratheesh K J [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August

Re: REPAIR TABLE and mysqlcheck

must have this privilege to create a routine in the first place. Thanks Visolve DB Team. - Original Message - From: Logan, David (SST - Adelaide) [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Thursday, August 24, 2006 7:18 AM Subject: REPAIR TABLE and mysqlcheck Hi Folks

Re: dates in mysql

. Thanks ViSolve DB Team - Original Message - From: Chris [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Wednesday, August 23, 2006 8:11 AM Subject: dates in mysql Hi all, Does anyone know how mysql stores dates? I'm wondering whether it converts it back to UTC before storing

Re: help needed to mount data from /var/lib/mysql

Hello, You can change the MySQL data path in /etc/my.cnf by editing the configuration parameter datadir with new data path. Once you done the changes in my.cnf, reboot the MySQL server. Thanks, ViSolve DB Team - Original Message - From: balaraju mandala [EMAIL PROTECTED

Re: Incrementing using Max(Field) ?

Hello William Try the below Query to insert next maximum value of the field into same table INSERT INTO Sample(id) SELECT MAX(id)+1 FROM Sample Thanks Visolve DB Team - Original Message - From: William DeMasi [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August

Re: multiple table inserts

want to insert the name and feed details into animalfeed table . The query must be follow below synatx INSERT INTO Animalfeed(name,feed) SELECT a.name,b.feed from Animal a,feed b WHERE a.id=b.id Thanks Visolve DB TEAM. - Original Message - From: bruce [EMAIL PROTECTED] To: mysql

Re: multiple table inserts

Hi Bruce U can you mysql_insert_id function to insert values into multiple tables. Please refer to http://www.desilva.biz/mysql/insertid.html for more details. It also illustrates with examples. Thanks Visolve DB Team - Original Message - From: bruce [EMAIL PROTECTED] To: mysql

Re: refrenceing information thru seperate tables

to filter resultset otherwise join query returns all recordset from both tables The above query has been written using inner join , This Query returns resultset only the cutomers belongs to particular productid information in the cusstomer table. We hope it is ok for you . Thanks Visolve DB Team

Re: multiple table inserts

Hi Bruce What Fred said is true. Only transactions will help you. Regards Visolve DB Team - Original Message - From: Frederic Wenzel [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: Visolve DB Team [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, August 15, 2006 1:01 PM Subject: Re

Re: IN or OR? whats the diff?

Hi Michael, While using IN operator expr IN (value,...) Returns 1 if expr is equal to any of the values in the IN list, else returns 0. If all values are constants, they are evaluated according to the type of expr and sorted. The search for the item then is done using a binary search.

Re: want to insert unicode myanmar characters into MySQL database

. Reconfigure, recompile, and test. Thanks Visolve DB Team. - Original Message - From: khaing su yee [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 01, 2006 9:28 AM Subject: want to insert unicode myanmar characters into MySQL database I use Toad for MySQL 2.0 and SQLyog

Re: tune a geometric query

Hello Prashant, If you do need the duplicate rows in the final result, use UNION ALL with your query. Otherwise you can opt for UNION as UNION is faster than UNION ALL. Thanks, ViSolve DB Team. - Original Message - From: PRASHANT N [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent

Re: Problems with WHERE clause

Hello Jørn Dahl-Stamnes, The column 'fee' is existing in more than one table . To overcome this problem use the correct instance name of the table for the column fee In WHERE clause select s.id, s.name, sum(p.fee) as fee from serie as s inner join race_serie as rs on

Re: MySQL Cluster

Hello Kaushal, You can get the MySQL clustering details from the following link. http://dev.mysql.com/doc/refman/5.0/en/mysql-cluster-quick.html http://dev.mysql.com/doc/refman/5.0/en/index.html Thanks, ViSolve DB Team - Original Message - From: Kaushal Shriyan [EMAIL PROTECTED

Re: Stored procedures

Hello Jon. Could you tell me the version of MySql ?. You can find the version by excuting the command SELECT version() If the version is below 5, the stored procedure feature would not work . Thanks Visolve DB Team. - Original Message - From: Jon [EMAIL PROTECTED] To: mysql

Re: Searching through an alphabetical range

Hello Paul, You can try this: SELECT DISTINCT lastname FROM employee WHERE lastname BETWEEN 'm' AND 'z'; Thanks, ViSolve DB Team. - Original Message - From: Paul Nowosielski [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, July 21, 2006 10:33 PM Subject: Searching through

Re: Finding a point inside a polygon

Hello Mark, You can locate a point, whether inside or outside a polygon area using the query below: SELECT contains(geomfromtext(@poly),geomfromtext(@p)); where @poly,@p are variables. Eg: set @p='Point(3 2)'; set @poly= 'Polygon((0 0,0 3,3 0,0 0),(1 1,1 2,2 1,1

Re: CHARACTER SET COLLATE NULL error with mySQL 4.0.27

Hello Thomas You have an error in your SQL syntax. Please try this : CREATE TABLE test.user ( user_id INT UNSIGNED NOT NULL AUTO_INCREMENT, PRIMARY KEY(user_id), email text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci', firstname text CHARACTER SET 'latin1' COLLATE 'latin1_swedish_ci');

Re: FULL TEXT and Asian languages

Hi Peter, Definitely using OR will slow up the performance of FULL TEXT searching. Instead of using OR, you can try using UNION statement. Hope this will be a fix for your issue. Thanks, ViSolve MySQL Support Team. - Original Message - From: Peter Lauri [EMAIL PROTECTED] To: 'JC'

<    1   2