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 JOI

Re: MysqlDump destination file

can 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, N

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

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

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 |

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 Dece

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

Re: Stable MySQL Version

ct your product 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

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:

Stable MySQL Version

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 arch

using SSL certificates when connecting to mysqld

ode via MySQL's options? Same issues arise when I setup a replication connection with SSL. Is SSL in MySQL then encrypted, yet-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]

Logging aborted_connects to error log instead of gen. log

rrect 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

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

Index_length: 1496064 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

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

5. Is 'mysqld --verbose' the suggested way to test reading 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 ar

Replication error: Unable to get certificate

ication is happening and IS secured after all? I've found this bug: http://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 M

Re: AUTOCOMMIT. displaying and setting

o, how? Specifically, how 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 Autocomm

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 o

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

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

Link error when using prepared statements in mysql 4.1.0 alpha

error: 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. - A

Link error when using prepared statements in mysql 4.1.0 alpha

error: 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. - A

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

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 nee

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 throug

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

mysqlbug

et '/var/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:/

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

syntax near 'select value from jobattr ibutekit where attributekit = "Color" and jobnumber = "' at line 1 Thanks Amit __ Do You Yahoo!? HotJob

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

ot;select count(*) from jobbatch"; It works fine. Plase Help REgards Amit __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/

can i use java stored procedure

;java'; 3) Then execute it using cmd: SELECT mypi(); Plz reply me as soon as possible. Rgds, Amit Mittal, India. Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from 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

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:

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:

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) To

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 p

Mysql Row Lock Problem

his lock ? Also If i have 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 man

Mysql Commit Problem

alse). The "returValue" 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)

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 repl

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 - B

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 Lon

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 A

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

UPDATE problem

I | | || | actualword | char(20) | YES | | NULL|| ++--+--+-+-++ Can someone tell me what the problem is and is there some way to get around it.. -Amit - Before posting

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

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) To

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 o

Problem to create a database on red hat 7

error number. 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 <[EM