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: Frequently MyISAM TABLE corruption.....Pls help

tp://dev.mysql.com/doc/refman/5.0/en/corrupted-myisam-tables.html about mysqleers comments. Thanks ViSolve DB Team. - Original Message - From: "Nilnandan" <[EMAIL PROTECTED]> To: Sent: Monday, July 02, 2007 3:58 PM Subject: Re: Frequently MyISAM TABLE corruption.

Re: dynamic sql in proc

); Query OK, 2 rows affected (0.01 sec) +---+ | version() | +---+ | 5.0.18| +---+ 1 row in set (0.00 sec) Thanks ViSolve DB Team. - Original Message - From: "Bryan Cantwell" <[EMAIL PROTECTED]> To: Sent: Friday, June 29, 2007 4:03 AM Subject: dy

Re: Problem about fulltext search.

return rows. Thanks ViSolve DB Team - Original Message - From: "Niu Kun" <[EMAIL PROTECTED]> To: Sent: Sunday, July 01, 2007 7:53 AM Subject: Re: Problem about fulltext search. Steve Edberg wrote: At 11:23 PM +0800 6/30/07, Niu Kun wrote: To quote from http://dev.

Re: mysqldump for myisam tables.

her table, issue $>mysqldump -u user -p [table1,table2] > and unlock the tables once dump completed. Thanks ViSolve DB Team - Original Message - From: "Ananda Kumar" <[EMAIL PROTECTED]> To: "ViSolve DB Team" <[EMAIL PROTECTED]> Cc: "MySQL" Sent:

Re: mysqldump for myisam tables.

renames it to _old. [mysqlhotcopy --allowold ] mysqlhotcopy is only for myisam & archive tables. While restoring, simply place the dumped directory into to mysql data dir. You can use either mysqldump or mysqlhotcopy. Thanks ViSolve DB Team - Original Message - From: "Ananda Ku

Re: Understanding mysql NULL handling ...

Hi, Because "NULL is not a value". Operators [!=] must be suceeded by a value. These orphans must be selected in a correct way using "is" clause. Thanks ViSolve DB Team - Original Message - From: "Mufaddal Khumri" <[EMAIL PROTECTED]> To: S

Re: how to get Number of rows matched?

Hi Simple.. The query "feedback" will depict the matched & changed numbers. mysql> update test set roll = 1, s = 'new' where roll = 1; Query OK, 0 rows affected (0.00 sec) Rows matched: 1 Changed: 0 Warnings: 0 Thanks ViSolve DB Team. - Original Message

Re: how to get Number of rows matched?

ng out the matched row, it check whether there is need to change the old value to new value. if need then flags "Changed" and rewrite the same in the datafile/rollback segment. Thanks ViSolve DB Team. - Original Message - From: "Ace" <[EMAIL PROTECTED]> To:

Re: Max columns in a tabel in MyISAM storage engine

em(maximum file size defined by the OS). Try giving maximum value for avg_row_length. Thanks ViSolve DB Team - Original Message - From: "Fabian Köhler" <[EMAIL PROTECTED]> To: Sent: Tuesday, April 17, 2007 4:34 AM Subject: Max columns in a tabel in MyISAM storage engine

Re: sum with update

dures.. Thanks ViSolve DB Team - Original Message - From: "Ahmad Al-Twaijiry" <[EMAIL PROTECTED]> To: "MySQL List" Sent: Saturday, February 17, 2007 11:00 PM Subject: sum with update Hi Everyone I have a question regarding SUM and Update. is it possibl

Re: Multiple-table UPDATE unexpected result

| 10 | +--+--+ 4 rows in set (0.00 sec) Thanks ViSolve DB Team. - Original Message - From: "Thomas Spahni" <[EMAIL PROTECTED]> To: Cc: <[EMAIL PROTECTED]> Sent: Thursday, February 08, 2007 3:57 PM Subject: Multiple-table UPDATE unexpected result Dear listmember

Re: revoke SELECT on a column [ MySQL 4.1 ] + column "Comment"

h_ci Null: YES Key: Default: NULL Extra: Privileges: select,insert,update,references Comment: title for the forum topic 2 rows in set (0.01 sec) Hope Useful ! and Welcome for your interest. Thanks ViSolve DB Team. - Original Message ----- From: "Gilles MISSONNIER" <[E

Re: revoke SELECT on a column [ MySQL 4.1 ] + column privileges

t100' and ordinal_position=i; select col_name; grant select(col_name) on forum.catagory to 'xx'@localhost identified by 'mysql'; If col_name = c then revoke select(col_name) on forum.catagory from 'xx'@localhost identified by 'mysql'; end if; s

Re: revoke SELECT on a column [ MySQL 4.1 ]

swd'; mysql> select * from information_schema.column_privileges; mysql> REVOKE SELECT(hide_this) ON the_base.t100 from 'a_user'@'localhost' identified by 'a_passwd'; Note: Always TABLE PRIVILEGES override COLUMN PRIVILEGES Thanks ViSolve DB Team

Re: How find duplicate entries

Hi , Try this query... SELECT COUNT(*), column1, column2 FROM tablename GROUP BY column1, column2 HAVING COUNT(*)>1; Thanks, ViSolve DB Team - Original Message - From: "Tomás Abad Fernández" <[EMAIL PROTECTED]> To: Sent: Tuesday, February 06, 2007 9:57 P

Re: outer join question

Hello, Try this... select a.rhrqid,a.rhrqsid,a.rhrssid,b.sid,b.rlsid from rqhistory a left join relay b on (a.rhrqid = b.rqid and (a.rhrqsid = b.rlsid or a.rhrqsid = b.sid or a.rhrssid = b.rlsid or a.rhrssid = b.sid)) where a.rhrqsid = 101 or a.rhrssid = 101 Thanks, ViSolve DB Team

Re: mysql limits

Hi, It can handle. You can extend the file size also. File size limit depends on the OS. Obviously the performance depends on both the processor speed and the memory. Table optimization,indexing will improve performance. Thanks ViSolve DB Team - Original Message - From: "

Re: max_allowed_packet in my.ini

mysql or mysqldump. shell> mysql --max_allowed_packet=32M or using mysql> set @@SESSION.max_allowed_packet=32M; mysql> show variables like "max%"; Thanks ViSolve DB Team. - Original Message - From: "abhishek jain" <[EMAIL PROTECTED]> To: Sent: Monday, Feb

Re: mysql limits

value can be used by a single column itself or depends on the size of the columns. Thanks ViSolve DB Team. - Original Message - From: "kalin mintchev" <[EMAIL PROTECTED]> To: Sent: Monday, February 05, 2007 9:14 AM Subject: mysql limits hi all... i just wanted to ask

Re: select on multiple fields in several tables?

smith" or d.ename="johnsmith"; Thanks ViSolve DB Team. - Original Message - From: "boll" <[EMAIL PROTECTED]> To: "MySQL General Mailing List" Sent: Sunday, February 04, 2007 10:06 PM Subject: select on multiple fields in several tables? Hello- I

Re: Update queries

Try using CONCAT() ; mysql> update inventory_items set image_location=concat(item_number,'-1.jpg'); Thanks ViSolve DB Team. - Original Message - From: "Jerry Jones" <[EMAIL PROTECTED]> To: Sent: Saturday, February 03, 2007 12:00 PM Subject: Update que

Re: Update query question

Hi,, The Update query of yours will do fine.. otherwise try using string functions [instr()] like mysql> update inventory_items set name='necklace' where instr(description,'necklace')>0; Thanks ViSolve DB Team. - Original Message - From: "Jerry Jones&

Re: How to SELECT rows closest to value

Hi, Try like this (SELECT * FROM (SELECT * FROM tab_name ORDER BY latitute ASC, longitude ASC) a WHERE a.latitude<=givenvalue AND a.longitude<=givenvalue LIMIT 0,5) UNION (SELECT * FROM (SELECT * FROM tab_name ORDER BY latitute ASC, longitude ASC) b WHERE b.latitude>givenvalue AND b.long

Re: MySQL to Postgres

MySQL. Legal modes are: ansi, mysql323, mysql40, postgresql, oracle, mssql, db2, maxdb, no_key_options, no_table_options, no_field_options. One can use several modes separated by commas. Thanks ViSolve DB Team - Original Message - From: "Jim C." <[EMAIL PROTECTED]&

Re: CONCAT(int_col, string_col) and charset and collation problems

Hi, I know about CONVERT but I wanted to check character set of 'tt' column and this result use in CONVERT. Something like CONVERT(id USING CHARSET(Name)) which doesn't work. It wont. the syntax is -- CONVERT(expr USING transcoding_name); its the name of the transcode and not an expr. I j

Re: CONCAT(int_col, string_col) and charset and collation problems

set(concat(tt,CONVERT(id USING latin1))) from test; Thanks ViSolve DB Team - Original Message - From: "Dušan Pavlica" <[EMAIL PROTECTED]> To: "list mysql" Sent: Wednesday, January 31, 2007 5:31 PM Subject: CONCAT(int_col, string_col) and charset and collation proble

Re: rounding digits after decimal sign

stat,2) from parts; [no rounding, simply extract only the value of specified digits] For More info:http://www.keithjbrown.co.uk/vworks/mysql/mysql_p9.php Thanks, ViSolve DB Team - Original Message - From: "Dimitar Vasilev" <[EMAIL PROTECTED]> To: Sent: Thursday, Feb

Re: MYSQL reporting an error with subquery query

Hi, In your SQL statement you have used subquery. The subquery feature is introduced in MySQL version 4.1 and later. Thats why you are getting the Syntax error while running subquery in v4.0.24. Thanks, ViSolve DB Team - Original Message - From: "A Blossom of Paradise&quo

Re: simple alternate query

Hi, You can use select * from table1 where id in (1,3,4,5); Thanks, ViSolve DB Team - Original Message - From: "Miguel Vaz" <[EMAIL PROTECTED]> To: Sent: Sunday, January 28, 2007 7:51 AM Subject: Re: simple alternate query I am dumb, so sorry:

Re: low-priority-updates and innodb tables

hi, AFAIK, if we start mysqld with --low-priority-updates, it sets table updation a lower priority than the SELECT statements, irrespective of storage engines. hence it will affect the priority of the update operation. Ref: http://mysql.justdn.org/doc/refman/5.1/en/table-locking.html - Orig

Re: Urgent - MySQL 5 - mysqld using a lot of memory consistently

created is more, which should be low. so to average it increase the thread_cache size to some 64 or more. Ref: http://www.mysql.com/news-and-events/newsletter/2004-01/a000301.html Thanks ViSolve DB Team - Original Message - From: "Ratheesh K J" <[EMAIL PROTECTE

Re: Backup: Copy MYSQL Directory or use MysqlDump

hat of 'cp' command. Thanks Visolve DB Team. - Original Message - From: "altendew" <[EMAIL PROTECTED]> To: Sent: Tuesday, January 23, 2007 6:10 AM Subject: Backup: Copy MYSQL Directory or use MysqlDump I want to create a backup for my MySQL database every single

Re: Query about MySQL

system. File volume size is a notable parameter when moving for multiple tables. 3) Regular backups. Enable log-bin; in case of recovery, use mysqlbinlog. Thanks ViSolve DB Team - Original Message - From: "Raman Kheterpal" <[EMAIL PROTECTED]> To: <[EMAIL PROT

Re: Table update

t.created = ( select min(starttime) from races), t.id=(select id from race where starttime=(select min(starttime) from race)) ; Thanks ViSolve DB Team. Original Message - From: "Jørn Dahl-Stamnes" <[EMAIL PROTECTED]> To: Sent: Thursday, January 18, 2007 3:13 AM Subject:

Re: Request problem (with \\)

d against. (Exception: At the end of the pattern string, backslash can be specified as '\\'. At the end of the string, backslash stands for itself because there is nothing following to escape.) Ref: http://dev.mysql.com/doc/refman/5.1/en/string-comparison-functions.html Thanks ViSolve D

Re: Does Update allow for aliases?

Hi Reina, Try like: mysql > UPDATE maindb o,altdb ao set o.price =ao.price where o.id=ao.id; This will do good. Thanks ViSolve DB Team - Original Message - From: "Richard Reina" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 10, 2007 10:08 PM Subject: Do

Re: how to take advantage of STR_TO_DATE

') from table1; Thanks ViSolve DB Team - Original Message - From: "Gilles MISSONNIER" <[EMAIL PROTECTED]> To: Sent: Thursday, January 11, 2007 12:49 AM Subject: how to take advantage of STR_TO_DATE Hello the list I have a bunch of data that I load in the base

Re: Enum issue

--+-+-+---+ . | consent | enum('','Y','N','P') | YES | | NULL| | +---+--+--+-+-+---+ Thanks ViSolve DB Team - Original Message - From: "Olaf Stein" <[EMAIL PROTE

Re: store spatial data in mysql

ViSolve DB Team - Original Message - From: "CrazyWind" <[EMAIL PROTECTED]> To: Sent: Monday, January 08, 2007 7:10 PM Subject: Re: store spatial data in mysql Thanks . I have read these doucments, but if i want store a .shp file, How should I do? Con

Re: MYSQL REGEXP help

Hi, Try with mysql > select 'oer bv' REGEXP '(^b|[[:blank:]])(!?v|$v)'; Thanks ViSolve DB Team - Original Message - From: "Mike van Hoof" <[EMAIL PROTECTED]> To: "mysql" Sent: Monday, January 08, 2007 5:40 PM Subject: Re: MYSQL REGEXP

Re: store spatial data in mysql

Hi, More info on spatial data, http://dev.mysql.com/doc/refman/5.0/en/spatial-extensions.html http://dev.mysql.com/doc/refman/5.0/en/creating-spatial-columns.html http://dev.mysql.com/doc/refman/5.0/en/populating-spatial-columns.html Thanks ViSolve DB Team - Original Message - From

Re: MYSQL REGEXP help

Hi, [ERROR 1139 (42000): Got error 'repetition-operator operand invalid' from regexp] because, In your query, '!' is an Operator and ? is a wild character. Only wildcharacters should be follow the Operators. Try with. SELECT 'boer bv' REGEXP '[b|^b](!

Re: How to access an array variables in a single query

Hi, If the values to be matched against were from a table, why can't subquery be used. Like, SELECT * FROM TABLE1 WHERE id IN (select id from table2); Otherwise if numeric constants, then AFAIK procedure -loops would do. Thanks ViSolve DB Team. - Original Message - From: "

Re: On Duplicate Key Update question

Hi, From your query, understood that you want to retain old qty and new qty; result in another field. Try with, INSERT INTO TABLE1 (id,newqty) values (6,300) ON DUPLICATE KEY UPDATE totqty=oldqty+newqty, oldqty=newqty; Thanks, ViSolve DB Team - Original Message - From: "Ed

Re: How to access an array variables in a single query

Hi, IN operator will do. For Instance. SELECT * FROM TABLE1 WHERE id IN ('i1','i2','i3'); Thanks ViSolve DB Team. - Original Message - From: "VenuGopal Papasani" <[EMAIL PROTECTED]> To: Cc: "bharath kumar" <[EMAIL PROTEC

Re: SP not seeing INSERTs within WHILE loop

Hi, Your procedure returned correct numbers. Does misrepresentation happens for all the runs or adhoc. Thanks ViSolve DB Team. - Original Message - From: "brian stone" <[EMAIL PROTECTED]> To: Sent: Wednesday, January 03, 2007 8:55 AM Subject: SP not seeing INSERTs w

Re: db/query question...

Hi, This will do: select name,status, max(_date) from dog where status <(select max(status) from dog where status=dog.status) group by name; Thanks ViSolve DB Team. - Original Message - From: "bruce" <[EMAIL PROTECTED]> To: Sent: Friday, January 05, 2007 1

Re: mysql data into CSV file.

Hi, Try using, SELECT * INTO OUTFILE 'tmp/music_mp3.txt' FIELDS TERMINATED BY ',' OPTIONALLY ENCLOSED BY ' " ' LINES TERMINATED BY ' \n ' FROM mp3; Thanks ViSolve DB Team - Original Message - From: "Shain Lee" <[EMAIL PROTECT

Re: mysql question regarding distinct/group by...

t instance; resulting in, 1,2,1 Thanks ViSolve DB Team - Original Message - From: "bruce" <[EMAIL PROTECTED]> To: Sent: Thursday, January 04, 2007 6:07 AM Subject: mysql question regarding distinct/group by... hi... i've asked something similar before.. but it appears

Re: Err1114 The table 'sbtest' is full

the size of the tablespace,by adding another datafile, setting to innodb_autoextend_increment system variable. 3. Since you are doing with 2000 threads, try increasing thread_stack size.Hope with this FATAL error can be fixed. Thanks ViSolve DB Team - Original Message - From

Re: Max size and row numbers

. myisampack usually compresses a table by at least 50%, so you can have, in effect, much bigger tables. Thanks Visolve DB Team - Original Message - From: "Olaf Stein" <[EMAIL PROTECTED]> To: Sent: Friday, December 29, 2006 4:14 AM Subject: Max size and row numbers

Re: SQL syntax

n use the following query.. do not leave the value of column blank. INSERT INTO clf_cities SET cityname = 'Santa Barbara', countryid =NULL , enabled = '1' Thanks, ViSolve DB Team - Original Message - From: "Scott Yamahata" <[EMAIL PROTECTED]>

Re: SQL syntax

Hi, have you checked the 'enabled' field datatype or can you give the query. Thanks ViSolve DB Team. - Original Message - From: "Scott Yamahata" <[EMAIL PROTECTED]> To: Sent: Friday, December 29, 2006 11:59 AM Subject: SQL syntax Hi, I'm getting th

Re: MySQL Data Vanishing with FireFox

ata to get eliminated if the length exceeds 256 chars. The best solution is trace the parameter values, whether they are interpreted as it is. Thanks ViSolve DB Team - Original Message - From: "Matt Neimeyer" <[EMAIL PROTECTED]> To: Sent: Wednesday, December 27, 2006 8

Re: What to do if a table is supposed to get > 3GB data per day?

past data, then well and good compress the table.[only for myisam] shell> myisampack .MYI shell>myisamchk -rq .MYI Thanks ViSolve DB Team - Original Message - From: "Asif Lodhi" <[EMAIL PROTECTED]> To: Sent: Thursday, December 21, 2006 5:24 PM Subject: Wh

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

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

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: 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: 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: 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: 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: 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: 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: 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: +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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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: 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,

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

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

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

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

  1   2   >