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: mysql@lists.mysql.com Sent: Thursday, February 21, 2008 1:14 PM

Re: dynamic sql in proc

; - deallocate prepare smt; - end if; - until done end repeat; - close cur1; - end; - | Query OK, 0 rows affected (0.03 sec) mysql call mi(); Query OK, 2 rows affected (0.01 sec) +---+ | version() | +---+ | 5.0.18| +---+ 1 row in set (0.00 sec) Thanks ViSolve DB

Re: Frequently MyISAM TABLE corruption.....Pls help

-tables.html about mysqleers comments. Thanks ViSolve DB Team. - Original Message - From: Nilnandan [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, July 02, 2007 3:58 PM Subject: Re: Frequently MyISAM TABLE corruption.Pls help hello I am still facing the same problem.. MyISAM

Re: Problem about fulltext search.

DB Team - Original Message - From: Niu Kun [EMAIL PROTECTED] To: mysql@lists.mysql.com 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.mysql.com/doc/refman/5.0

Re: mysqldump for myisam tables.

either mysqldump or mysqlhotcopy. Thanks ViSolve DB Team - Original Message - From: Ananda Kumar [EMAIL PROTECTED] To: MySQL mysql@lists.mysql.com Sent: Friday, June 15, 2007 10:05 AM Subject: Re: mysqldump for myisam tables. Hi All, What are the parameters that i need to use to take

Re: mysqldump for myisam tables.

another table, issue $mysqldump -u user -p dbname [table1,table2] dumpfile with path 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 mysql@lists.mysql.com Sent: Friday

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: mysql@lists.mysql.com Sent: Thursday, June 14, 2007

Re: how to get Number of rows matched?

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: mysql@lists.mysql.com Sent: Monday, June 11

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 - From: Ace [EMAIL PROTECTED

Re: Max columns in a tabel in MyISAM storage engine

by the OS). Try giving maximum value for avg_row_length. Thanks ViSolve DB Team - Original Message - From: Fabian Köhler [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, April 17, 2007 4:34 AM Subject: Max columns in a tabel in MyISAM storage engine Hello, i have table

Re: sum with update

.. Thanks ViSolve DB Team - Original Message - From: Ahmad Al-Twaijiry [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Saturday, February 17, 2007 11:00 PM Subject: sum with update Hi Everyone I have a question regarding SUM and Update. is it possible to use SUM

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

: 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 [EMAIL PROTECTED] To: ViSolve DB Team [EMAIL PROTECTED] Cc: mysql

Re: Multiple-table UPDATE unexpected result

| +--+--+ 4 rows in set (0.00 sec) Thanks ViSolve DB Team. - Original Message - From: Thomas Spahni [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: [EMAIL PROTECTED] Sent: Thursday, February 08, 2007 3:57 PM Subject: Multiple-table UPDATE unexpected result Dear listmembers On mysql version

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

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; set i=i+1; end while; end; mysql call g(hide_this_col); Thanks ViSolve DB Team

Re: revoke SELECT on a column [ MySQL 4.1 ]

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 - Original Message - From: Gilles MISSONNIER [EMAIL PROTECTED

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: mysql@lists.mysql.com Sent: Tuesday, February 06, 2007 9:57 PM Subject

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

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: select on multiple fields in several tables?

ViSolve DB Team. - Original Message - From: boll [EMAIL PROTECTED] To: MySQL General Mailing List mysql@lists.mysql.com Sent: Sunday, February 04, 2007 10:06 PM Subject: select on multiple fields in several tables? Hello- I'm working with an unfamiliar application, trying to figure out

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: mysql@lists.mysql.com Sent: Monday, February 05, 2007 9:14 AM Subject: mysql limits hi all... i just wanted to ask

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: mysql@lists.mysql.com Sent: Monday, February 05, 2007 11:37 AM

Re: MySQL to Postgres

. 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] To: mysql@lists.mysql.com Sent

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.latitudegivenvalue AND

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 [EMAIL PROTECTED] To: mysql

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: mysql@lists.mysql.com Sent: Saturday, February 03, 2007 12:00 PM Subject: Update queries I need

Re: rounding digits after decimal sign

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: mysql@lists.mysql.com Sent: Thursday, February 01

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

,CONVERT(id USING latin1))) from test; Thanks ViSolve DB Team - Original Message - From: Dušan Pavlica [EMAIL PROTECTED] To: list mysql mysql@lists.mysql.com Sent: Wednesday, January 31, 2007 5:31 PM Subject: CONCAT(int_col, string_col) and charset and collation problems Hi, I'm using MySQL

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

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: mysql@lists.mysql.com Sent: Sunday, January 28, 2007 7:51 AM Subject: Re: simple alternate query I am dumb, so sorry

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 [EMAIL

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 -

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 PROTECTED] Cc: [EMAIL PROTECTED

Re: Backup: Copy MYSQL Directory or use MysqlDump

' command. Thanks Visolve DB Team. - Original Message - From: altendew [EMAIL PROTECTED] To: mysql@lists.mysql.com 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 night. I am

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

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 PROTECTED] To: mysql@lists.mysql.com Sent

Re: Request problem (with \\)

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 DB Team. - Original Message - From

Re: Table update

= ( 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: mysql@lists.mysql.com Sent: Thursday, January 18, 2007 3:13 AM Subject: Table

Re: how to take advantage of STR_TO_DATE

Hi, STR_TO_DATE() simply converts the given format string to datetime value. So to change the format of the date dispaly, go for DATE_FORMAT(). For Instance, mysql select DATE_FORMAT('2007/10/01','%d/%m/%Y'); or mysql select DATE_FORMAT(datecolumn,'%d/%m/%Y') from table1; Thanks ViSolve DB

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: mysql@lists.mysql.com Sent: Wednesday, January 10, 2007 10:08 PM Subject: Does

Re: store spatial data in mysql

ViSolve DB Team - Original Message - From: CrazyWind [EMAIL PROTECTED] To: mysql@lists.mysql.com 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? Convert it ? Wating

Re: Enum issue

('','Y','N','P') | YES | | NULL| | +---+--+--+-+-+---+ Thanks ViSolve DB Team - Original Message - From: Olaf Stein [EMAIL PROTECTED] To: MySql mysql@lists.mysql.com Sent: Wednesday, January 10, 2007 3:44 AM Subject: Enum issue

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](!?[v$|v])'; Thanks ViSolve DB Team

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, 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 mysql@lists.mysql.com Sent: Monday, January 08, 2007 5:40 PM Subject: Re: MYSQL REGEXP help Hello, this doesn't work

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: mysql@lists.mysql.com Cc: bharath kumar [EMAIL PROTECTED] Sent: Saturday, January 06, 2007 2:07 PM

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 Reed

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

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: mysql@lists.mysql.com Sent: Wednesday, January 03, 2007 8:55 AM Subject: SP not seeing INSERTs

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

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

; resulting in, 1,2,1 Thanks ViSolve DB Team - Original Message - From: bruce [EMAIL PROTECTED] To: mysql@lists.mysql.com 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 something

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 PROTECTED] To: MySql mysql@lists.mysql.com Sent: Friday, January 05

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: mysql@lists.mysql.com Sent: Friday, January 05, 2007 10:23 AM

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: mysql@lists.mysql.com Sent: Friday, December 29, 2006 11:59 AM Subject: SQL syntax Hi, I'm getting the following

Re: SQL syntax

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] To: mysql@lists.mysql.com Sent: Friday, December 29, 2006 11:59 AM Subject: SQL syntax

Re: Max size and row numbers

it. 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: mysql@lists.mysql.com Sent: Friday, December 29, 2006 4:14 AM Subject: Max size and row numbers

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

on past data, then well and good compress the table.[only for myisam] shell myisampack tablename.MYI shellmyisamchk -rq tablename.MYI Thanks ViSolve DB Team - Original Message - From: Asif Lodhi [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, December 21, 2006 5:24 PM

Re: MySQL Data Vanishing with FireFox

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: mysql@lists.mysql.com Sent: Wednesday, December 27, 2006 8:15 PM Subject

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; Thanks, ViSolve DB Team

Re: find date an time of a table update

: Check the user privilege to access the database. If not grant it. Thanks ViSolve DB Team. - Original Message - From: Marcelo Fabiani [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Friday, December 22, 2006 6:21 AM Subject: find date an time of a table update Hi, I didn't find

Re: howto query DELETE all records having invalid table refs

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: mysql@lists.mysql.com Sent: Wednesday, December 20, 2006 3:11 PM Subject: howto query DELETE all records

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 Team - Original

Re: definition of Created_tmp_files in show status

Thanks ViSolve DB Team. - Original Message - From: Kevin Fries [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Thursday, December 14, 2006 9:20 PM Subject: Re: definition of Created_tmp_files in show status Thanks for that. Is the only reason

Re: definition of Created_tmp_files in show status

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 ViSolve DB Team

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 [EMAIL PROTECTED

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 ViSolve DB

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 'myroot'; Thanks ViSolve DB Team

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

, ViSolve DB Team - Original Message - From: C.R.Vegelin [EMAIL PROTECTED] To: mysql@lists.mysql.com 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]; mysql@lists.mysql.com Cc: [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: mysql@lists.mysql.com Sent: Wednesday, December 06, 2006 4

Re: set global does not work

exceeds 'wait_timeout' variable value. Thanks ViSolve DB Team. - Original Message - From: [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, December 07, 2006 11:52 AM Subject: RE: set global does not work Hi: I open a connection via mysql mysqlshow global variables like

Re: +1MB query gets Out of memory

ViSolve DB Team - Original Message - From: nocturnal [EMAIL PROTECTED] To: mysql@lists.mysql.com 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 problem

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 - From: Ted Yu

Re: No of columns in a table

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

Re: Full-text searching with quoted bind variables

. 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 Message - From: William Langshaw [EMAIL PROTECTED] To: mysql

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

/create-table.html Thanks ViSolve DB Team. - Original Message - From: Amit Dor-Shifer [EMAIL PROTECTED] To: mysql@lists.mysql.com 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 created the following

Re: MySql doubt.

,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 PROTECTED]; mysql@lists.mysql.com Sent: Monday, November 27, 2006 12:48 PM

Re: Having Problem With Load Files and AutoNumber id fields

| ++---++ | 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 [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent

Re: Simple doubt

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 PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November

Re: MySql doubt.

| ++---+ 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: Renish [EMAIL

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

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: John Kopanas [EMAIL

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 mysqlSET

Re: AUTOCOMMIT. displaying and setting

. With 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] To: Visolve DB Team

Re: Moving large Innodb table to another mysql

ViSolve DB Team. - Original Message - From: sofox [EMAIL PROTECTED] To: mysql@lists.mysql.com 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) . When I try to moved

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: mysql@lists.mysql.com Sent: Friday, November 17, 2006 10:43 PM Subject: How

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: mysql@lists.mysql.com Sent: Saturday, November 18, 2006 4:35 AM

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] To: VenuGopal Papasani

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: mysql@lists.mysql.com Sent: Saturday, November 11, 2006 7:36 PM Subject: Error:1067 could not start mysql server Dear all, I am

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

Re: wait_timeout help

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 I set the wait_timeout

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: mysql@lists.mysql.com Sent: Thursday, November 09, 2006 6:28 AM Subject: InnoDB

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 [EMAIL PROTECTED

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: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006

Re: wait_timeout help

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 Team Cc: mysql@lists.mysql.com Sent: Tuesday, November 07, 2006 4:12 PM

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: Ahmad Al-Twaijiry

Re: MAX + SUM in one query

| +--+--++ 2 rows in set (0.01 sec) Thanks, ViSolve DB Team. - Original Message - From: Ahmad Al-Twaijiry [EMAIL PROTECTED] To: MySQL List mysql@lists.mysql.com Sent: Monday, November 06, 2006 8:58 AM Subject: MAX + SUM in one query Hi everyone I have the following

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: mysql@lists.mysql.com Sent: Monday, November 06, 2006

Re: MAX + SUM in one query

ViSolve DB Team. - Original Message - From: Ahmad Al-Twaijiry [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Cc: MySQL List mysql@lists.mysql.com Sent: Monday, November 06, 2006 12:10 PM Subject: Re: MAX + SUM in one query Hi no R.RequestENDDate=Date(now()) will work fine (I use

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: mysql@lists.mysql.com Sent: Thursday, November 02, 2006 4:31 PM Subject: Re: More

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

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: mysql@lists.mysql.com Sent: Monday, October 30, 2006 6:30 PM Subject: how to retrieve a list of savepoint in mysql

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: mysql@lists.mysql.com Sent: Friday

  1   2   >