Query Execution Time in mysql

to execute the above query 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

Executing the source command in Mysql

t.sql"; But it generates 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

Executing the "source c:/Test.sql" command

/Test.sql' at line 1" :- 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

Update Query problem

t duedate from impor 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

Execute Sql File through Java

do I do 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/

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 A

select query error

ccur every time. It comes very rarely. I 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 vid

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

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 TE

Connect to Mysql Server

.csv' 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 usin

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

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:

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 posti

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

utekit(attributekit), value 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. Wh

Problems in Foreign Key Syntax

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