Andrew,
did you install mysql when you installed suse?
you might have to fire up YaST and install the rpms.
this is a little old... but shoudl help:
http://www.novell.com/coolsolutions/feature/595.html
this is for 9.1, but the procedure should have remained pretty much the same
with suse 10.
Hi MYSQL users.
I have just install SuSE Version 10 and need to start working with MYSQL
could someone help me out regarding
Documentation . Don't seem to be able to find any in the help files.
Andrew
- Original Message -
From: "John Doe" <[EMAIL PROTECTED]>
To: "Rhino" <[EMAIL PROTECTED]>
Sent: Sunday, January 15, 2006 6:15 PM
Subject: Re: Weird behaviour of Load Data
Rhino am Sonntag, 15. Januar 2006 23.53:
I'm getting some odd behaviour from the 'load data' command which I can
I'm getting some odd behaviour from the 'load data' command which I can't
resolve. For some reason, 'load data' is putting a quotation at the end of
the first column of the table
Here is my table definition:
create table if not exists Ref
(ref_name varchar(30) not null,
ref_org varchar(30) not
Reynier Perez Mira wrote:
Hi list:
Recently I download MySQL source from MySQL.com site for install it in my Linux
Server. I follow the standard procedure for it, means:
shell> ./configure
shell> make
shell> make install
That's not what the documentation says to do.
Have a look at the INS
Hi,
Excepted if he found a bug in an older version of MySQL, it's of course
false ! (it would be a major issue which would make MySQL just unusable)
Regards,
Jocelyn
David Rabinowitz a écrit :
Hi,
We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old
server we tried not t
An example of the _data_ would be very helpful here.
For example, let's say this is your data:
Col_ACol_B
-----
aceexpert
doghound
hungryravenous
If you are searching for the word "ace", you should find it. You then want
the SQL to return "ace", right?
If
Hi,
We are using MySQL 4.1.16, recently upgraded from 4.0.18. On the old
server we tried not to delete records, as their is a common belief that
deleting records will corrupt the table's index and we will have to call
repair table. I couldn't find any documentation on that. Unfortunately
he
On 1/15/06, [EMAIL PROTECTED] wrote:
>
> Actually there is a table with columns a and b .
> So i want if a contains a particular word than a's value should return else
> 'b' value should return.
SELECT
CASE
WHEN a = 'Good' THEN a
ELSE b
END
FROM
table
Jochem
Dear Friends,
I have a problm, try to solve that.
Actually there is a table with columns a and b .
So i want if a contains a particular word than a's value should return else
'b' value should return. And there must be one and only one column
returning. I have mysql 4.x and i think the logic will be
Thanks a lot for your answer!
However, when I used the option innodb_file_per_table I saw that the temp
file (#sql...) was created in my DB directory and on this partition I still
have plenty of space (more than 200GB).
Do you think I CAN'T use this option for such a big table and I have to use
inn
Hi,
I think you should change the tmpdir variable value to a directory which
have enough room to create your temp big table (by default, it points
to /tmp dir).
Regards,
Jocelyn
Patrick Herber a écrit :
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since
Dear All,
I have a table like this, please do attentiion on password field
+--+--+++
| username | password | prefix |
domain_name|
+--+--+
Hello!
I have a database with a big table (Data File 45 GB, Index File 30 GB).
Since I have some performance troubles with "table-locking" in a multi-user
environment (when one of them performs a complex query all the other have to
wait up to 1 minute, which is not very nice...), I would like to c
The difference in recommendation size comes from the different
techniques each storage engine uses for caching data. myisam
(key_buffer_size) only stores indexes where innodb_buffer_pool_size
stores both indexes and data. mysiam relies on the operating system to
cache data in ram which is why you d
15 matches
Mail list logo
