Hi,
I'm trying to create a table with 2 foreign keys from two tables, but
it not workin
here is the query ( i have generated this query from mysql workbench)
--
CREATE TABLE IF NOT EXISTS `menutest`.`role_perm` (
`idrole` INT NOT NULL ,
`permid` VARCHAR(45) NOT NULL ,
`status` BOOLEAN NOT N
On Tue, 10 Jun 2008, Martin wrote:
Lucio
So the net effect is to produce a cartesian join where ALL results from
Query1 (are combined with) ALL results from Query2
In order to prevent cartesian join can you use a more narrowly defined
predicate such as what is defined at
http://www.mysqlperf
If you kill the process in the middle of huge alter. It will take some time to
reverse them back. It will be fast if you have good memory.
Thanks,
Saravanan
--- On Wed, 6/11/08, Ananda Kumar <[EMAIL PROTECTED]> wrote:
From: Ananda Kumar <[EMAIL PROTECTED]>
Subject: kill process id.
To: "mysql"
Hi All,
I killed a process with
kill ;
This processid i got from show processlist.
But the process is in KILLED state for long time, is there a way to kill it
instantaneously.
Below is the job i have killed, as it started doing REPAIR BY KEYCACHE
Alter Table ebay_research_temp enable keys Rep
Baumann, Michael schrieb:
Hi there,
I got a quite weird problem. Trying to update a table via a batch shell
script that looks like this
while read AAA BBB
do
mysql -u $DBUSER --password=$DBPASS --batch "--execute=update
^
i guess your qu
Hi,
this Thursday, Giuseppe Maxia will give a MySQL University session:
http://forge.mysql.com/wiki/MySQL_Sandbox (topic: MySQL Sandbox)
Please register for this session by filling in your name on the session
Wiki page. Registering is not required but appreciated. That Wiki page
also contains a
Hi there,
I got a quite weird problem. Trying to update a table via a batch shell
script that looks like this
while read AAA BBB
do
mysql -u $DBUSER --password=$DBPASS --batch "--execute=update
XY_Table \
set Column1 ='"$BBB"' where Column2 = '"$AAA"' LIMIT 1;" DBTABLE
>>$LOGFILE