Re[2]: select query syntax

no , i havn't any key with AUTO_INCREMENT option i wont numbered my rows on fly! how to do it. pleease help me!!! RT> supposed you numbered all rows in the table incrementally in field nid: RT> select mydata from mytable where mod(nid, N)=offset; RT> fill in N and offset (0..n-1) RT> On Sat, 28

Re: GUI client for large SELECT query results

> With mysql_use_result () I have the problem, that the client do not > know in front, how many records matched the query. > > But if the GUI client user wants to see the last but 30 query result > records, e.g., > I have to know recordnumber of the last matching record. Having a simple "select *

GUI client for large SELECT query results

Hello all, I'm using the libmysql.dll API to interface to a mySQL-Server Database. The GUI client is generic, so the user can bind any SELECT query on a large database (Logging database). How can I prevent the mySQL client to use mysql_store_result (), since this would transfer the whole query r

accessing mysql via a c program

Hello, were can I find documentation regarding accessing mysql database via a c program?maybe some examples of a simple c program. Thanks Dana - Before posting, please check: http://www.mysql.com/manual.php (the manual) h

help please

Hi all, I just want to create a webbased mailing tool using PHP/Mysql...I've done using the fuction mail()...But if i need to have a option 'Attachment' then in which way i can do that. Can u pl.help me out.If u know any sites reg.that,let me know pl. Thanx in adv. kala

Re: Port MS SQL Database To MySQL ??

See: http://www.kofler.cc/mysql/mssql2mysql.html (converts schema + data, no SPs, no triggers, no views etc.; GPL) Best wishes, Michael Kofler - Before posting, please check: http://www.mysql.com/manual.php (the ma

Re: Optimization of MySQL

On Wed, May 02, 2001 at 08:40:10AM +0200, Warren van der Merwe wrote: > Hi there > > Is there anything similar to this that will run on a Windows platform? As luck would have it, yes. I managed to get mytop working on Windows today. There are a few rough edges, but with about 20 minutes more wor

update the results of a select statement

This should be easy. I just want to update the results of a select statement and want to gather the syntax. ex. select * from where = 1 and = 2; I am looking to simply update the results of this query. Any hints are appreciated. Jeramey James [EMAIL PROTECTED] ---

compatible with oracle

Hi, we have some our groupware products,written in java using 3 tier archi. front end -jsps running on tomcat/apache bissiness logic- ejb running on ias back end - oracle we have written some stored procedures,trigers for oracle. Now we want to use Mysql as the database as well as the oracle.Actu

cannot protect with user password

i used the mysql 3.23.37 for windows, i can grant new user with this statement : grant all on *.* to said@'%' identified by 'general' ; flush privileges ; why the user can log into database without using his password : mysqlc -u said

Re: cannot protect user with password

At 10:47 AM +0700 5/3/01, Said Badrul Nahar wrote: >i used the mysql 3.23.37 for windows, >i can grant new user with this statement : > grant all on *.* to said@'%' identified by 'general' ; > flush privileges ; >why the user can log into database without using his password : > mysqlc

I'm having a problem on FULLTEXT INDEX....

Hi there, I'm trying to search a double-bytes word in my database. If the word I search is English(single-byte word), it perfectly works. But once I try to search a double-bytes word(such as Japanese), I don't get any results even though the word is in the table... I know if the word is shorter

Mysqld

When I try to run mysqld I get the following message. How do I rebuild the .sock file. It is not where it should be and the one's that are there are 0 bites Any suggestions al -- Al Green Softouch Computer Solutions 2nd Floor 334 53rd Avenue SE Calgary, Alberta, T2H-0N3 Fax: 403-258-0267 Phone

cannot protect user with password

i used the mysql 3.23.37 for windows, i can grant new user with this statement : grant all on *.* to said@'%' identified by 'general' ; flush privileges ; why the user can log into database without using his password : mysqlc -u said

Using with Access 97

Hi, I am just now trying to use MySql. I have been told that I can upload a new table to my hosting server through Access. I can connect but I get a strange SQL Error that states: [TCX] [MyODBC] You have an error in your SQL syntax near '_set, _set,_set)' at line 1 (#1064) Anyone have any

Re[2]: can not see data or tables in database

Hello Paul, It is a Linux system but I have never had this problem before where do I look for this busted C library Wednesday, May 02, 2001, 6:14:34 PM, you wrote: Paul> At 4:27 PM -0700 5/2/01, Richard Kurth wrote: >>I set up a couple of databases last night in mysql and every thing is >>wor

Re: specifying a delimiter

At 9:11 PM -0500 5/2/01, Paul DuBois wrote: >At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >>Hi, >>Being new to MySQL, I am having a problem getting output from it to the >>shell that is formatted the way I need. I need a table to be written to a >>file with a delimiter. >>something like : >

Solaris 2.6 Binary

I was wondering if anyone out there has a pre-compiled Binary for MySQL Solaris 2.6 for either Sparc or Intel; preferrably Intel and preferrably within < 14 minor version differences (most recent on Web-page is 3.23.23). We've attempted compiling from source multiple times, always ending up with

working on binary data with jdbc

I am writing a java app that saves binary data into a mysql BLOB column. I am having trouble escaping the ascii(0) character. Since Java is unicode, how do you represent the ASCII 0 character? Any help is much appreciated. And sorry, but java sucks. I could do all the escaping in Perl in 1

Re: Question(s) regarding Build options

At 5:41 PM -0400 5/1/01, Kevin Ford wrote: >Hello; > >I have looked throught MySQL's website and to no avail, was unable to find a >document that has a detailed description of the configurable build options. >ie. --sharedstatedir --localstatedir --datadir > >If anyone could point me to a relev

Re: user setting own password.

At 4:50 PM -0700 5/1/01, Dato wrote: >how does a user set his own password in mysql? I have searched >through the archives, and have found only the 'st password..' >command. this does not work. In my case, there are more then just >one host in the user table and the set password command only ch

Re: What do I do now?

At 11:52 PM -0600 5/1/01, Colin Faber wrote: >why not just use the LOAD DATA INFILE option? That probably won't help much. All the mysqlimport does is issue a LOAD DATA statement for you. LOAD DATA LOCAL INFILE might help, though. Or mysqlimport --local. At least, if the file_name.csv file is

Re: i could just cry . . . mysql dead

At 8:45 AM +0700 5/3/01, Taing Nguonq wrote: >Why you said that " Do not use Mysql on RadHat' CD"? Which is the >problem?Thanks RedHat's RPMs are broken. What happened when you tried rpm -e? Better to build from source or use mysql.com RPMs. > >Rolf Hopkins wrote: > >> Strongly suggest you go

Re: windoze and batch files

Stan: We do it every day. Use notepad (or whatever text editor you have available) to create the query file and save it a folder. Make sure C:\MYSQL\BIN is in your path, and open a DOS prompt. CD\ to the folder with the query file, and run it with a command line like: mysql -u{username} -p {dbn

Re: specifying a delimiter

At 10:01 AM -0500 5/2/01, [EMAIL PROTECTED] wrote: >Hi, >Being new to MySQL, I am having a problem getting output from it to the >shell that is formatted the way I need. I need a table to be written to a >file with a delimiter. >something like : > >#!/bin/sh >mysql -uroot -ptest database < sql >

Re: i could just cry . . . mysql dead

Redhat's version of mysql has problems or known to. It's always better from source anyway. - Original Message - From: "Taing Nguonq" <[EMAIL PROTECTED]> To: "Rolf Hopkins" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Thursday, May 03, 2001 9:45 Subject: Re: i could just cry . . . my

Preparing SQL Statements

Hi, I was wondering if MySQL allows the ability to perform a SQL Prepare on sql statements prior to performing an execute. I'm using ADO on Windows and with a CommandPtr object, you can set a property called "Prepared", that will attempt to prepare sql statements and will keep them prepared for

Re: i could just cry . . . mysql dead

Why you said that " Do not use Mysql on RadHat' CD"? Which is the problem?Thanks Rolf Hopkins wrote: > Strongly suggest you go to the MySQL website and get mysql from there. Do > not use redhat's mysql. > > - Original Message - > From: "Marc Bragg" <[EMAIL PROTECTED]> > To: <[EMAIL PROT

Re: DELETE question

At 1:43 PM -0500 5/2/01, Dawn H wrote: >Anybody got a clue why this isn't deleting? The number is input in the >previous section of code and I know it works correctly, but for some reason How do you know? >when it gets to here, it just skips to view (apparently), (even if I # out >the Lock lines

Re: Date comparisions...

On Wed, May 02, 2001 at 04:00:17PM +0100, Roo wrote: > Hi all, > > I was recently attempting what I thought would be an easy search. I > wanted to return all records with a birthdate (a DATE column) 'within' > 30 days of the current date. > > The birthdate is stored as a -MM-DD, I have been

Re: i could just cry . . . mysql dead

Strongly suggest you go to the MySQL website and get mysql from there. Do not use redhat's mysql. - Original Message - From: "Marc Bragg" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Thursday, May 03, 2001 7:27 Subject: i could just cry . . . mysql dead > I in

Re: restore 'dumped' database

At 3:15 PM -0700 5/2/01, Brian Warn wrote: >Hi, > >How do I restore a copied database that I've created with mysqldump? >I have both the DuBois book and, of course, the online manual handy. >I'm obviously looking in the wrong area of them because I can't find >anything (I thought the keyword 'r

Re: can not see data or tables in database

At 4:27 PM -0700 5/2/01, Richard Kurth wrote: >I set up a couple of databases last night in mysql and every thing is >working just fine. Today when I try to access the data it is not there >Using phpMyAdmin when I look at the databases that are completely empty >of tables and data that also includ

Re: windoze and batch files

At 10:23 AM +1000 5/3/01, Bordeaux Stan wrote: >Hi all, >unfortunately, I am forced to do some background mysql development work on a >windoze box, which for reasons I wont go into here requires that I use the >mysql console client. As many would know this does not allow any commands >to be edite

Re: Date comparisions...

There are a whole heap of very useful date functions in chapter 7 of the manual that will make all your problems disappear. - Original Message - From: "Roo" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, May 02, 2001 23:00 Subject: Date comparisions... > Hi all, > > I was

Re: windoze and batch files

Perhaps you can type the query in notepad, and then past it into the mysql client's window. If that is not suitable and you still want to go with the batch file scheme, type "type batchfilename | mysql -u ... " ryan > Hi all, > unfortunately, I am forced to do some background mysql development

Solaris Installation problems

Thanks. I got the gtar from the download page. Now I have unpacked it with mysql-3.23.37-sun-solaris2.7-sparc directory But I have another problems with running scripts/mysql_install_db % scripts/mysql_install_db ld.so.1: ./bin/my_print_defaults: fatal: libcrypt_i.so.

windoze and batch files

Hi all, unfortunately, I am forced to do some background mysql development work on a windoze box, which for reasons I wont go into here requires that I use the mysql console client. As many would know this does not allow any commands to be edited in the console as does linux. I decided that it

RE: Unusual dependency error w/ rpm??

because of problems w/ MySQL:Perl:DBD I need to either install MySQL from an rpm, or re-install Perl from a binary. The MySQL installed from binary ok, so I guess I'll keep it and recompile Perl. Perl was originally installed on my box from an rpm. I assume a recompile means uninstall & reinst

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

You can look into increasing the number of allowed connections that MySQL will accept... are you using connect or pconnect? At 04:23 PM 5/3/2001 -0700, Gary Bickford wrote: >Repost - nobody has any ideas? I've run some stress tests, sending >several thousand page requests, and the number of mys

can not see data or tables in database

I set up a couple of databases last night in mysql and every thing is working just fine. Today when I try to access the data it is not there Using phpMyAdmin when I look at the databases that are completely empty of tables and data that also includes the mysql database. If I start up telnet and go

Re: Apache/PHP/MySQL - processes multiply until about 30, then doom

Repost - nobody has any ideas? I've run some stress tests, sending several thousand page requests, and the number of mysql processes goes up and down but over time continues to rise. It's up to about 22 now. When it gets to about 30, every request from the web server will be will fail. Cou

Re: Unusual dependency error w/ rpm??

Odd... could be different versions or something. If you're sure you have them install the RPM with --nodeps I still HIGHLY recommend a source install, it's very simple and you have a lot more control. At 04:09 PM 5/2/2001 -0700, Chris Becker wrote: >Please Help... > >I do believe I have thes

i could just cry . . . mysql dead

I installed 7.0 with mysql on the redhat cd, and for a while it worked, then stopped. reinstalled everything, and now get: for /etc/rc.d/rc3.d/S85mysqld status mysqld dead but subsys locked Would partially run on safe_mysqld until I followed page 417 in the mysql manuyal, and now i get a very

Unusual dependency error w/ rpm??

Please Help... I do believe I have these dependencies, why am I getting these errors? Running RH6.2 / INtel /mysql>rpm -i MySQL-3.23.37-1.i386.rpm failed dependencies: /bin/sh is needed by MySQL-3.23.37-1 /bin/sh is needed by MySQL-3.23.37-1 /usr/bin/perl is needed by M

Re: Install Problems ? Solaris

There is a bug in the Solaris tar, it even says so on the download page. Get GNU Tar, it's also listed on the download page. At 03:36 PM 5/2/2001 -0700, EXT-Chung, Kenneth wrote: > Solaris > > I have downloaded mysql-3.23.37-sun-solaris2.7-sparc.tar.gz, > > try unpack with

Install Problems ? Solaris

Solaris I have downloaded mysql-3.23.37-sun-solaris2.7-sparc.tar.gz, try unpack with with following command gzip -dc mysql-3.23.37-sun-solaris2.7-sparc.tar.gz | tar -xvf - I got following error . x mysql-3.23.37-sun-solaris2.7-sparc/sql

Install problems ?

AIX 4.3.3 I have downloaded the mysql-3.23.37-ibm-aix4.3.3.0-rs6000.tar.gz binary, unpacked it with the following command % gzip -dc mysql-3.23.37-ibm-aix4.3.3.0-rs6000.tar.gz | tar -xvf - I skipped groupdadd and useradd because I am not a system adminis

Re: restore 'dumped' database

Check out mysqlimport and LOAD DATA INFILE, as well as the documentation for mysqldump: http://www.mysql.com/doc/m/y/mysqlimport.html http://www.mysql.com/doc/L/O/LOAD_DATA.html http://www.mysql.com/doc/m/y/mysqldump.html On Wed, 2 May 2001, Brian Warn wrote: > Hi, > > How do I restore a copie

restore 'dumped' database

Hi, How do I restore a copied database that I've created with mysqldump? I have both the DuBois book and, of course, the online manual handy. I'm obviously looking in the wrong area of them because I can't find anything (I thought the keyword 'restore' would net me something, but no joy). I

JOIN query gone awry

Greetings. I have two tables that are identical in structure, but each contains data for different years. Here is the desc of the first table: mysql> desc counts2000; +-+-+--+-+-+---+ | Field | Type| Null

How do I turn the Query Log option OFF?

I need to be able to turn the Query log option off, and cannot figure out how to do that. I have enabled --log-bin logging, to capture any update commands, but cannot figure out how to turn query logging off. In the mySQL doc it says to alter the mysql.server script -- but nowhere in the script

Current row number

How can you get the current row number in a query? Example: ROW_NUMBER (not ID) DATA - 1 AAA 2 BBB ... _

Re: missing doc: identified by password

I guess I didn't phrase my point properly due to the emails I have been recieving =). I'm just stating that this feature isn't documented in the manual though it probably should be. sorry for the confusion. thanks, -- Andrew - Original Message - From: "Andrew Schmidt" <[EMAIL PROTECTE

Mysql and Powerbuilder - retrieval arguments

Hi All, I recently started development on an application using Powerbuilder and Mysql, and quickly discovered a frustrating problem. Most of my database tables are based on integer keys, and therefore, most datawindows I design have numeric retrieval arguments. The problem is, powerbuilder co

Problem with multi-part keys

Hello All, I've bumped into a problem and can't figure out how to solve it. If anyone has a spare minute to give me a hint on what's wrong I'd apreciate it a lot! The problem is that when I add 'use index ()' to my queries, MySQL doesn't always use the whole key, but decides what left-most part

extract day and hours/minutes from a date-time field but ugly results... HELP!

i want to extract day and hours/minutes from a date-time field. in order to to this i use e.g. for the hours: select HOUR(hora) as lahora from mytable which returns the hour but followed by an "L", same for minutes, same for the date. why is this so and how can i avoid it? we run mySQL under Z

DELETE question

Anybody got a clue why this isn't deleting? The number is input in the previous section of code and I know it works correctly, but for some reason when it gets to here, it just skips to view (apparently), (even if I # out the Lock lines, so it isn't a lock problem). Am I going about getting the nu

Re: Port MS SQL Database To MySQL ??

Create a DTS job to export each table into a text file. Additionally, you can use Query Analyzer to grab schema for each table (minor changes to sql to use same code in mySQL). Create your tables, do a bulk insert. - Original Message - From: <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> S

Conversion from 3.22.32 to 3.23.36

Problem: I have created the databases in the new version (3.23), copied the tables into the correct directories, and changed the mode to 777 for all tables and directories. When I run the provided conversion script: mysql_convert_table_format, I receive an error on some of the tables that states

bug report

Hi! > "Aurelian" == Aurelian Dumitru <[EMAIL PROTECTED]> writes: Aurelian> Please record the following bug identified on the MySQL server: Aurelian> 1. Hardware: SUN Ultra 10 Aurelian> 2. Operating system: Sun Solaris 2.7 Aurelian> 2. MySQL server version: 3.23.33 Aurelian> 3. Error descri

Re: select query question

Thanks much, I was trying to do it with subselects, like in MS SQL, but obvioulsy that doesn't work with MySQL. I like the temp table idea, the table is deleted automatically when my mysql connection is closed, correct? Thanks! - Original Message - From: "Braxton Robbason" <[EMAIL PROT

query size

In the Crash me, it says MySQL support a little more than 1 Million for query size. Is this the max number of records can be retrived from 1 single query? Is there a way to change this? Different setting? Thanks, Vh - Befor

RE: select query question

create temporary table foo as select patientnumber, count(*) as rcount from source_table group by patientnumber having count(*) > 1; select count(*) from foo; -Original Message- From: Jon Rosenberg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 02, 2001 1:29 PM To: [EMAIL PROTECTED] Sub

Re: Problem with mysqldump....

To import you should do cat filename | mysql -uusername -ppassword databasename ryan - Original Message - From: "Rachel-MY" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, May 01, 2001 9:38 PM Subject: Problem with mysqldump Hi everyone, I'm trying to backup al

select query question

I have a table where patient visits are logged each visit, the table is: patientnumber,visitdate,location I need to select and count the number of records that have 2 or more entries with the same patientnumber in sql-english: select count(*) where there are two or more records with the same pa

Port MS SQL Database To MySQL ??

Are there any tools avalable to port MS SQL to MySQL? I am only trying to build up a bigger database for some testing and wanted to use the northwind or one of thoses. If not where could I get one that's fairly big I could load. Cheers Mike Benzel [EMAIL PROTECTED] Cross Platform Messaging an

Re: How To Port the MS SQL Database To MySQL ??

[EMAIL PROTECTED] wrote: > > Dear Friends , > > The basic problem I face in the new project is to convert the previous Stored >Procedures in MS SQL Database into My SQL . How to Replicate the same in My SQL . > The Front End is VB 6.0 . The Back End previously was MS SQL . Now Client want it

RE: Query speed

you are right I tried specifying it to use the crcid index with "USE INDEX (crcindex)" in the from clause but it made no difference. any ideas as to which indexes I could create to speed up the second query. Here is an explain on my test database which is significantly smaller: mysql> explain sel

RE: Query speed

seems to me that the first query uses your primary key index. Since you have specified qualifications on crcid and tag in both aliases, it will resolve to a small number of rows in each alias table. The second query will join your aliases on the crcid index, and then the tag qualifications will r

Re: DBD::MySQL Help!!

Hi Rick, It looks similar to a problem I had on FreeBSD in not finding the shared library. I added this command to a startup file (mysql_server.sh) in rc.d directory. /sbin/ldconfig -m /usr/local/lib/mysql You may need to check if -m is the right option for openbsd but I am sure

missing doc: identified by password

Doing a : mysql> show grants for root@localhost; +---+ | Grants for root@localhost |

specifying a delimiter

Hi, Being new to MySQL, I am having a problem getting output from it to the shell that is formatted the way I need. I need a table to be written to a file with a delimiter. something like : #!/bin/sh mysql -uroot -ptest database < sql Then I run that script like this: ./script.sh > output.txt

Date comparisions...

Hi all, I was recently attempting what I thought would be an easy search. I wanted to return all records with a birthdate (a DATE column) 'within' 30 days of the current date. The birthdate is stored as a -MM-DD, I have been having lots of trouble getting MySQL to return the correct records,

Conversion from 3.22.32 to 3.23.36

Problem: I have created the databases in the new version, copied the tables into the correct directories, and changed the permissions of the entire directory structure to 777. When I run the provided script: mysql_convert_table_format, I receive an error on some of the tables that states: Una

tty beeps uncontrollably when hitting after mysqld

>Description: This happens whether launching mysqld directly or safe_mysqld. Following the instructions carefully (with the & backgrounder at the end), I get: /usr/local/libexec/mysqld: ready for connections but the prompt does not return. If you then hit

mysql.server uses fully-qualified hostname, but mysqld doesn't

>Description: My pidfile name is ldap1.pid However, I get the following error: root@ldap1# sh /usr/local/share/mysql/mysql.server stop No mysqld pid file found. Looked for /var/db/mysql/ldap1.netcarrier.net.pid. My "hostname" returns "ldap1.netcarrier.net"

Query speed

I am trying to run two queries which seem to me should execute at abut the same speed. My table is setup as follows: day - number of days since 1970 crcid - a number between 0 and 24 tag - a number used to identify record type total - the value stored (the rest of the record is just to identi

querylenght....

how long(in chars) can be a query string?? insert into Tab1 values('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'),('a','b','c'); and so on. is there a border? or can I use

max_connection

how do i change these settings like max_connection and stuff on a windows mysql server? i keep on getting this error after a while thanks

Re: MySQL can't open mysql.sock on start

Check for /etc/my.cnf or .my.cnf in mysql's var directory. One of these must have a line misdefining the socket as mysqld.sock. Chad Nantais wrote: >> Description: on start, MySQL creates a socket (mysqld.sock), in the /tmp directory >by default, and tries to start > > by opening socket mysql

Replication TIMESTAMP problem?

Hi, I'm asking again, maybe someone reads my message. The manual says that replication should work with TIMESTAMP. What does this mean? When I replicate (with binary logs) a table with such a field, the values on the slave is different (because of time difference). I saw that the update log has so

Re: Installing MySQL on Solaris as a user(not root)

Since mysqladmin ran, the server is already running. Roman Shtykh wrote: > I have a problem running MySQL on Solaris. I downloaded the source and compiled it >following all the instructions and made mysql directory in my home directory. When I >enter "mysqladmin version" I get: > > mysqladmin

Re: if no var/db directory where R DB files?

Continue following the directions. After "my_install_db --user=mysql" you should be able to find them. Diego Montalvo wrote: > Hello, > > I have just installed mysql-3.23.37 in FreeBSD 4.2, I have already > ../configure - make and - make install and notice that there is no > /var/db directory,

Re: difficulty with insert into

I don't know what var you aretalking about, but all the vars you here are only one word long. If you mean $THECONTENT, then you should have written THECONTENT=$* You whould have seen this if you had echo'd the variables in question before trying to insert them. [EMAIL PROTECTED] wrote: > only

yacc should do more lookahead in IN SHARE MODE to work

Monty, a parser bug. Regards, Heikki Hi! It is a bug in the parser that it does not accept ... IN SHARE MODE immediately after a WHERE clause. I think yacc is not very sophisticated in lookahead of symbols when it is trying to parse a statement, and may confuse IN SHAR

Re: problem with select ... in share mode

Hi! It is a bug in the parser that it does not accept ... IN SHARE MODE immediately after a WHERE clause. I think yacc is not very sophisticated in lookahead of symbols when it is trying to parse a statement, and may confuse IN SHARE MODE to WHERE colA IN (). We will fix the parser, but mean

Query

Hello Sir, I am having a job at hand where I have to set up a MySQL database with JDBC driver with a Java applet/servelet front end (OS Linux) . Can u please give me some details about the connection nity grities with the Database Server. Thank you. Regards, Swarnavo Roy

sql

sql please remove me from mailing lists - 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 PROTECTED]

Re: LAST_INSERT_ID returning 3 rows?

> COk I was thinking that you had to tell LAST_INSERT_ID the table you wanted > to get the last insert id from. What if you run a web site and you have 10 > tables in a database, how can you tell what the last insert id of table 6 > was? As I understand it, LAST_INSERT_ID is connection based, n

problem with select ... in share mode

3.23.37: SELECT * FROM table1 WHERE colA=1 IN SHARE MODE does not work (ERROR 1064: You have an error in your SQL syntax near 'share mode' at line 1). On the other side SELECT * FROM table1 IN SHARE MODE does work, i.e. the syntax error only happens if I specify a WHERE clause or an OR

Import datas from FileMakerPro database

We would like to know if it is possible to import al the datas from Filemaker Pro databases in a new mysql database. We would like to use Mysql in place of Filemaker . Thanks and read you soon. - Before posting, please check: