sql_big_selects and max_join_size

I am getting ERROR 1104 (42000): The SELECT would examine more than MAX_JOIN_SIZE rows; check your WHERE and use SET SQL_BIG_SELECTS=1 or SET SQL_MAX_JOIN_SIZE=# if the SELECT is okay on the following query. mysql SELECT ord.*, pt.authorize_transaction_id FROM store_orders as ord LEFT OUTER JOIN

Re: MysqlDump destination file

name it as an extension of .sql, however while you import it back it doesnt matter whether your backed up file is on .sql extension or not. Though the idea of keeping extensions is to always help you identify the type of files. Best regards, Amit Sharma On Fri, Dec 19, 2008 at 1:11 PM, Nanu

Re: Stopping using a server as a slave

Hi Jesse, Just add 'skip-slave-start' to your configuration file, restart there you go. Best regards, Amit Sharma On Tue, Nov 25, 2008 at 7:12 PM, Jesse [EMAIL PROTECTED] wrote: I have a server that I've been using as a MySQL Slave for a while now. I want to change it over to a regular

Re: How could i check the following values in MySQL Server 5.0

Hi Sudhir, #show table status command will give you most of what all is required. Have a look at the results post any further query if you have. Regards, Amit Sharma On Thu, Oct 9, 2008 at 6:44 PM, Sudhir Menon [EMAIL PROTECTED] wrote: Hi all, I would like to check or set the following

RE: LEFT JOIN and RIGHT JOIN

Example: mysql select * from tableA; +---+--+ | name | age | +---+--+ | Amit | 27 | | Sumit | 31 | | Anand | 29 | | Parry | 32 | +---+--+ mysql select * from tableB; +---++ | name | Salary | +---++ | Amit | 5 | | Sumit | 6

RE: Problems Adding User

My guess: The user could already be there. Is this a fresh DB, can you check the server logs for more info? Regards, Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk -Original Message- From: Victor Subervi [mailto:[EMAIL PROTECTED] Sent: 20 December 2007 22

Re: Stable MySQL Version

vendor 2. mysql-noinstall-5.0.45-winx64 [63336KB] == mysqld.exe is not a valid win32 application 3. Setup [53872KB] == This installation package is not supported by this processor type. Contact your product vendor Thanks Amit Tiago Cruz [EMAIL PROTECTED] wrote: On Wed, 2007-12-05 at 07:13

Re: Stable MySQL Version

Thanks Rob Team, Installer mysql-essential-5.0.45-win32 worked for me. Rob Wultsch [EMAIL PROTECTED] wrote: On Dec 19, 2007 5:26 AM, Amit Nair wrote: Hi Team Sorry for replying late, I have downloaded tried installation with 3 installers. I am getting the below messsage while trying

RE: Does anyone know how mysql works for mutiple kernels of a cpu.

Hi Moon's Father, I thought you meant how mysql works for multiple processors of a cpu. If so, have a look at 'http://www.google.com/search?q=mysql+for+multiple+processors' Regards, Amit Sharma [EMAIL PROTECTED] Amit Sharma E: [EMAIL PROTECTED] M: +91 9971 490 700 W: www.affle.co.uk

Stable MySQL Version

, but it was not even getting installed. Thanks Amit - Never miss a thing. Make Yahoo your homepage.

Unable to GRANT REPLICATION REQUIRE X509 and SSL

Is it possible to require both secure connections and x509 verification on a replication user? If so, what's the syntax? I couldn't find references to this use in the manual, lists or bug tracking system. Using mysql 4.1.21 10x, Amit -- MySQL General Mailing List For list archives: http

Logging aborted_connects to error log instead of gen. log

password. * If these kinds of things happen, it might indicate that someone is trying to break into your server! I see that this event is written to the general log. Is there a way to log such an event to the error log? Amit -- MySQL General Mailing List For list

using SSL certificates when connecting to mysqld

-not-secure (in terms of identification)? Thanks, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

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

Data_free: 163680 Auto_increment: 67217 Create_time: 2006-11-01 15:41:20 Update_time: 2006-11-28 11:42:13 Check_time: NULL Collation: utf8_general_ci Checksum: NULL Create_options: Comment: Thanks, Amit -- MySQL General Mailing List For list archives: http

bind-address: settable via /etc/mysql/my.cnf only?

of configuration/option files? If not, what is the recommended procedure? 6. Is there a way to query 'bind-address' via mysql console/mysqladmin? Thanks, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Replication error: Unable to get certificate

://bugs.mysql.com/bug.php?id=11169 Is this the same issue? As I'm currently using a lesser version than that for-which this bug is reported, can I assume an upgrade will solve it? Thanks, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: AUTOCOMMIT. displaying and setting

do I set it for a none-console connection (e.g. my previously mentioned jdbc connection)? BTW: # mysql --version mysql Ver 14.7 Distrib 4.1.21, for pc-linux-gnu (i686) using readline 5.1 Amit Visolve DB Team wrote: There is no global system variable to set Autocommit; but we can achieve

mysqldump question

Hi: i was wondering if there's any way to limit the bandwidth used by mysqldump to dump data from remote hosts. since i couldn't find any documentation on this, i assume that mysqldump will use all the available bandwidth of the network. the issue is that i'm looking to fetch data to the tune

mysqldump feature request

Hi: I am using mysql 4.1.10 for a while now, and i was wondering how painful it would be to tweak the mysqldump to support an additional option, --insert-ignore , which instructs it to create the dump files with INSERT IGNORE blah blah instead of just INSERT blah blah i have actually modified

question on autoincrement

Hi All, I was wondering if there was a way in mySQL wherein I tell the autoincrement spec where to start from? Eg. Autoincrement startfrom 1 And the values go in as: 10001..10002 and so on,.. instead of 1..2..3.. ..like sequencing in oracle… Any help is appreciated, Thanks Amit Wadhwa Data

Link error when using prepared statements in mysql 4.1.0 alpha

: ctype-latin1_de.c fatal error C1083: Cannot open source file: 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alpha\strings\ctyp e-latin1_de.c': No such file or directory ctype-mb.c Do I need to do some steps before compiling this? I will appreciate help on this. - AMit -- MySQL

Link error when using prepared statements in mysql 4.1.0 alpha

: ctype-latin1_de.c fatal error C1083: Cannot open source file: 'D:\WorkDownloads\MySQL\mysql-4.1.0-alpha-src\mysql-4.1.0-alpha\strings\ctyp e-latin1_de.c': No such file or directory ctype-mb.c Do I need to do some steps before compiling this? I will appreciate help on this. - AMit -- MySQL

RE: Link error when using prepared statements in mysql 4.1.0 alph a

Thank you Mike. I would like to continue development on this version, so I will try out the BK. I got the linking errors fixed. Those were from the definitions missing in the export file. Is there a release date planned for 4.1.1? Thanks! AMit -Original Message- From: Mark Matthews

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

mySQL stops responding in the morning

I have an app running on Tomcat 4.0.6. The app access mySQL Ver 11.18 Distrib 3.23.54, for sun-solaris2.9 (sparc) on Solaris 9. the app runs fine during the day, but when I come back to work in the morning, I see that the database connection has died and mySQL does not respond anymore. What

Subscription Required

Dear sir/Madam I am a mysql developer and want to keep myself updating the events with MySQL. Thanking You Regards Amit Prakash Software Engineer Savitr Software Services (P) Ltd. Hyderabad - Before posting, please check

Views

I wanted to use the Views feature that is available in Oracle which is the counterpart of Queries available in MS Access. mySQL does not support views at the moment. Is there a way I can achieve my goals ? The purpose of having a view/query is that I want to access data from that view/query

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

mysqlbug

/lib/mysql/mysql.sock' (111). How to solve this error. or how to unstall binary version . so that i can reinstall rpm version. thanks amit _ The new MSN 8: smart spam protection and 2 months FREE* http://join.msn.com/?page

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

jobattr ibutekit where attributekit = Color and jobnumber = ' at line 1 Thanks Amit __ Do You Yahoo!? HotJobs - Search Thousands of New Jobs http://www.hotjobs.com - Before

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

fine. Plase Help REgards Amit __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ - Before posting, please check: http

Connect to Mysql Server

Hi All!! I have two machines on network System1 and System2. Mysql is installed on System1. On System2 I have a batch file which has the following command:- mysql --user=amit --password=amit --host=system1 --port =3306 --database=netaps --execute=LOAD DATA INFILE 'C:\\Amit\\JobBatch.csv

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

Export Data From Mysql to CSV

Hi How can I export data, from the database tables in Mysql, to a Comma Seperated File(CSV). Urgent Amit Lonkar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

Mysql Functions

Hi Can anyone tell me how to call Mysql UDF functions from Java?? Thanks Amit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Decrypt Password

Hi Can anyone tell me if there is a function as DECRYPT. If there is not, then how to decrypt a field which is Encrypted by the Mysql function ENCRYPT. URGENT Thanks Amit Lonkar - Before posting, please check: http

Re: Re: Innodb Row Locks

Mysql Row Locking On Wed, 13 Feb 2002 [EMAIL PROTECTED] wrote : Your message cannot be posted because it appears to be either spam or simply off topic to our filter. To bypass the filter you must include one of the following words in your message: sql,query If you just reply to

Mysql Commit Problem

is returned as 0 when the query is fired. Amit - 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

Mysql Row Lock Problem

to give the commit command through java how do i give it. Please Reply Urgently Thanks a Lot Amit Lonkar - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

JDBC Driver

Hi!!!=0A=0AI am using the Mysql JDBC Driver 2.0.11. I am trying to use the = methods getImportedKeys(), and getExportedKeys()=0A=0ABut it returns an emp= ty result set.=0A=0AI am using Innodb tables.=0A=0AThanks =0AAmit =0A -

JDBC Driver

Hi!!! I am using the Mysql JDBC Driver 2.0.11. I am trying to use the methods getImportedKeys(), and getExportedKeys() But it returns an empty result set. I am using Innodb tables. Thanks Amit - Before posting, please

Query Problem Please Help

I am trying to fire the following query but it is generating an error:- select color from colortable where colorcode = select max(colorcode) from colortable where colorcode = 5 Please Help Thanks Amit Lonkar

Nested Queries

Hi!! I am trying to execute the following query. But it is giving an error at select max(columnname). select columname from tablename where columname1 = select max(columnname) from tablename Thanks Amit Lonkar

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

UPDATE problem

|| ++--+--+-+-++ Can someone tell me what the problem is and is there some way to get around it.. -Amit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http

Newbie queries

Hi I am new to My SQL and have just installed it on a Win 98 machine. can you recommend any good front end tool to generate reports ? At present the interface available for both input and output is phpAdmin. Also how does one import data from excel; is it possible ? ans

Problem

be opened up continously or something else. Any input would be highly appreciated. Amit - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Enquiry

Dear Sir, This a mail from a new established software company. We are developing a software using vb6.0 as front-end and want to use MYSQL as back-end. We have already downloaded it from your site. It was the latest version MYSQL 3.23 for win95/98. But now we don't know how to install it on

Problem to create a database on red hat 7

er. Please retrieve asap. Regards Amit - 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 PROTECTE