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
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
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
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
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
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,
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 |
+---+---+
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
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.
--
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,
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]
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
101 - 112 of 112 matches
Mail list logo