copy the result content from one db to another

I would like to copy the contents of result set by single command e.g., select * from db1 where id < 3; result 1 result 2 now how to write this results into another db without writing to a text file (outtext)... when both source and destination has the same structure thanks m.karthikeyan -

Time consuming table regeneration: JAVA & MySQL

I am in the process of regenerating all the tables as per the requirement of custom designed JAVA and JSP codes for 'chemistry' application. It requires lot of time to read, modify and write back to database. The Total number of data points per table containing various types of data (INT, VARCHAR,

Re: regexp with - '-' or "-" like phone numbers e.g: d-dd-d dd-dd-d ddd-dd-d dddd-dd-d

... I belive.. Experts help required for single query.. karthikeyan -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

regexp with - '-' or "-" like phone numbers e.g: d-dd-d dd-dd-d ddd-dd-d dddd-dd-d

I have one query: how to use regular expression to search all digits of the pattern in MYSQL X-XX-X XX-XX-X XXX-XX-X -XX-X X-XX-X I tried mysql> select * from database where field regexp "(\d{2,5}-\d{2}-d{1}d{1})"; others: *-*-* ??-??-? ???-??-? (\d{2,5})?- etc, seems not working

How to query mySQL in java without using actual column names? but using something like field(0),field(1) etc.,

I have a table with about 100 column with different column name. It is difficult to remember all the field names. But I know the last few columns are very important for query and used frequently. For example: Table with fields weight_42(double),width_43(double),height_44(double) where the fields(4

Urgent Pl: problem with rename the field name: IN

how to rename a field name "IN" to something else.. I could not use alter table tbl_name change IN NEW mediumtext; Pl. suggest how to rename particular "field name" for all the tables in a database thanks M.Karthikeyan -- MySQL General Mailing List For list archives: http://lists.mysql.com/my

how to display blob data back to text

i get in my web page 3 Test2 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan 2 Test1 [EMAIL PROTECTED] 03/19/2003 06:28 PM karthikeyan Can i tweak the query so that i can display BLOB data properly. Have a great day. Karthikeyan. -- Karthikeyan Balasubramanian [EMAIL PROTECTED] --

Test Please Ignore :)

Test -- Karthikeyan Balasubramanian [EMAIL PROTECTED] -- http://www.fastmail.fm - Access your email from home and the web - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

FullText Query

ubstring of a column value. Is it possible. Thanking you yours Karthikeyan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this th

Help required MySql + PHP

an any one provide a solution. Thanks in advance yours Karthikeyan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

MyOLEDB problem

ution" Help me Thanks in advance yours Karthikeyan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-ma

OLE DB Problem

ance yours Karthikeyan - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe