Re: Problem with a Procedure

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 Gainty [EMAIL PROTECTED] wrote: Hi 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- I would effect

Problem with a Procedure

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

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 have the most ordes. This is my table

Simple questio SQL

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

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

mysql crashing after restore

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 free to contact us at 770-471-9075 ext 1

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 contents of BLOB

BLOB, SUBSTRING and 65536 characters limit

. 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 unsubscribe:http

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

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 ?

Choosing between 3.23.46 or 4.0.1 alpha

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

joining tables from selected values

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_file, files_link? or wouldn't this help either? regards, tomas

getting files into BLOBs and some more

How do I insert files inte BLOBs? /problem additional thoughts 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 /additional thoughts regards, tomas ps. this is my first post on this mailinglist, if you

Sum function not uses a valid decimal separator.

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 - Before posting, please check: http

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

Re: mysqldump issues

: select fields from table into outfile 'file' % mysqldump dbname tablename ??? pleasepleaseplease help..! __ Do You Yahoo!? -- Tomas Carmen R. TCC S.A. telef.:+51-1-4428842 fax : +51-1-4426434

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 Tomas

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

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.com

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.com

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.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: http

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 1114

? Thanks in advance Tomas Carmen R.

Re: Hierarchical lists

t unsigned 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: Hierarchical lis

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, 2001 1:52 PM Subject: Re: Avoiding

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

Problem with the UPDATE

Hi , im 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 , im having a strange problem with the update in mys