Am 17.06.2011 19:53, schrieb Philippe Mokrani:
> I have the following error messages:
>
> Installing MySQL system tables...
>
> 110617 19:46:25 [ERROR] ./bin/mysqld: unknown variable
> 'default-character-set=latin1'
"default-character-set=latin1" is way too old for 5.5
"character-set-server"
Hello,
I tried to install mysql-5.5.9 server on Redhat 2.6.18-194.el5 x86_64
GNU/Linux operating system using the binary distribution
openlogic-mysql-5.5.9-linux-amd64-bin-1.zip from
http://olex.openlogic.com/packages/mysql/5.5.9
After installed the above archive in a "/moteurs" d
I have the following 3 tables.. If I have a contact with just notes (no
tasks), then I can simply do
delete from contacts where id = ;
but if the contact has a task, then I get the following error, ERROR
1451 (23000): Cannot delete or update a parent row: a foreign key
constraint fails (`
On Fri, June 17, 2011 07:11, Jerry Schwartz wrote:
>>-Original Message-
>
>
>>What I was really trying to figure out was why it takes me 4
hours to
>>add a new column to my 22-million-row table, and
whether a different
>>table design can avoid that problem.
That reply in the forum says
>-Original Message-
>What I was really trying to figure out was why it takes me 4 hours to
>add a new column to my 22-million-row table, and whether a different
>table design can avoid that problem. That reply in the forum says,
>"ALTER TABLE ... ADD COLUMN will always copy the entire ta
>-Original Message-
>From: Vikram A [mailto:vikkiatb...@yahoo.in]
>Sent: Friday, June 17, 2011 2:54 AM
>To: Johan De Meersman
>Cc: MY SQL Mailing list
>Subject: Re: Encoding "Table Name" and "Filed Name"
>
>Sir,
>
>I agree, its impossible to do manual look ups. But our aim is to avoid the
2011/06/17 14:09 +0700, HaidarPesebe
Please help calculate the total revenue from the two databases below. The first
database is the name of the item and price. The second database is the goods
sold. I will make a recapitulation of every month to my total income (total
only). I've trie
At 10:47 PM 6/16/2011, Johan De Meersman wrote:
- Original Message -
> From: "Bennett Haselton"
>
> Do you happen to know the answer to my other problem -- if I have
> TEXT and BLOB columns but all my other columns are fixed-length, can
> I still get the benefit of faster lookups resul
- Original Message -
> From: "Vikram A"
> I agree, its impossible to do manual look ups. But our aim is to
> avoid the use of DB with out code. Also we have ensured, 'secret
> data is encrypted using some functions with key'.
> I shall follow both encode i.e, 1) filed and table name, 2)
Please help calculate the total revenue from the two databases below. The first
database is the name of the item and price. The second database is the goods
sold. I will make a recapitulation of every month to my total income (total
only). I've tried tp always failed.
TABLE A (item name and pr
10 matches
Mail list logo
