Foreign key with more columns and a constant value

Hi, I have the following table: create table client( id int unsigned not null auto_increment primary key, name varchar(200), type1 int unsigned not null, type2 int unsigned not null, constraint foreign key(type1, type2) references constants(id, type) ) engine=InnoDB; This table is OK, but the co

Re: mysql's system variables

> exit mysql client and enter again. Instead of exit client and enter again, just type \r (reconnect) and you have a new session. On 10/23/2010 06:44 PM, Claudio Nanni wrote: Just a little note: sometimes, if you are in command line session, you will not see the change of the dynamic variabl

Re: mysql's system variables

Just a little note: sometimes, if you are in command line session, you will not see the change of the dynamic variable unless you logout and in again, so in case you change the value of a dynamic variable but still the "show variables" shows you the old value, dont panic! exit mysql client and ent

Re: mysql's system variables

Here you get all details: http://dev.mysql.com/doc/refman/5.0/en/server-system-variables.html All the Dynamic variable can be change on fly eg. wait_timeout . On Sat, Oct 23, 2010 at 6:07 PM, wroxdb wrote:

mysql's system variables

Hello, what system variables of mysqld can be changed on fly? thanks. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/mysql?unsub=arch...@jab.org

Re: Adding a subquery

> What I am trying to do is to pull up a report that shows how many players have played one or more maps in each of the groups. See "All X for which all Y is Z" at http://www.artfulsoftware.com/infotree/queries.php. PB - On 10/22/2010 6:12 PM, MikeB wrote: I'm having real difficulty fig

Re: WTA Increasing InnoDB Speed

Hi Willy, Try percona server. It gives better performance than mysql. Krishna On Sat, Oct 23, 2010 at 3:37 AM, Willy Mularto wrote: > Dear List, > I have MySQL 5.14 installed on Dell R710 32GB RAM 600GB SAS HDD with Ubuntu > 10.04 64 Bit. I deploy InnoDB as my default engine. The server is a h