Choosing between 3.23.46 or 4.0.1 alpha

e web sites which is devoted to doing these kind of database engine tests/reviews ? Regards, Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive

Alpha 4 would have been beta Q4/2001

>"...Users are not recommended to switch their production systems to MySQL 4.0 >until it is released in beta version later Q4/2001..." Source: http://www.mysql.com/products/mysql-4.0/index.html Well, now it is Q2/2002 What is the new date for the beta release ? -

Re: Delete query problem

What about DELETE master_tbl,detail_tbl FROM master_tbl LEFT JOIN detail_tbl ON master_tbl.ID=detail_tbl.ID WHERE . T.R. Dušan Pavlica napsal(a): Hello, I have master-detail tables and I would like to delete in one statement master record and all detail records but not every master rec

Querry Count Rows

Hi all, I have a table with ordes and i want to know the top 10 Citys have the most ordes. This is my table Order_id, City Need count the rows where haver the most similar text y the column City? Thanks all

RE: Querry Count Rows

order_id then, you could use this select city,count(*) "total" from table group by city order by total desc limit 10; regards anandkl On 10/1/07, Tomas Abad <[EMAIL PROTECTED]> wrote: > > Hi all, > > > > I have a table with ordes and i want to know the top 10 Citys h

Problem with a Procedure

. SELECT SUM(trans2.nettovikt) as summa FROM trans2 INNER JOIN artikel on trans2.artikel=artikel.artikel WHERE trans2.transtid between '2007-07-01 00:00:00' and '2007-07-02 23:59:59' and artikel.reservinteger='01' group by artikel.volympris; Im running mysql 5.1.11. Thanks in advance! /Tomas

Re: Problem with a Procedure

Hi! I must say I cant see how this would help me. I know the tabels isnt empty since when running in query browsern I get a result. There must be something else thats wrong.. ...but thanks anyway! /Hylsan On Nov 23, 2007 4:43 PM, Martin Gainty <[EMAIL PROTECTED]> wrote: > > Tomas-

Re: Problem with a Procedure

nteger='01' group by artikel.volympris; For a brief moment, it seemed to work but now I only get this "no data..."-answer. All tables exist in the selected DB and the are full with lovely data I use the same user as in the query browser. Thanks! /Tomas On Dec 13, 2007 3:29 AM, Martin

Simple questio SQL

HI All, I have a Table and want to know the most visited products. Products - Id - Name - Visited Visited is numeric.

PROBLEMS WITH DELETE

The following query does not work. It fits the exact format of DELETE in the documentation. DELETE from price WHERE ticker ='MSFT' ORDER BY date DESC LIMIT 3; I am trying to delete the most recent 3 records. I get an error "You have an error in your SQL syntax near 'ORDER BY date LIMIT 3' at li

mysql crashing after restore

s size it is failing. Any help you can offer would be greatly appreciated. Thanks in advance, -- Tomas Clements http://www.national-net.com NationalNet is committed to the highest level of Customer Service available in the Web Hosting business. If you have any questions, comments or concerns feel

BLOB, SUBSTRING and 65536 characters limit

1024. But once x reaches 65536 i get empty result. What am I doing wrong or how can I work around this? I'm using MySQL 4.0.14 running on FreeBSD 4.9. Thanks in advance for your help, Tomas Zvala -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

Re: BLOB, SUBSTRING and 65536 characters limit

I'm sorry, the problem was of course between keyboard and chair. I didn't realize I'm using BLOB which is limited to 65536 characters insted of longblob that is quite larger. Thanks for your answers. Tomas Tomas Zvala wrote: Hello, I run into a problem where I need to get cont

joining tables from selected values

is_files=$id $id is a value from php-script #type is a for me imaginary value that I would like mysql to generate and being able to use. is this possible, or should I rename the values in the "files.type"-set to "files_directory, files_

Backup of databases.

mysqldump because of the server not is started and not can be started.. What to do ? Help me please /Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com

problem with mysql-3.23.39 server

to do.. by the way.. this is the content of my w3.err file.. (logfile) 010720 19:56:53 mysqld started /usr/libexec/ld.so: mysqld: libpthread.so.14.20: No such file or directory 010720 19:56:53 mysqld ended >From To

Re: mysqldump issues

7;m stuck here: Hi: What do you think about: select fields from table into outfile 'file' > > % mysqldump dbname tablename > ??? > > pleasepleaseplease help..! > > __ > Do You Yahoo!?

Avoiding roundtrips

Hi. I guess we all are waiting for subselects in Mysql...but can you do many sql-commands in a single execution, with a nice finally-result-select at the end? Many roundtrips feels bad... kind regards Tomas

Re: Re: Avoiding roundtrips

something separate query-executions could take down the perfomance. I'm using Perl DBI. kinds regards Tomas - Original Message - From: "Sinisa Milivojevic" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, April 06, 20

Re: Hierarchical lists

signed not null auto_increment parent_id int unsigned not null default -1 somedata varchar(1000) ) kinds regards Tomas - Original Message - From: "Realbad Atgames" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Monday, April 09, 2001 1:12 AM Subject: Hiera

multi table update

.fielda, t1.fieldb, t2.fieldx from master as t1 left join t2 on t1.fielda=t2.fielda; Any suggestion Thanks in advance. -- Tomas Carmen R. TCC S.A. telef.:+51-1-4428842 fax : +51-1-4426434 - Before posting, please check: http

ERROR 1114

you help me, please? Thanks in advance Tomas Carmen R.

How to convert MS Access mdb to Mysql

Hello.. is it possible to convert a whole ms access database (mdb) to a mysql database if so.. howto ? from Milpoer - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/

Error in starting the server

: libpthread.so.14.20: No such file or directory 010612 13:09:11 mysqld ended {End of file - w3.err } can someone please try to help me solving this problem ? >From Tomas alias Milpoer. - Before posting, please check: h

Cannot start.

such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended >From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Cannot start.

: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended >From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Cannot start the server after restart.

: No such file or directory Starting mysqld daemon with databases from /var/mysql 010622 17:20:08 mysqld ended >From Tomas - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.

Problem with the UPDATE

Hi , i´m having a strange problem with the update in mysql i have a table named "notices" with the following fields: id :prymary, int, auto_increment. title :varchar (255). priority:int. inside this table i have 5 registers like this : id title priority 1 a 1 2

RE: Problem with the UPDATE

-Mensaje original- De: Gerald L. Clark [mailto:[EMAIL PROTECTED]] Enviado el: lunes 29 de enero de 2001 12:53 Para: Guridi, Tomas Cc: '[EMAIL PROTECTED]' Asunto: Re: Problem with the UPDATE "Guridi, Tomas" wrote: > > Hi , i´m having a strange problem with th

getting files into BLOBs and some more

inte BLOBs? Maybe it would be better to still use a 'real' directory tree and just keep track of the privileges with mysql? I don't know. pointers, please regards, tomas ps. this is my first post on this mailinglist, if you find this kind of post/post-formatting unacceptable let

myodbc or server problem

Hello all, y send an SQL to server by VB & ADO. y traced from ODBC and I obtained this trace: GESTION fd28fee3-fd2805ff ENTER SQLExecDirectW HSTMT 02361D94 WCHAR * 0x01B46750 [ 211] "INSERT INTO macbase_totales.recibos

RE: Dificult question.....

nviado el: viernes, 13 de julio de 2001 18:14 Para: David Tomas Fargas CC: [EMAIL PROTECTED] Asunto: RE: Dificult question. On 13-Jul-01 David Tom`s Fargas wrote: > I Have a large table with 59.000 records and if i execute a simple select > since "Select * from table order by cod&quo

Sum function not uses a valid decimal separator.

" separator in a field returns results that they aren't true. How can I change the character that mysql uses to represent decimal separator? Thanks a lot for your time and sorry about my bad english... David Tomas Fargas ---

archive of old mails in lists?

Hello, is a archive where all the mails sent to mysql list are stored? if yes, where is the archive and how con I access to it. Thanks - Before posting, please check: http://www.mysql.com/manual.php (the manual) http://l