Re: Upgrade 3.23 == 4.0.13

2003-08-12 Thread System
Hello All, Sorry My mistake I resolved it like this: mysqladmin -u root shutdown mysqld_safe and it showed me mysql 4.0.13 Thank You, Tina. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

AW: mutual declarations produce Error 1064

2003-08-12 Thread Morten Gulbrandsen
Hello programmers, I think something is wrong with my administration, Basically I get these messages, ERROR 1005 at line 9: Can't create table '.\company\department.frm' (errno: 150) ERROR 1045: Access denied for user: '[EMAIL PROTECTED]' (Using password: YES) ERROR 1133: Can't find any

Re: Filtering special-chars

2003-08-12 Thread Matthew McNicol
try the PHP function htmlspecialchars() see the following article:- http://www.yellowmarker.co.uk/articles/unicode/index.php - Original Message - From: Steffen Gebert [EMAIL PROTECTED] To: MySQL Mailing List [EMAIL PROTECTED] Sent: Saturday, August 09, 2003 11:48 AM Subject: Filtering

Re: Select statement with a field name that is a number?

2003-08-12 Thread Keith C. Ivey
On 6 Aug 2003 at 12:04, Zach wrote: I'm trying to use a select statement for a table that uses numbers for the field names. Here is the query I've been trying. Please help! SELECT * FROM table_name WHERE '18'=1; (18 is the field name, 1 obviously is the value I'm looking for.) If it's a

Re: Insert bug into MyISAM table (Linux + MySQL 3.23.56)

2003-08-12 Thread David Bordas
Hi, mysql select * from Log_Forums where Date=2003080611; mysql insert into Log_Forums (pseudo,date,Type_Message) values (doss08,2003080611,0); insert into Log_Forums (pseudo,date,Type_Message) values (doss08,2003080611,0); Same thing here. But i solve my problem by update

RE: STUMPED: How Can I Pull Related Info Using Subqueries/Joins?

2003-08-12 Thread Jay Blanchard
[snip] But here's where I'm stuck: for each film, I need to pull the movie info in 'movies', plus any related data from other tables, like this: The Lord of the Rings | Peter Jackson | 3 comments Episode II| George Lucas | 0 comments Indiana Jones | Steven

RE: Re: MySQL field data type for ISBN numbers

2003-08-12 Thread Jim Smith
-Original Message- From: Tomasz Korycki [mailto:[EMAIL PROTECTED] Sent: 11 August 2003 05:26 To: [EMAIL PROTECTED] Subject: OT: Re: MySQL field data type for ISBN numbers At 21:08 2003-08-10, you wrote: On Sun, Aug 10, 2003 at 05:25:05PM -0700, James Johnson wrote: I

Re: Converting Sequel to MYSQL

2003-08-12 Thread daniel
setup a dsn in odbc and you could import via a tool called sqlyog ?? Hi all, Does anyone have any suggestion for converting a Sequel database to MYSQL? I just want to copy a Sequel database data to a Mysql one. Thanks in advance for any suggestion, Mike -- MySQL General Mailing List

Multiple field updates

2003-08-12 Thread Rudi Ahlers
Hi Can someone please tell me howto update a field (which is auto_increment) for a range from say 4000 - 8000? I only want to change info for listings in that range, if my database has about 75000 listings Kind Regards Rudi Ahlers Océ Software Support +27 (11) 661-9000 The basic difference

Re: arbitrary ordering

2003-08-12 Thread Andy Jackman
David, Gah. That's what I was hoping to avoid. It's like writing BASIC and having to leave yourself room... Yes, but unlike a basic program of 1 lines (heh, remember that!) you only need to leave room for n questions. If n is small - no problem, even if you have to 'renumber'. If n is

Re: MySQL Replication

2003-08-12 Thread Michael Conlen
Something to ask yourself in all this is, how fast can I change out a piece of hardware? If I needed a high availability system, on the cheap (ie, not a million dollars US worth of Sun hardware) I'd probably go with a bunch of SuperMicro 2U rack mount servers with the hot swap SCSI drives. You

Database formation ( . )I DONT KNOW( . )

2003-08-12 Thread Jonathan Fowler
Can any 1 tell me whats the up level commands are well u might know what i mean i know windows servers uses this type of way to go back a level such as ..\root-folder\ but whats Linux ? on my linux server how could i go back a level to go to another folder ? i already tried using ..\ but it want

Re: Help debugging this Query?

2003-08-12 Thread Andy Jackman
Aaron, It sounds like the join has duplicates on both sides. If you join a-b where a is unique (like a primary key) then you will get count(b) records (where b is the rows that match a). Or if b is unique then you will get count(a) records. However if neither a or b is unique you get count(a) *

Re: Error 127, some questions

2003-08-12 Thread Terence
Redhat 7.3 Kernel linux-2.4.18-3 Rgds Terence - Original Message - From: Richard Gabriel [EMAIL PROTECTED] To: Terence [EMAIL PROTECTED]; [EMAIL PROTECTED] Sent: Tuesday, August 12, 2003 2:02 AM Subject: Re: Error 127, some questions What OS/kernel are you running? Thanks. Richard

Re: innodb on delete cascade

2003-08-12 Thread Jeff Mathis
I just looked at your table syntax. you've got two auto_increment pk columns. do you always have a 1:1 correspondence between the name and gene tables? would it not be better to have a gene_id column in name, put an index on it, and then issue: alter table name add foreign key(gene_id) references