Query Execution Time in mysql

is round about 80- 90 secs. The table1 has 7 columns out of which 5 are composite primary keys. No other indexing is provided. I have also tried to use the optimize table table1 command but to no effect. Please let know if any solution is available. Thanks Amit Lonkar

Executing the source c:/Test.sql command

:- String sql = source c:/netapsv1/tempfiles/Test.sql; execute(String sql) executeQuery(String sql) executeUpdate(String sql) Thanks Amit Lonkar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

Executing the source command in Mysql

an SQLException as :- java.sql.SQLException: Syntax error or access violation: You have an error in your SQL syntax near 'source c:/netapsv1/tempfiles/Test.sql' at line 1 Thanks Amit Lonkar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable

Execute Sql File through Java

it? Thanks Amit Lonkar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com - Before posting, please check: http://www.mysql.com/manual.php

Update Query problem

tparameters' at line 1. I guess this is because subselects fail in mysql. Can any one tell me how to overcome this problem. Regards Amit Lonkar __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com

Table Handler Errors

Hi All! I am using mysql-.3.23.49 on windows. It generates the following error:- General error: Incorrect key file for table: 'lotjob'. Try to repair it . or some times it generates a table handler error. why do these errors occur? Regards Amit Lonkar

select query error

am using mysql 3.23.49. Please let of what could be wrong. Regards Amit Lonkar __ Do you Yahoo!? U2 on LAUNCH - Exclusive greatest hits videos http://launch.yahoo.com/u2 - Before

Query problem

Hi all Does mysql support simple joins? I am trying to run the following query:- select red,green,blue from colorchanger where colorcode = select value from jobattributekit where attributekit = Color and jobnumber = 28200124RB4-001 and scenario=JN75K; ColorChanger Table:- ColorCode Color

Mysql Crashed

the the table type to Innodb; Please help Regards Amit Lonkar __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com - Before posting, please check: http

Access Denied

Hi All, Can someone help me figure out the following problem. If i fire the following command from D:\mysql\bin mysql --user=netaps --password=netaps --host=192.168.100.2 --port=3306 --database=netaps --execute=LOAD DATA INFILE 'D:\\NetapsFiles\\jobsequence.csv' INTO TABLE jobsequence FIELDS

Connect to Mysql Server

' INTO TABLE jobbatch FIELDS TERMINATED BY ','; But when I run the batch file, it generates the error 'mysql' is unknown command, naturally as mysql is not installed here. Now how do I connect to Mysql on System1 using the above command. Thanks Amit Lonkar

Loops in Mysql

this can be done. Thanks Amit Lonkar __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check: http

Transact Sql

hi Does Mysql support Transat SQL??? Amit __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ - Before posting, please check:

URGENT

: 'testtable' Please do reply This is urgent Thanks Amit Lonkar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com - Before posting, please

Problems in Foreign Key Syntax

varchar(10) not null, scenario char(10) not null, index attkit_sce_ind(scenario), foreign key (scenario) references scenario(scenario)) type = innodb; Here in this table if I convert the varchar to char then this query works. Why is this So? Please do reply Thanks Amit Lonkar

Check Constraint In Mysql

Hi !!! Is there a check constraint available in Mysql? If there is one plase send the Syntax as well Amit Lonkar __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com

Problems in Foreign Key Syntax

it is giving the error as:- ERROR 1005: Can't create table '.\netaps\AttributeValue.frm' (errno: 150) Please help Urgent Thanks Amit Lonkar. Amit __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com