varchar and java string in sql query ?

I and using mysql-jdbc to do some program. I can insert record to my db by following code: - stmt.executeUpdate(insert into apidbusers values('id', 'jp','zhu','em1','jian180')); --- but if

Re: varchar and java string in sql query ?

Hi, I am not fimilar with jdbc. But as a general prinple, you should quote your string expl. and it is nearly a must for all language to handle SQL query. May be you should try str='id' instead of str=id. In some language, you must use str = \'id\'. Please check jdbc docs. Regards, I and

RE: Is this query possible...

Well, I thought I could figure it out but I guess I couldn't. This is exactly what I want to do... //Using Access now, but when I use MySQL, I can just get the last insert id. $itemID = $_POST['item_id']; $itemQty = $_POST['item_qty']; $itemPrice = $_POST['price']; $orderID = Will be a value

Re: How to determine foreign keys? Meta data?

If you are using Windows, a GUI client like SQLyog would be of great help. It is free, and has neat interface to display / manage relationships. --- Jeff Epstein [EMAIL PROTECTED] wrote: Hello all. I've only been using MySQL for a few days, but I'm experienced with Oracle. So consider

Is SQL right for me?

I'm need to create a database for the first time in 10 years and the wizard aspect of Access 2002 doesn't work for me - it's too much help and slows me down! I'm used to creating databases and reports almost from scratch with dBase IV and Paradox, and easily learn software by reading manuals, so

Searching should be easy ?

Hi My host used mysql v3.23.28 and I use ASP for data access on my genealogical database I have created a fulltext index on 3 fields, surname,groomsurname and bride surname And I retrieve an exact name using the following: SQL = SELECT * FROM global WHERE MATCH (SURNAME, GROOMSURNAME,

SSL connection from client

Hi, I have installed the 4.0.10-gamma with support from the openssl v. 0.9.7 on the Debian Woody: mysqlstatus ... SSL:Cipher in use is DHE-RSA-AES256-SHA ... mysqlshow variables like '%openssl%'; +---+---+ | Variable_name | Value | +---+---+

purging of relay logs?

Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found out that there are these new files on the slave. How can I rotate them? sql and so on... -- _/_/ _/_/_/ - Rafa Jank [EMAIL PROTECTED] - _/ _/ _/ _/ _/ Wirtualna Polska SA

Re: purging of relay logs?

On Thu, Feb 20, 2003 at 08:00:32AM +0100, Rafal Jank wrote: Is this a way to do it? I've just upgraded mysql to vesion 4.0.10 and found out that there are these new files on the slave. How can I rotate them? They should automatically vanish. MySQL removes them when they're no longer needed. --

Need help in Mysql

Dear sir I am using mysql for my project.I am finding problems of using FOREIGN KEY and STORED procedures in version 4.0.please help me and send the details as earlier as possible by Saravanan __ Do you Yahoo!? Yahoo! Tax Center - forms,

Re: MySQL on Mandrake 9 with EXT3 File system... Max Size?

You can see your max table size at the row Max datafile length: 4294967294. This means that your UsedData table's max size is 4G. If you want to change it you have to use alter table command with the option max_rows. For example ALTER TABLE UsedData MAX_ROWS = 100. [EMAIL PROTECTED]

Re: libmysqld.lib

Hey, libmysqld is for a long time already part of the MySQL 4.x Source-Distribution. Bernhard - Original Message - From: Derick Smith [EMAIL PROTECTED] To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Wednesday, February 19, 2003 11:35 PM Subject: libmysqld.lib Hi! I want to emebed

<    1   2