Hello,
I think that my problem boils down to the unimplemented getWarnings() method
in the mm. JDBC driver. If it was implemented, I could detect if the data
was e.g. truncated. Can anybody help me find an implementation for this
method?
Thank you again,
Charlie
Hi.
:I'd like to find out
Hi All,
I'd like to find out how I could convince mysql to generate warnings
whenever the data I want to insert is modified by the server.
E.G. CREATE TABLE test (value real);
INSERT INTO test VALUES ('a1');
I am programming in JAVA using JDBC.
Thanks for any answers!
Charlie
Hi All,
Using MySQL server version 3.23.49-nt I get strange results when running the
following very simple test. I am wondering if this is a bug, feature or
perhaps a standart SQL behaviour??
CREATE TABLE test(id BIGINT UNSIGNED);
CREATE INDEX test_idx on test(id);
INSERT INTO test VALUES
Hi all,
I seem to have difficulties efficiently using multiple column unique
indexes. I notice major performance differences in the following example.
Is this a known problem, or am I not doing the right thing?
The following scenario takes for me 0.76 seconds:
CREATE TABLE test(d_id INT,
Hi,
My database users have problems with the missing sub-query feature of MySql
that I would like to solve by letting them create temporary tables since
their scope is a connection thread. However I cannot let them to start
creating tables that are not temporary.
Unfortunately I cannot find
Hi,
I am using MySql 3.23.47 for nt (W2000).
The number of rows of my table on an NTFS file system is estimated to become
around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295
with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60;
Following this, SHOW TABLE STATUS
Hi,
I am using MySql 3.23.47 for nt (W2000).
The number of rows of my table on an NTFS file system is estimated to become
around 6,000,000,000. I am trying to increase my default MAX_ROWS=4294967295
with ALTER TABLE test AVG_ROW_LENGTH=9 MAX_ROWS=60;
Following this, SHOW TABLE STATUS