Query Pls
I had a trial version of Navicat 7.2 in my system. Now I installed the full version 7.0.9 enterprise Navicat. After that when I run the existing query,,I get a n error message -Got error 1 from storage engine..Could you guys pls help me I noticed that when I run a small query it works..Is it somethng related to memory? Thanks Renish Koshy
Re: Query Pls
I guess it is nothing to do with the query as it was working perfectly fine be4 installing the Navicat enterprise version 7.0.9 .thanks a lot On 4/17/07, Ananda Kumar [EMAIL PROTECTED] wrote: Hi Renish, What is the query that you ran, please let us know. regards anandkl On 4/17/07, Renish koshy [EMAIL PROTECTED] wrote: I had a trial version of Navicat 7.2 in my system. Now I installed the full version 7.0.9 enterprise Navicat. After that when I run the existing query,,I get a n error message -Got error 1 from storage engine..Could you guys pls help me I noticed that when I run a small query it works..Is it somethng related to memory? Thanks Renish Koshy
Re: MySql doubt.
Great Thanks,, - Original Message - From: ViSolve DB Team [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, November 27, 2006 4:57 PM Subject: Re: MySql doubt. Hi Renish, In case if you dont have the Item field in the Table B. Try the following query select item from a where item not in ( select substring(price,1,instr(price,'-')-1) from b ); This will list out the the items which doesnt have price. mysql select * from a; ++ | item | ++ | book | | pencil | | table | | chair | ++ mysql select * from b; +---+ | price | +---+ | pencil-11 dollars | | book-12 dollars | +---+ mysql select item from a where item not in ( select 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 PROTECTED]; mysql@lists.mysql.com Sent: Monday, November 27, 2006 12:48 PM Subject: Re: MySql doubt. Thanks if in case if we dont have the Item field in the Table B. wat to do..I know the primary key to connect both the tables/ - Original Message - From: ViSolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, November 27, 2006 12:48 PM Subject: Re: MySql doubt. Hi Renish, Here's the answer for your query. mysql select * from a; ++ | item | ++ | book | | pencil | | table | | chair | ++ mysql select * from b; ++---+ | item | price | ++---+ | pencil | 11 dollar | | book | 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: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, November 27, 2006 8:45 AM Subject: MySql doubt. Hi Guys, I have an easy doubt.. Table A consist of field Item and Table B consist of field Price. Table A consists of Items which has price aswell the items which doesnt have price. But In Table B,I have kept only the item which has price . Now, I want to subtract the total items in Table A to the total items in Table B. so I get the items which doesnt have price. I used union its not working.. can any of u guys write the code for it,,, For example Table A ItemBook Pencil Table Table B- which consists of Item with price Price -Book-11 dollar Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Simple doubt
Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple doubt
But if I do like this.. select distinct store, price from Item will both become distinct? How can I make only one distinct ie store distinct regards, - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:18 AM Subject: Re: Simple doubt SELECT DISTINCT ... Renish wrote: Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple doubt
Hello all, I think u guys have mistaken my question,.. The questiion is How will capture the entries which are entered more than once... Like For example Item table Mango Orange Carrot Papaya Mango Mango I want to capture only mango cos it is repeated more than once - Original Message - From: Hal Wigoda [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 11:11 AM Subject: Re: Simple doubt select unique On Nov 27, 2006, at 8:45 PM, Renish wrote: Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple doubt
Dupes - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt But if I do like this.. select distinct store, price from Item will both become distinct? SELECT DISTINCT returns one result row per distinct _result_ row (which will be the same as 'per distinct table row' only if all table columns are selected). The questiion is How will capture the entries which are entered more than once... The set of repeated result rows is the set of result rows discarded by SELECT DISTINCT. Which do you want to return, the distinct rows, or the dupes? PB Renish wrote: But if I do like this.. select distinct store, price from Item will both become distinct? How can I make only one distinct ie store distinct regards, - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:18 AM Subject: Re: Simple doubt SELECT DISTINCT ... Renish wrote: Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple doubt
Smart. and simple .I should have thought for a while:-( - Original Message - From: ViSolve DB Team [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; Hal Wigoda [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:58 AM Subject: Re: Simple doubt Hi Renish, If you want to capture the entries which are entered more than once. Here's the answer for it. mysql select * from a; ++ | b | ++ | pen| | pencil | | rubber | | pen| | paper | | paper | ++ 6 rows in set (0.00 sec) mysql select 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 PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 9:03 AM Subject: Re: Simple doubt Hello all, I think u guys have mistaken my question,.. The questiion is How will capture the entries which are entered more than once... Like For example Item table Mango Orange Carrot Papaya Mango Mango I want to capture only mango cos it is repeated more than once - Original Message - From: Hal Wigoda [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Sent: Tuesday, November 28, 2006 11:11 AM Subject: Re: Simple doubt select unique On Nov 27, 2006, at 8:45 PM, Renish wrote: Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql? [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Simple doubt
How abt to return the distinct rows? - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:48 AM Subject: Re: Simple doubt But if I do like this.. select distinct store, price from Item will both become distinct? SELECT DISTINCT returns one result row per distinct _result_ row (which will be the same as 'per distinct table row' only if all table columns are selected). The questiion is How will capture the entries which are entered more than once... The set of repeated result rows is the set of result rows discarded by SELECT DISTINCT. Which do you want to return, the distinct rows, or the dupes? PB Renish wrote: But if I do like this.. select distinct store, price from Item will both become distinct? How can I make only one distinct ie store distinct regards, - Original Message - From: Peter Brawley [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Tuesday, November 28, 2006 11:18 AM Subject: Re: Simple doubt SELECT DISTINCT ... Renish wrote: Gurus, How do I go about to selecting an item which is repeated more than one in a field in a table. For example Item table Mango Orange Carrot Papaya Mango Mango -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.1.409 / Virus Database: 268.14.18/554 - Release Date: 11/27/2006 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql doubt.
Hi Guys, I have an easy doubt.. Table A consist of field Item and Table B consist of field Price. Table A consists of Items which has price aswell the items which doesnt have price. But In Table B,I have kept only the item which has price . Now, I want to subtract the total items in Table A to the total items in Table B. so I get the items which doesnt have price. I used union its not working.. can any of u guys write the code for it,,, For example Table A ItemBook Pencil Table Table B- which consists of Item with price Price -Book-11 dollar Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
MySql doubt.
Hi Guys, I have an easy doubt.. Table A consist of field Item and Table B consist of field Price. Table A consists of Items which has price aswell the items which doesnt have price. But In Table B,I have kept only the item which has price . Now, I want to subtract the total items in Table A to the total items in Table B. so I get the items which doesnt have price. I used union its not working.. can any of u guys write the code for it,,, For example Table A ItemBook Pencil Table Table B- which consists of Item with price Price -Book-11 dollar Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: MySql doubt.
Thanks if in case if we dont have the Item field in the Table B. wat to do..I know the primary key to connect both the tables/ - Original Message - From: ViSolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, November 27, 2006 12:48 PM Subject: Re: MySql doubt. Hi Renish, Here's the answer for your query. mysql select * from a; ++ | item | ++ | book | | pencil | | table | | chair | ++ mysql select * from b; ++---+ | item | price | ++---+ | pencil | 11 dollar | | book | 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: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, November 27, 2006 8:45 AM Subject: MySql doubt. Hi Guys, I have an easy doubt.. Table A consist of field Item and Table B consist of field Price. Table A consists of Items which has price aswell the items which doesnt have price. But In Table B,I have kept only the item which has price . Now, I want to subtract the total items in Table A to the total items in Table B. so I get the items which doesnt have price. I used union its not working.. can any of u guys write the code for it,,, For example Table A ItemBook Pencil Table Table B- which consists of Item with price Price -Book-11 dollar Pencil-2 dollar Please reply me asap. I hope it should be v. easy enough to tackle. Cheers, Renish koshy -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent please..
All, Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 I want to use PHP as sever side scripting. Cheers, Renish. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent please..
Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: Renish [EMAIL PROTECTED] Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Urgent please..
Thank you very much..excellent support - Original Message - From: Logan, David (SST - Adelaide) [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: mysql@lists.mysql.com; Joshua J. Kugler [EMAIL PROTECTED] Sent: Thursday, November 16, 2006 12:16 PM Subject: RE: Urgent please.. Hi Renish, Perhaps these might be a more appropriate forum and also get you the result you need. This being a database list (I'm sure there are php experts on here) is probably not quite the right place to be asking. One of the php lists may produce a more relevant response. http://www.php.net/mailing-lists.php Regards --- ** _/ ** David Logan *** _/ *** ITO Delivery Specialist - Database *_/* Hewlett-Packard Australia Ltd _/_/_/ _/_/_/ E-Mail: [EMAIL PROTECTED] _/ _/ _/ _/ Desk: +61 8 8408 4273 _/ _/ _/_/_/ Mobile: +61 417 268 665 *_/ ** ** _/ Postal: 148 Frome Street, _/ ** Adelaide SA 5001 Australia invent --- -Original Message- From: Renish [mailto:[EMAIL PROTECTED] Sent: Thursday, 16 November 2006 2:38 PM To: Joshua J. Kugler Cc: mysql@lists.mysql.com Subject: Re: Urgent please.. Ocourse i read the manual . I was unable to do so..ie the reason I asked...I also knew this location mysql@lists.mysql.com - Original Message - From: Joshua J. Kugler [EMAIL PROTECTED] To: mysql@lists.mysql.com Cc: Renish [EMAIL PROTECTED] Sent: Thursday, November 16, 2006 11:20 AM Subject: Re: Urgent please.. On Wednesday 15 November 2006 18:14, Renish wrote: Can anyone tell me..how to install PHP php-5.2.0-Win32 . i click on php.exe and nothing seems to happen. I have intalled 1) webserver-Apache2 2) MySql-41.1 Please read the documentation before asking questions such as these. Thanks. http://www.php.net/manual/en/install.windows.php j -- Joshua Kugler Lead System Admin -- Senior Programmer http://www.eeinternet.com PGP Key: http://pgp.mit.edu/ ID 0xDB26D7CE PO Box 80086 -- Fairbanks, AK 99708 -- Ph: 907-456-5581 Fax: 907-456-3111 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: administrtor-user
in windows.. Pls explain me as though I am a beginner. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, October 23, 2006 12:49 PM Subject: Re: administrtor-user Hi, On which platform? It do good in Linux and Unix. Thanks ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Monday, October 23, 2006 10:05 AM Subject: Re: administrtor-user I am using sql 4.1.21. useradd mysql itself is not working Regards - Original Message - From: Visolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, October 23, 2006 12:17 PM Subject: Re: administrtor-user Hi First, shell useradd mysql Changing UserName and Group name for data directory shell chown -R mysql:mysql data Create Initial database shell scripts/mysql_install_db --user=mysql Start the Server Then to User: First, use the mysql program to connect to the server as the MySQL root user: shell mysql --user=root mysql 1. After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts: mysql GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; [OR] mysql GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 2. mysql INSERT INTO user (Host,User,Password) VALUES('localhost','UN','PWD'); Then to Change Password: 1. Passwords may be assigned from the command line by using the mysqladmin command: shell mysqladmin -u user_name -h host_name password newpwd 2. Another way to assign a password to an account is to issue a SET PASSWORD statement: mysql 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 - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 23, 2006 9:30 AM Subject: administrtor-user Can u guys tell me.. How can I be the administrator for the mysql and thenI I need to create users x, y,z and assign them a password. and give them privilages.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
administrtor-user
Can u guys tell me.. How can I be the administrator for the mysql and thenI I need to create users x, y,z and assign them a password. and give them privilages.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: administrtor-user
I am using sql 4.1.21. useradd mysql itself is not working Regards - Original Message - From: Visolve DB Team To: Renish ; mysql@lists.mysql.com Sent: Monday, October 23, 2006 12:17 PM Subject: Re: administrtor-user Hi First, shell useradd mysql Changing UserName and Group name for data directory shell chown -R mysql:mysql data Create Initial database shell scripts/mysql_install_db --user=mysql Start the Server Then to User: First, use the mysql program to connect to the server as the MySQL root user: shell mysql --user=root mysql 1. After connecting to the server as root, you can add new accounts. The following statements use GRANT to set up four new accounts: mysql GRANT ALL PRIVILEGES ON *.* TO 'monty'@'localhost' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; [OR] mysql GRANT ALL PRIVILEGES ON *.* TO 'monty'@'%' IDENTIFIED BY 'some_pass' WITH GRANT OPTION; 2. mysql INSERT INTO user (Host,User,Password) VALUES('localhost','UN','PWD'); Then to Change Password: 1. Passwords may be assigned from the command line by using the mysqladmin command: shell mysqladmin -u user_name -h host_name password newpwd 2. Another way to assign a password to an account is to issue a SET PASSWORD statement: mysql 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 - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Monday, October 23, 2006 9:30 AM Subject: administrtor-user Can u guys tell me.. How can I be the administrator for the mysql and thenI I need to create users x, y,z and assign them a password. and give them privilages.. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
Thanks dear. i thought u could be of some use in Oracle aswelll - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 1:59 PM Subject: Re: Oracle query.. Renish wrote: Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Well you're *very* much in the wrong list. Why are you posting to a MySQL list if your question has nothing to do with MySQL? You do realise there are Oracle lists, don't you? Surely people there will be able to give you more accurate advice than people here? -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Oracle query..
Hi All, I have oracle 7.3 data available with me..I see many *.ora files and one Import _Rawdata.bat file. . I dont know which one to import. Now I have installed, Oracle 10 g version server and client. Could you pls tell me. how can I import those data into the Oracle 10g so that I could see all the tables. For eample..when I have an SQl file(*.sdl) I used to import it in dos mode like Mysql4.1 binmysql .. .sql -p -u root; Thank you very much. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
Hi Mr Kasak think you misunderstood my question I dont want to Import to MYSQL. I want to import the data into Oracle 10 G. AS I said I have orcle 7.3 data already available with me.. Please tell me in step by step what i should do? as I am new to this field. I appreciate ur time in this matter. Cheers, Renish Koshy - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 11:50 AM Subject: Re: Oracle query.. Renish wrote: Hi All, I have oracle 7.3 data available with me..I see many *.ora files and one Import _Rawdata.bat file. . I dont know which one to import. Now I have installed, Oracle 10 g version server and client. Could you pls tell me. how can I import those data into the Oracle 10g so that I could see all the tables. For eample..when I have an SQl file(*.sdl) I used to import it in dos mode like Mysql4.1 binmysql .. .sql -p -u root; Thank you very much. Regards, Renish There are probably migration tools available to move your data. Check on the MySQL website. If there are tools, I would recommend using them. If you want to do it yourself, you need to export your data from Oracle before importing it into MySQL. Dump each table to a comma-delimited file, and use 'load data infile' to import it into MySQL. Read up on 'load data infile' to find the exact format and commands to use. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Lets imagine I only have Oracle 7.3 data and then import the same data into Oracle 10g I hope this helps Renisn - Original Message - From: Daniel Kasak [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 1:39 PM Subject: Re: Oracle query.. Renish wrote: Hi Mr Kasak think you misunderstood my question I dont want to Import to MYSQL. I want to import the data into Oracle 10 G. AS I said I have orcle 7.3 data already available with me.. Please tell me in step by step what i should do? as I am new to this field. I appreciate ur time in this matter. Ah. Well you're asking the wrong list then. But the general idea is the same. First I would look for a migration tool. Failing that, I would export each table to csv files, create the destination tables in Oracle, and then import from the csv files. But again, migration tools are going to be the best bet, as they will set up your table definitions. There is a *remote* chance that Oracle will be able to import from a 'mysqldump' backup. You can also check that out, but I doubt it will work somehow. -- Daniel Kasak IT Developer NUS Consulting Group Level 5, 77 Pacific Highway North Sydney, NSW, Australia 2060 T: (+61) 2 9922-7676 / F: (+61) 2 9922 7989 email: [EMAIL PROTECTED] website: http://www.nusconsulting.com.au -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Oracle query..
Thank u for ur speedy reply. - Original Message - From: Chris [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED] Cc: Daniel Kasak [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 20, 2006 1:51 PM Subject: Re: Oracle query.. Renish wrote: Hello, Sorry. Again u r wrong.. Thers no connection with MYSQL here. Lets imagine I only have Oracle 7.3 data and then import the same data into Oracle 10g He's saying you need to talk to an oracle mailing list or forum. We don't use oracle so we can't help you. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Import oracle
Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Import oracle
- Original Message - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, October 19, 2006 10:28 AM Subject: Import oracle Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Import oracle
- Original Message - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, October 19, 2006 1:08 PM Subject: Fw: Import oracle - Original Message - From: Renish [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Thursday, October 19, 2006 10:28 AM Subject: Import oracle Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Urgent plsss
Can anyone tell me how can I import the *.gra (oracle db file) files to Navicat or Acess. Pls let me know in steps as I am v new to this field. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Query Help plss
Thank u so much. It woked now! - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED]; Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 1:42 PM Subject: Re: Query Help plss Hi, Hope this link will you. http://mysql.binarycompass.org/doc/refman/4.1/en/can-not-connect-to-server.html Thanks, ViSolve DB Team. - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 11:03 AM Subject: Re: Query Help plss Hi The .err file shows that the service is stopped Normally and no error was found. sure the service is properly shutdown. Try, a) net stop mysql mysqld-nt remove mysqld-nt install net start mysql b) Also run 'services.msc' and double click on the mysql service, 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: Visolve DB Team ; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 12:35 PM Subject: Fw: Query Help plss - Original Message - From: Renish To: mysql@lists.mysql.com ; Visolve DB Team Sent: Tuesday, October 10, 2006 12:34 PM Subject: Re: Query Help plss b) And what happend when you open cmd.exe and run. mysql -u root- It shows cant connect to local host error 10061 *.error file shows this InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 060717 10:32:22 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060717 10:32:23 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 060717 10:32:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060717 10:32:24 InnoDB: Started; log sequence number 0 0 C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections. Version: '4.1.20-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 060717 13:47:31 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown 061009 15:02:37 InnoDB: Starting shutdown... 061009 15:02:42 InnoDB: Shutdown completed; log sequence number 0 543205221 061009 15:02:42 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete 061009 15:03:46 InnoDB: Started; log sequence number 0 543205221 C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections. Version: '4.1.21-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 061010 11:58:13 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown 061010 11:58:13 InnoDB: Starting shutdown... 061010 11:58:15 InnoDB: Shutdown completed; log sequence number 0 543205231 061010 11:58:15 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete - Original Message - From: Visolve DB Team To: Renish Sent: Tuesday, October 10, 2006 12:16 PM Subject: Re: Query Help plss Hi, a) check the file /mysql/data/*.err file and what it shows. b) And what happend when you open cmd.exe and run. mysql -u root Thanks, ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 9:17 AM Subject: Re: Query Help plss - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish koshy [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 11:42 AM Subject: Re: Query Help plss Hi, On which platform? Thanks ViSolve DB Team. - Original Message - From: Renish koshy [EMAIL PROTECTED] To: mysql@lists.mysql.com; [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 8:03 AM Subject: Query Help plss Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Self References Indexes
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish - Original Message - From: Chris [EMAIL PROTECTED] To: m i l e s [EMAIL PROTECTED] Cc: MySQL mysql@lists.mysql.com Sent: Monday, October 09, 2006 4:25 PM Subject: Re: Self References Indexes m i l e s wrote: Hi, Can anyone tell me if this is the correct syntax for a self reference Index ? -- ALTER TABLE `RPI_CTYPE` ADD FOREIGN KEY (`RPI_CT_REPLCID`) REFERENCES `RPI_CTYPE`(`RPI_CT_ID`); -- CREATE INDEX RPI_H_REPLCID_idxfk ON RPI_HOW (RPI_H_REPLCID); If you try it what happens? I don't know if foreign keys can reference itself like that, the best way to find out is to try it. The create index statement will work but it's not going to be on the same table.. don't know if that's a typo or what. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query. Urgent!
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: simple database query
- Original Message - From: Renish [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Monday, October 09, 2006 5:02 PM Subject: Fw: simple database query - Original Message - From: Renish [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Friday, October 06, 2006 12:55 PM Subject: Fw: Renish's simple database query can anyone answer this plss urgent - Original Message - From: Renish [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 05, 2006 12:17 PM Subject: Renish's simple database query Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: simple database query
- Original Message - From: Renish [EMAIL PROTECTED] To: [EMAIL PROTECTED] Cc: [EMAIL PROTECTED] Sent: Monday, October 09, 2006 4:56 PM Subject: Fw: simple database query - Original Message - From: Renish [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, October 05, 2006 12:17 PM Subject: Renish's simple database query Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query...Urgent
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Query Help plss
Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish
Re: Query Help plss
Xp - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish koshy [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 11:42 AM Subject: Re: Query Help plss Hi, On which platform? Thanks ViSolve DB Team. - Original Message - From: Renish koshy [EMAIL PROTECTED] To: mysql@lists.mysql.com; [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 8:03 AM Subject: Query Help plss Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Fw: Query Help plss
- Original Message - From: Renish To: Visolve DB Team ; mysql@lists.mysql.com Sent: Tuesday, October 10, 2006 12:35 PM Subject: Fw: Query Help plss - Original Message - From: Renish To: mysql@lists.mysql.com ; Visolve DB Team Sent: Tuesday, October 10, 2006 12:34 PM Subject: Re: Query Help plss b) And what happend when you open cmd.exe and run. mysql -u root- It shows cant connect to local host error 10061 *.error file shows this InnoDB: The first specified data file .\ibdata1 did not exist: InnoDB: a new database to be created! 060717 10:32:22 InnoDB: Setting file .\ibdata1 size to 10 MB InnoDB: Database physically writes the file full: wait... 060717 10:32:23 InnoDB: Log file .\ib_logfile0 did not exist: new to be created InnoDB: Setting log file .\ib_logfile0 size to 10 MB InnoDB: Database physically writes the file full: wait... 060717 10:32:23 InnoDB: Log file .\ib_logfile1 did not exist: new to be created InnoDB: Setting log file .\ib_logfile1 size to 10 MB InnoDB: Database physically writes the file full: wait... InnoDB: Doublewrite buffer not found: creating new InnoDB: Doublewrite buffer created InnoDB: Creating foreign key constraint system tables InnoDB: Foreign key constraint system tables created 060717 10:32:24 InnoDB: Started; log sequence number 0 0 C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections. Version: '4.1.20-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 060717 13:47:31 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown 061009 15:02:37 InnoDB: Starting shutdown... 061009 15:02:42 InnoDB: Shutdown completed; log sequence number 0 543205221 061009 15:02:42 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete 061009 15:03:46 InnoDB: Started; log sequence number 0 543205221 C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: ready for connections. Version: '4.1.21-community-nt' socket: '' port: 3306 MySQL Community Edition (GPL) 061010 11:58:13 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Normal shutdown 061010 11:58:13 InnoDB: Starting shutdown... 061010 11:58:15 InnoDB: Shutdown completed; log sequence number 0 543205231 061010 11:58:15 [Note] C:\Program Files\MySQL\MySQL Server 4.1\bin\mysqld-nt: Shutdown complete - Original Message - From: Visolve DB Team To: Renish Sent: Tuesday, October 10, 2006 12:16 PM Subject: Re: Query Help plss Hi, a) check the file /mysql/data/*.err file and what it shows. b) And what happend when you open cmd.exe and run. mysql -u root Thanks, ViSolve DB Team. - Original Message - From: Renish [EMAIL PROTECTED] To: Visolve DB Team [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 9:17 AM Subject: Re: Query Help plss - Original Message - From: Visolve DB Team [EMAIL PROTECTED] To: Renish koshy [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 11:42 AM Subject: Re: Query Help plss Hi, On which platform? Thanks ViSolve DB Team. - Original Message - From: Renish koshy [EMAIL PROTECTED] To: mysql@lists.mysql.com; [EMAIL PROTECTED] Sent: Tuesday, October 10, 2006 8:03 AM Subject: Query Help plss Hi all, I have installed MySql 4.1 in my system. when I tried to run Mysql , I always gets this error. Could not start MySql service on a local computer Error 1067: the process terminated unexpectedly. Any help is highly appreciated. Regards, Renish
Re: multiple primary keys on one table?
right... - Original Message - From: Gabriel PREDA [EMAIL PROTECTED] To: Ferindo Middleton [EMAIL PROTECTED] Cc: Dan Buettner [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, October 06, 2006 6:31 PM Subject: Re: multiple primary keys on one table? You will have to UPDATE to NULL those fields, modify the aplication to enter NULL instead of empty-string... Then add the UNIQUE INDEX... In MySQL (unless modified) the dafault is that NULL values are incomparable thus allowing the creation of a UNIQUE INDEX. -- -- -- -- -- -- -- -- -- -- -- -- -- -- Gabriel PREDA Senior Web Developer -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]