Michael Dykman wrote:
> On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
>
>> I have a seemingly impossible situation. I cannot insert values into the
>> tables and I cannot alter or delete the primary key (which should not
>> exist) or delete the foreign keys nor remove the constraint. G search
>>
>I cannot insert values into the tables
What is the error message? Has the smallint key run out of values?
>and I cannot alter or delete the primary key (which should not exist)
Eh? Without a PK, it ain't a table.
>or delete the foreign keys nor remove the constraint. G search doesn't
help.
On Thu, May 21, 2009 at 11:06 PM, PJ wrote:
> I have a seemingly impossible situation. I cannot insert values into the
> tables and I cannot alter or delete the primary key (which should not
> exist) or delete the foreign keys nor remove the constraint. G search
> doesn't help.
>
> CREATE TABLE `b
I have a seemingly impossible situation. I cannot insert values into the
tables and I cannot alter or delete the primary key (which should not
exist) or delete the foreign keys nor remove the constraint. G search
doesn't help.
CREATE TABLE `book_categories` (
`bookID` smallint(6) unsigned NOT NUL
mysql> select sysdate() from DUAL;
+-+
| sysdate() |
+-+
| 2009-05-21 17:37:13 |
+-+
i would get the proprt format is
i could CONVERT_TZ to work
can you get CONVERT_TZ to work ?
Martin Gainty
_
Is "Thu May 21 03:15:28 + 2009" a valid date/time string?
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org
Thank You for all the help.
I was upgrading from 4.0.x to 5.0.x
The new mysql recognized the old databases without problems.
Bye :)
Hello all,
Hope you are doing well, I have a general question creating foreign keys
, I'm creating FK from catalog tables to relation tables with them, when
I create a FK in innodb engine on MYSQL a new field with the same name
of the FK is created, in this case if I create for example 3 FK t
I'm not running with replication, but I AM often running the CLI against the
production and test environments at the same time. I found it invaluable to
add the line
prompt=\h >
to my.ini (I'm running on Windows). That adds the host name to the prompt,
and has saved my butt more than once.
>
Anyone knows where I can download the 6.0.11 gziped source from?
I tried it on win32, it worked but the server failed under heavy load.
I'd suggest running mysql on a 64 bit Linux machine instead.
Jw
On Thursday, May 21, 2009, Krishna Chandra Prajapati
wrote:
> Hi,
>
> How much performance improvement we can get using large_page_size in mysql
> server. Is the
Hi,
How much performance improvement we can get using large_page_size in mysql
server. Is there anybody using on productions.
Thanks,
Prajapati
Krishna Chandra Prajapati
Email-id: prajapat...@gmail.com
12 matches
Mail list logo