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]
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
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
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
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
[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
-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
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
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
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
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
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
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) *
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
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
15 matches
Mail list logo