Hello,
after switching from MySQL 5.0.67 to 5.1.59 we get the following problem:
We want to import data from a textfile
example of the textfile:
t...@test.com$yes$432145$xyz
The command is: LOAD DATA LOCAL INFILE 'textfile.txt' INTO TABLE TESTTABLE
FIELDS TERMINATED BY '$';
Selecting the data
Hello,
we want to set the global variable ft_min_word_len from the default "four" to
the value "three".
This is needed because we want to search for words with the max. length of
three characters in one application.
I've read that after setting ft_min_word_len to the new value, a "REPAIR TABLE
Hello,
we have two tables associated with a foreign key constraint.
Table A with the primary key and table B with an "on delete cascade" constraint.
We want to delete datasets in Table B if the related dataset in Table A is
deleted - that works.
Now the Problem:
There is a weekly import defined
Hello,
I found the solution by my own:
set meta-flag on
set convert-meta off
set output-meta on
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list archiv
Hello,
I've a problem with mutated vowels like öäü by using the mysql client.
Nothing happens if I type ö,ä or ü. The input seems to be ignored.
OS is Solaris 9 Sparc 32 Bit. MySQL Version 5.0.45 (I tried the source and
binary version.)
By typing in the shell (csh, ksh) or using the vi there is
Hello,
is there a possibility to declare constants in MySQL functions?
declare test_name varchar(50) DEFAULT 'test';
The variable test_name here ist changeable but it should not be.
Oracle syntax:
test_name CONSTANT VARCHAR2(50) := 'test';
Regards,
Spiker
--
Pt! Schon vom neuen GMX Mul
Hello,
thank you - now it works.
d_parenttype PT1 LEFT OUTER JOIN t_booklists bl ON (PT1.ID = bl.PARENTTYPE_1),
d_parenttype PT2 LEFT OUTER JOIN t_booklists bk ON (PT2.ID = bk.PARENTTYPE_2)
I had to put the alias to all listet fields in the select.
regards,
Spiker
Original-Nachric
Hello,
I've two LEFT OUTER JOINS in the WHERE section in an Oracle script like:
select ...
from...
where
...
and PT1.ID (+) = bl.PARENTTYPE_1
and PT2.ID (+) = bl.PARENTTYPE_2
...
MySQL knows LEFT OUTER JOINS in the FROM section but two joins with the same
table aren't accepted.
example:
selec
Hello,
we have a MySQL DBMS with a lot of databases. Most of them are using MyISAM
tables but three databases use InnoDB and MyISAM tables.
What is the best method to get a consitent ONLINE backup of both table types?
Thanks,
Spiker
--
Pt! Schon vom neuen GMX MultiMessenger gehört?
Der kan
Hello,
Explain where the Statement is very fast:
*** 1. row ***
table: Stuecke
type: ALL
possible_keys: PRIMARY,St_Autor
key: NULL
key_len: NULL
ref: NULL
rows: 694
Extra: Using where; Usin
Hello Ananda,
yes, the testmachine has the same data.
Regards,
Spiker
--
GMX FreeMail: 1 GB Postfach, 5 E-Mail-Adressen, 10 Free SMS.
Alle Infos und kostenlose Anmeldung: http://www.gmx.net/de/go/freemail
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubsc
Hello,
I've a performance problem with our database:
Some select statements take about 20 seconds.
The same statements on an equal testmachine take less than 1 second.
Server: CPU: 2 x 440 MHz sparcv9
RAM: 2GB
(top: Memory: 2048M real, 931M free, 732M swap in use, 2839M swap fre
Hello,
I have hab problem with mysqlbinlog. I'm testing point in time recovery. The
Server Version of MySQL is 5.0.22.
Statement:
./mysqlbinlog --stop-date="2006-12-29 08:40:00" | mysql -u -p
The error:
ERROR at line 12: Unknown command '\C'.
By piping the output in a file line 12 looks like
Hello,
my question refers to the user "root" in MySQL 5.0.22.
Is the standard MySQL root user really required with the name "root" or can I
rename the root user for example to "myroot"?
Our software vendor affirms that MySQL need the User "root" always but I argue
the convers.
The application
14 matches
Mail list logo
