Hi,
I have a table with a column that has the Unique key constraint on it.
In the table definition that column has a default NULL specification
too.
So, when I ran the query select * from table where col is NULL;
I get only 1 row returned, when I have 23 such rows with NULL values.
Hi,
I have a table named t1 with a column x1 which is the primary key for
that table. There are some other tables that reference this table t1 on
x1 with foreign key constraints.
I wanted to rename the column x1 for some reason, so, I went ahead and
renamed the column x1 to y1. I was able
Hi,
I am writing a thread safe connection pool class. I want to connect to
MySQL through jdbc driver. In the initialization method, I write a
method that makes connections to the database and stores them in a
vector. When, I try making the 99th connection, MySQL throws an error
that says
Hi everyone,
If a user 'x' has exhausted all his connections, is there a way to free
up those connections. What command do I use for that?
Deepak