 | | | MySQL General | | Hi everyone!
I have a bunch of MyISAM tables and one MERGE table. All have same
structure. It seems to me indecies on MERGE table aren 't fine. When I
fetch rows by indexed field I get empty result I am trying to create a trigger which will eventually call a judf.. However
my mysql does not understand the delimiter command. actually... help doesnot
even list delimiter as a possible command.. I aGabriel PREDA wrote
> Hope this helps !
Thanks a bunch that was it. Problem solved.
I 'll tell about it on the dbmail list as well.
Alex
--
MySQL General Mailing List
For list archives http /Hi
It 's very important to have instaled the library client related to the MySQL server version.For example you cannot use libmysql.dll version 3.X or 4.x to use stored procedure from version 5.X of Hey list
I 'm having trouble with the GROUP_CONCAT() function which (according
to the docs) is supposed to give me a column with the VARCHAR type
unless group_concat_max_len is >512. Instead it BLOSong Ken Vern-E11804 wrote
> Hi
>
> I 'm trying to build a query in using SQL instead of doing it in Perl.
>
> I am trying to do something like this
>
> If ((select col1 from table1 where idGood day list
I 've encountered a behaviour with 'WITH ROLLUP ' that I don 't understand.
SELECT a.report_date
SUM(b.daytotal*last1) last1
( 100*SUM(b.daytotal*last1) /
(select sum(daytotal)I 'll give it a shot.
First select the people that got the first advertisement
SELECT c_id aa_id
FROM adverticelink
WHERE aa_id 4
Hi
2006/6/21 Helen M Hudson <helen@(protected) >
> Yes I can see how this would work for just the one order and hardcoding the
> 100... but I cannot assume only to sum distinct values and my tableBasically it says that if you have an index let 's say INDEX_1 on columns
INDEX_1 a b c d
MySQL will act as if you had setup indexes on
INDEX_1_1 a b c
INDEX_1_2 a b
INDEX_1_1 a
A q
Hi all
I have been trying to cross compile mysql4.0.27 for an Intel-XScale based
ARM board on a i686-Linux PC.
I have run configure with the following command line options
$ CC $PATH/arm-linux-gPerhaps the searches that return "nothing " are actually matching more than 50% of the record in the table.
I have been subscribed to this list for a couple of years now. I don 't
often respond and rarely ask questions but I do read it every day and
typically learn something new.
Around the 13th of thisTaco Fleur schrieb
> Hi all
>
> is it possible to do a MATCH AGAINST and return some of the text for
> example the first paragraph that contains the matching words?
>
> Kind regards
>
Well yHi
I 've been thinking about setting up a slave server for a few of my
mysqlservers for extra backup safety. Some of the databases are quite
large about 50gb so a mysqldump is very clumsy to handlIf there is a way for you to capture INSERT commands and convert them to REPLACE commands you 'll have your solution.
----- Original Message -----
From "css " <cscotts@(protected) >
To <mysql@(protected)The command is "mysqldump "
Here 's the man file on it
http //dev.mysql.com/doc/refman/5.0/en/mysqldump.html
-----Original Message-----
From Karl Larsen [mailto k5di@(protected)]
Sent Tuesday JOn Tuesday 20 June 2006 12 02 pm Martin Jespersen wrote
> ./configure --prefix /opt/.mysql-4.1.20 --enable-assembler
> --enable-thread-safe-client --enable-static all --with-gnu-ld
> --with-mysqld-uYou 're hard-coding ten thousand discrete values between the two IN clauses?? I 'm not sure how MySQL processes a query like that but I can imagine that the performance would not be good. Frankly I am MySQL is doing a file sort on the query result. It 's not sorting the entire table and it 's not sorting the 40 record limit you
specified. It 's sorting the WHERE id IN... result. After the sort then Hi
I 'm using dbmail - a program that holds mails in a database for example
mysql. I 'm in the process of migrating an old installation to the
current one. dbmail does provide a migration script bI don 't know what your queries look like but faster disks is always a good start when you need to transfer lots of data.
That said I have found that with MySQL if I need to process lots of recordsOn 6/20/06 Stefan Hinz wrote
>
> The MySQL documentation team is looking for another technical writer.
> For this we need the best and the most dedicated people around. You may
> work from anywhere Hi all
I have download the mysql-4.0.27. And I am trying to cross compile it for
Intel-XScale ARM processor on Linux-2.4.20.
I have run the configure command as follows
# CC $PATH/arm-linux-gcc LD hello
I want to know about the leftmost index prefixes using nounique index/
About the composite index using primary key in the reference 7.4.5
I can understand the following
-I imported the data of the table using mysqlimport.
I used the following command line.
$ mysqlimport -ukawabe -paaa -h192.168.1.92 --local kawabe
"C \index_test.txt "
kawabe.index_test
RecIf you do a SHOW PROCESSLIST list you might see some queries with a state of "Locked " or "Sending Data ".
The sending data query may be the one that is causing all the others to wait. You would see thHi all
this is a problem I 'm running into
A table has like 400 000 rows with a primary key index id. I use this query
SELECT * FROM table WHERE id IN (58 25 75 ...) ORDER BY post_date
DESC LIIn the last episode (Jun 19) Chris White said
> On Monday 19 June 2006 04 08 pm Logan David (SST - Adelaide) wrote
> > I 've noticed that a Ctrl-C will also leave the query running
> > (5.0.22 - LMysql 4 still version 4.0.18
I have users and transaactions the key is user_id
Somehow a bunch of users were made and there is a total lack of a
transaction record at all. I need to fix this w |
|
|
