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'); T

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: "'J

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 1

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: Sent: Friday, July 21, 2006 10:33 PM Subjec

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" <[EM

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 PR

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 (rs

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. This

Re: want to insert unicode myanmar characters into MySQL database

COMPILED_CHARSETS lists in configure.in. Reconfigure, recompile, and test. Thanks Visolve DB Team. - Original Message - From: "khaing su yee" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 01, 2006 9:28 AM Subject: want to insert unicode myanmar characters into MySQL data

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: Sent:

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: Sent: Tuesday, Augus

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 PR

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 PR

Re: refrenceing information thru seperate tables

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]>; Sent: Tuesday, August

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&quo

Re: dates in mysql

he environment in which the server runs. Thanks ViSolve DB Team - Original Message - From: "Chris" <[EMAIL PROTECTED]> To: Sent: Wednesday, August 23, 2006 8:11 AM Subject: dates in mysql > Hi all, > > Does anyone know how mysql stores dates? > > I'

Re: REPAIR TABLE and mysqlcheck

you 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" Sent: Thursday, August 24, 2006 7:18 AM Subject: REPAIR TABLE and

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 P

Re: what should be the value of innodb_flush_log_at_trx_commit

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: Sent: Tuesday, August 2

Re: Doing sum's if certain conditions are true

7;none' and code2<>'denied' group by code1 Thanks Visolve Db team - Original Message - From: "Ian Barnes" <[EMAIL PROTECTED]> To: Sent: Tuesday, August 29, 2006 3:26 PM Subject: Doing sum's if certain conditions are true Hi, I am trying to

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, 2

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: Sent: Friday, September 01, 2006 3:28 PM Subject: Drop Index if Exists Folks, Does this work in MYSQL 5?

Re: Understanding Query-Cache math...

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

Re: IN & ANY subqueries

comma) Hence the exact syntax to use is: Select from < table> where = ANY ( select from ); 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: Sent: Sunda

Re: View hidden temporary files

ize, MySQL 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

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: Sent: Friday, September 08, 2006 7:31 PM Subject: INNODB my.cnf Hi All, I need some inputs regarding my.cnf : We are using INNODB

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: 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: "Visol

Re: Moving database to another machine

Hi, Try, Compress - [Mac A] shell> mysqldump -all -databases |gzip >dbfilename.sql.gz UnCompress [Mac B] shell> gunzip Thanks ViSolve DB Team. - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 12, 2006 12:13 PM Su

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 W

Re: Last Inserted ID Using LOAD DATA

Thanks ViSolve DB Team. - Original Message - From: "Michael Stearne" <[EMAIL PROTECTED]> To: 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 t

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" <[E

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

umbers instead of host names except 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 Mes

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: &qu

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: Transactions in MySQL.

ViSolve DB Team - Original Message - From: <[EMAIL PROTECTED]> To: 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, Unlock table

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: mysql>use mysql; mysql>select * from user; Thanks ViSolve DB Team. - Original Message

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: Sent: Friday, October 06, 2006 4:15 AM Subject: Replication > > I'm having a problem with my replica

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

l do good. Thanks ViSolve DB Team. - Original Message - From: <[EMAIL PROTECTED]> To: 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 ~/.

Re: Charset for SELECT ... INTO OUTFILE

efore sending 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: Sent: Monday, Octob

Re: Query Help plss

make sure its comming from 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: V

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]>; Sent: Tuesday, O

Re: Counting char in a column

ECT substrCount('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: "&#x

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 - Fro

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 PROTECT

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 PRO

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: Sent: Sunday, October 15, 2006 5:59 PM Subjec

Re: LOCK TABLES

aller (rename 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"

Re: bin-log with expire_logs_days

until 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

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 P

Re: administrtor-user

sql> SET PASSWORD FOR 'jeffrey'@'%' = PASSWORD('biscuit'); 3. mysql> SET PASSWORD = PASSWORD('biscuit'); To Drop user: 1. mysql> DELETE FROM user WHERE User='' and HOST='' Thanks ViSolve DB Team. - Original Message -

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]>; Sent: Monday, October 23, 2006 10:05 AM Subject: Re: administrtor-user I am

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:

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" <[EM

Re: how to retrieve a list of savepoint in mysql.

\G and also shell> show warnings\G [lists all the warnings, notes, messages of the session] Thanks ViSolve DB Team. - Original Message - From: "vijay bahirji" <[EMAIL PROTECTED]> To: Sent: Monday, October 30, 2006 6:30 PM Subject: how to retrieve a list of savepoint

Re: Performance of different length/size datatypes

Hi, To BLOB or not to BLOB | Whether to store string in BLOB, or CHAR, or VARCHAR pls play the link: http://www.volny.cz/iprenosil/interbase/ip_ib_strings.htm Thanks ViSolve DB Team. - Original Message - From: "Chris W. Parker" <[EMAIL PROTECTED]> To: Sent: Fr

Re: More than one MyQSL in a server

hi, have you traced .err file for the nature of the error? if not you can try that. Thanks ViSolve DB Team - Original Message - From: "Mário Gamito" <[EMAIL PROTECTED]> To: "Nico Sabbi" <[EMAIL PROTECTED]> Cc: Sent: Thursday, November 02, 2006 4:31 PM

Re: MAX + SUM in one query

320 | 14 | +--+--++ 2 rows in set (0.01 sec) Thanks, ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Monday, November 06, 2006 8:58 AM Subject: MAX + SUM in one query Hi e

Re: when does auto_increment_increment and auto_increment_offset come into being?

Hi Obviously!. These variables were introduced in MySQL 5.0.2. These system variables accommodate multi-master replication with AUTO_INCREMENT. Thanks ViSolve DB Team. - Original Message - From: "Xueron Nee" <[EMAIL PROTECTED]> To: Sent: Monday, November 06, 2006

Re: MAX + SUM in one query

and the output for the query. Thanks ViSolve DB Team. - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL List" Sent: Monday, November 06, 2006 12:10 PM Subject: Re: MAX + SUM in

Re: MAX + SUM in one query

Hi The query will work and should. As of our understanding, you want to retrieve the sum of the total column for a particular id, with its max price where the type='offer' and id same for both the tables. Is it so? Thanks ViSolve DB Team. - Original Message - From:

Re: wait_timeout help

Hi specify it in the .cnf file in the mysqld options: wait_timeout=x or specify it at the command line : set wait_timeout=x or start mysqld with --wait_timeout=x along with other options. Thanks ViSolve DB Team - Original Message - From: "Sayed Hadi Rastgou Haghi" <[EM

Re: wait_timeout help

Hi Try command line option, like mysql >set @@session.wait_timeout=15; mysql> show variables; Thanks Visolve DB Team. - Original Message - From: "Sayed Hadi Rastgou Haghi" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: Se

Re: wait_timeout help

#x27;interactive_timeout' variable's value or wait_timeout variables values -depends on the type of client (as defined by the CLIENT_INTERACTIVE connect option to mysql_real_connect()) Thanks ViSolve DB Team. ----- Original Message - From: Sayed Hadi Rastgou Haghi To: Visolve DB Tea

Re: Moving to another hard drive

Hi, 1) check with the owner & permission of the copied data folder 2) GRANT ALL permission to access that db (name of the copied folder) Thanks ViSolve DB Team - Original Message - From: "Kevin Chen" <[EMAIL PROTECTED]> To: Sent: Thursday, February 21, 2008 1:14 P

Re: wait_timeout help

econnected with 'reconnect flag' set to 1 in the MySQL structure... Thanks ViSolve DB Team - Original Message - From: Sayed Hadi Rastgou Haghi To: Visolve DB Team Cc: mysql@lists.mysql.com Sent: Wednesday, November 08, 2006 11:51 AM Subject: Re: wait_timeout help Hi

Re: InnoDB + FULLTEXT

Hi, Till MySQL 5.0 there was no support for FULLTEXT by InnoDB. More info on: www.innodb.com/innodbtalkUC2005.pdf Thanks ViSolve DB Team. - Original Message - From: "FalconSoft, Inc" <[EMAIL PROTECTED]> To: Sent: Thursday, November 09, 2006 6:28 AM Subject: I

Convertion ORACLE query to MYSQL

Hi Experts, We are in the process of converting Oracle administration commands into MySQL for some purposes. We dont know how to convert the following Oracle commands to MySQL. How to do that..? 1. ALTER USER spec TEMPORARY TABLESPACE temp_ts; 2. DROP USER jbossjms1 CASCADE; 3. DROP TABLESPAC

Re: Error:1067 could not start mysql server

Hi, On which platform? Have you checked with *.err file? Thanks ViSolve DB Team. - Original Message - From: "VenuGopal Papasani" <[EMAIL PROTECTED]> To: Sent: Saturday, November 11, 2006 7:36 PM Subject: Error:1067 could not start mysql server Dear all,

Re: Error:1067 could not start mysql server

see the copied database in the new mysql server. If you are using Unix , by default, data dir will be in /usr/local/ mysql_ - - -/ data If it is linux , it will be in /var/lib Thanks, ViSolve DB Team - Original Message - From: "Visolve DB Team" <[EMAIL PROTECTED]>

Re: Moving large Innodb table to another mysql

. Thanks ViSolve DB Team. - Original Message - From: "sofox" <[EMAIL PROTECTED]> To: Sent: Friday, November 17, 2006 5:32 PM Subject: Moving large Innodb table to another mysql > Dear All, > > I am using mysql-4.0.26, and I have a very large innodb table(>10G)

Re: How Do I Know If mySQL is using MyISAM or InnoDB?

Hi, If you are particular about a table, i.e what engine my table uses? Try, mysql > show table status like 'tablename' \G Thanks ViSolve DB Team. - Original Message - From: "John Kopanas" <[EMAIL PROTECTED]> To: Sent: Friday, November 17, 2006 10:43

Re: Importing Text File Into mySQL

, though it is possible to import the data. It also depends on the width of the fields. The data and the fieldname does not corresponds. Thanks ViSolve DB Team. - Original Message - From: "John Kopanas" <[EMAIL PROTECTED]> To: Sent: Saturday, November 18, 2006

Re: AUTOCOMMIT. displaying and setting

There is no global system variable to set Autocommit; but we can achieve the same with 'init_connect=SET AUTOCOMMIT=0'. This variable can be set from the mysql or in the commandline or in the option file. Like, mysql > SET GLOBAL init_connect='SET AUTOCOMMIT=0'; or mysql>SET @@GLOBAL.init_connect=

Re: AUTOCOMMIT. displaying and setting

ith START TRANSACTION, autocommit remains disabled until you end the transaction with COMMIT or ROLLBACK. The autocommit mode then reverts to its previous state once transaction done. Thanks ViSolve DB Team. - Original Message - From: "Amit Dor-Shifer" <[EMAIL PROTECTED]&

Re: MySql doubt.

| 12 dollar | ++---+ You can use this query to get the items which doesnt have price. mysql> select item from a where item not in ( select item from b); +---+ | item | +---+ | table | | chair | +---+ Thanks, ViSolve DB Team. - Original Message - From: &q

Re: FIND_IN_SET question

Hi, Hope, a string constant can be searched against a column; Most of the string function including find_in_set, allows us to display only the table values and not the string constants passed. Try it with 2 tables; or some userdefined functions. Thanks ViSolve DB Team. - Original

Re: Table of type=memory is full... but not

. Try with mysql > set GLOBAL max_heap_table_size=value; For individual tables specify MAX_ROWS table option in the CREATE TABLE or in the ALTER TABLE. For more Ref: http://dev.mysql.com/doc/refman/4.1/en/memory-storage-engine.html Thanks ViSolve DB Team. - Original Message - From: &q

Re: MySql doubt.

substring(price,1,instr(price,'-')-1) from b ); +---+ | item | +---+ | table | | chair | +---+ Hope this helps. Thanks, ViSolve DB Team - Original Message - From: "Renish" <[EMAIL PROTECTED]> To: "ViSolve DB Team" <[EMAIL PROTECTE

Re: Having Problem With Load Files and AutoNumber id fields

---+---++ | item | price | id | ++---++ | rubber | 10| 1 | | pencil | 15| 2 | | pen| 45| 3 | || NULL | 4 | ++---+----+ 4 rows in set (0.00 sec) Thanks ViSolve DB Team - Original Message - From: "John Kopanas&quo

Re: Simple doubt

ct b from a group by b having count(b)>1; +---+ | b | +---+ | paper | | pen | +---+ 2 rows in set (0.00 sec) Hope this helps. Thanks, ViSolve DB Team. - Original Message - From: "Renish" <[EMAIL PROTECTED]> To: "Hal Wigoda" <[EMAIL PROTECTE

Re: Full-text searching with quoted bind variables

ackslash. For instance, mysql> select * from articles where match(title,body) against (' \'database\' '); or can be like this mysql> select * from articles where match(title,body) against (' "database" '); Thanks ViSolve DB Team. - Original Me

Re: How to calculate max number of rows in a MyISAM table (default MAX_ROWS) ?

.0/en/create-table.html Thanks ViSolve DB Team. - Original Message - From: "Amit Dor-Shifer" <[EMAIL PROTECTED]> To: Sent: Tuesday, November 28, 2006 7:54 PM Subject: How to calculate max number of rows in a MyISAM table (default MAX_ROWS) ? > Hi. > I've c

Re: before update trigger syntax

Hi Try with mysql> delimiter // mysql> CREATE TRIGGER eat_lub BEFORE UPDATE ON d -> FOR EACH ROW BEGIN -> UPDATE d SET NEW.s=user(); -> END// Query OK, 0 rows affected (0.03 sec) mysql> delimiter ; Hope this helps. Thanks, ViSolve DB Team - Original Message

Re: No of columns in a table

ROW_LENGTH will decide the maximum tablesize. To get the current values, use SHOW TABLE STATUS LIKE ''; Thanks ViSolve DB Team. - Original Message - From: "C K" <[EMAIL PROTECTED]> To: Sent: Wednesday, November 29, 2006 6:06 PM Subject: No of columns in a table I

Re: +1MB query gets "Out of memory"

ViSolve DB Team - Original Message - From: "nocturnal" <[EMAIL PROTECTED]> To: Sent: Thursday, November 30, 2006 9:11 PM Subject: +1MB query gets "Out of memory" Hi A client used to get Out of memory when trying to send a query that was a bit more than 1MB. The

Re: SUM() of 1 and NULL is 1 ?

, ViSolve DB Team - Original Message - From: "C.R.Vegelin" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 06, 2006 3:27 PM Subject: SUM() of 1 and NULL is 1 ? Hi List, I need to SUM() on months from a table like: CREATE TABLE `data` ( `Jan` float default NULL, ...

Re: SUM() of 1 and NULL is 1 ?

Hi Vegelin, This will do.. select IF(SUM(IF(Jan IS NULL, 0, Jan))>0,NULL,SUM(IF(Jan IS NULL, 0, Jan)))as jan from data; Thanks, ViSolve DB Team - Original Message - From: "ViSolve DB Team" <[EMAIL PROTECTED]> To: "C.R.Vegelin" <[EMAIL PROTECTED]

Re: Update query help

Hi, Try this.. UPDATE table2 inner join table1 on table2.playedid=table1.playerid SET table2.totalscore=sum(table1.score) Just a guess... Thanks, ViSolve DB Team - Original Message - From: "Ravi Kumar." <[EMAIL PROTECTED]> To: Sent: Wednesday, December 06, 2006

Re: set global does not work

s will be automatically cleared if the time exceeds 'wait_timeout' variable value. Thanks ViSolve DB Team. - Original Message - From: <[EMAIL PROTECTED]> To: Sent: Thursday, December 07, 2006 11:52 AM Subject: RE: set global does not work > > Hi: >

Re: Renaming the root user - problems.

Hi No. MySQL doesn't insist on any 'root' user. If necessary you can rename it. If you have the supervisor privileges, you can edit the same. Make sure to Grant Permissions. For instance: mysql> grant all on *.* to 'myroot'@localhost identified by 'm

Re: How to rename database name

Hi Simply go with either of these: 1. 'mysqldump' the current database, drop it and create a new database. Move the dumped data into the new database. or 2. Stop mysqld. Rename the database folder in the datadirectory. Start the server and grant access permissions Thanks

Re: Prefixing fields with table name when joining?

Hi Kelly, The short script of prefixing fields with tablename till 5.0 and beta is not applicable. Hope, this senario would be rare, that too many tables with larger field length, more columns etc. Thanks ViSolve DB Team - Original Message - From: "Kelly Jones" <[EM

Re: definition of Created_tmp_files in "show status"

rver while executing statements. Created_tmp_disk_tables -The number of temporary tables on disk created automatically by the server while executing statements. Created_tmp_files - How many temporary files mysqld has created. were used to determine the temporary files status. Thanks ViSol

Re: account that can only do backup

Hi, File Privilege will do that. But the FILE privilege can only be granted globally (using ON *.* syntax).Therefore, attempts to restrict it to a particular scope will lead to error. so try with grant file on*.* to 'user'@'localhost'; Hope this will do. Thanks ViSolve DB

Re: definition of Created_tmp_files in "show status"

table_size Thanks ViSolve DB Team. - Original Message - From: "Kevin Fries" <[EMAIL PROTECTED]> To: "Visolve DB Team" <[EMAIL PROTECTED]> Cc: Sent: Thursday, December 14, 2006 9:20 PM Subject: Re: definition of Created_tmp_files in "show status"

Re: howto query DELETE

Hi, Try, mysql> delete from GbEntries where sender not in (select * from Accounts); Thanks ViSolve DB Team. - Original Message - From: "Christian Parpart" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 20, 2006 3:11 PM Subject: howto query DELETE -- My

Re: find date an time of a table update

S where TABLE_NAME=''; Note 2: Check the user privilege to access the database. If not grant it. Thanks ViSolve DB Team. - Original Message - From: "Marcelo Fabiani" <[EMAIL PROTECTED]> To: Sent: Friday, December 22, 2006 6:21 AM Subject: find date an time of

Re: oracle transfer question

Hi, Try using STDDEV(), which was given for Oracle compatibility by MySQL. SELECT employee_id, salary, hire_date, STDDEV(salary) "Std Deviation of Salary" FROM employees WHERE job_id = 'ST_CLERK' Group by employee_id, salary, hire_date ORDER BY hire_date; Tha

  1   2   >