percentage query

2005-05-26 Thread Reinhart Viane
Hey all, I have some difficulties building a querie. Table objects type_id area Table 4dtypes type_id name what I need is a query who gives me the folowing result: name (grouped by type_id) - sum of area -- percentage of total area so I need to group the records on type_i

Re: update combine values

2005-05-26 Thread mfatene
Hi, try this : mysql> select * from usertable; +--+---++--+ | fullname | firstname | Middlename | lastname | +--+---++--+ | NULL | Scott | Junior | Tiger| +--+---++--+ 1 row

RE: problem when running mysql server

2005-05-26 Thread Peter Normann
qin lei wrote: > I have instal mysql in /usr/local/mysql. When I run the server. The > message showed on the screen is as follows: [snip] > Warning: Ignoring user change to 'root' because the user was set to > 'mysql' earlier on the command line > 050526 17:46:09 InnoDB: Started > 050526 17:46:09

problem when running mysql server

2005-05-26 Thread qin lei
I have instal mysql in /usr/local/mysql. When I run the server. The message showed on the screen is as follows: [EMAIL PROTECTED] bin]# ./safe_mysqld & [1] 5122 [EMAIL PROTECTED] bin]# Starting mysqld daemon with databases from /var/lib/mysql STOPPING server from pid file /var/run/mysqld/mysql

Re: Lost connection to MySQL server during query problem

2005-05-26 Thread Gleb Paharenko
Hello. Does SHOW STATUS executed from JDBC client return increased values of this parameters? Could your server die during queries from JDBC (check the error log)? Sometimes you should increase interactive_timeout as well. A lot of variables usually could be changed using SET statement. See:

Re: Can't Start MySql

2005-05-26 Thread Gleb Paharenko
Hello. It could be a bug, because you're using rather deprecated software (Win98) and a very old MySQL 4.0.14. A Z <[EMAIL PROTECTED]> wrote: > > MySQL 4.0.14 Win98 platform. > > what could cause the following error by typing > mysqld --console. > > regards > > > 050525

Re: restarting mysql server

2005-05-26 Thread Gleb Paharenko
Hello. Probably mysqld_safe uses wrong values for directories. Possible solution is to store the correct paths in configuration file, and if it is situated not in standard location, launch mysqld_safe with --defaults-file=path_to_config_file. Or use command line options for mysqld_safe. Chec

Re: InnoDB to MyISAM

2005-05-26 Thread Ian Sales (DBA)
Peter Normann wrote: Martijn Tonies wrote: Nevertheless, foreign key constraints belong in the database, not in your application... If you have foreign keys (your wording), you need foreign key constraints. Period. Plain and simple. No discussion :-) Foreig

Re: InnoDB to MyISAM

2005-05-26 Thread Martijn Tonies
> > Nevertheless, foreign key constraints belong in the database, not in > > your application... If you have foreign keys (your wording), you need > > foreign key constraints. Period. Plain and simple. No discussion :-) > > Foreign keys are foreign keys. Constraints are constraints. Foreign key >

RE: InnoDB to MyISAM

2005-05-26 Thread Peter Normann
Martijn Tonies wrote: > Nevertheless, foreign key constraints belong in the database, not in > your application... If you have foreign keys (your wording), you need > foreign key constraints. Period. Plain and simple. No discussion :-) Foreign keys are foreign keys. Con

Re: maximum size of mysql server-id field

2005-05-26 Thread Richard Lynch
On Wed, May 25, 2005 11:59 pm, David said: > Does anyone know what the range for server-id can be? > > Is it a 16 bit number? 32 bit? > > I can't seem to find it in the documentation or via google. I did dogpile.com for "my.cnf format server-id" and found: http://mysqld.active-venture.com/Replica

Re: InnoDB to MyISAM

2005-05-26 Thread Martijn Tonies
> >> I think you're confusing referential constraints with foreign keys. > > > > In my book, referential constraints and foreign key constraints (the full > > name) > > are the same. > > Yes, referential constraints and foreign key constraints are the same thing. > Notice the word constraints. >

Re: Sync 2 live MySQL Databases

2005-05-26 Thread Cecil Brand
This is precisly the problem that I'm sitting with. It look like unless MySQL AB desides to build such a feature into one of the future releases this would beable to work. Mnr Cecil J.C. Brand Computer Services/ RekenaarDienste University of the Free State/ Universiteit van die Vrystaat PO Box

Re: InnoDB to MyISAM

2005-05-26 Thread Jeremiah Gowdy
I think you're confusing referential constraints with foreign keys. In my book, referential constraints and foreign key constraints (the full name) are the same. Yes, referential constraints and foreign key constraints are the same thing. Notice the word constraints. Let me say this again:

maximum size of mysql server-id field

2005-05-26 Thread David
Does anyone know what the range for server-id can be? Is it a 16 bit number? 32 bit? I can't seem to find it in the documentation or via google. I guess most people just do "server-id = 1" and "server-id = 2" but for large setups, that becomes difficult to manage and there are better ways of tyi