Help with AVG query

Hi every: I have this table: smp_evaluacion --- id_evaluacion eval1 eval2 eval3 eval4 eval5 This is for a rating system. I need to build a query for retrieve the best rating files. Normally with PHP I add every field, I mean (eval1, eval2, eval3, eval4, eval5) and then

Problems with MySQL Migration Toolkit

I have downloaded sucesfully the MySQL Migration Toolkit tool. After start the error with Java appears. I have Java installed on my PC because I work with Eclipse 3.1.1 + PHPEclipse Plugin. The JDK installed is 1.5. So if any can help me ... Regards, -- ReynierPM 4to. Ing. Informática Linux

mysqldump command

I try to create a cron in Linux (Debian Sarge) and the content for this cron is a mysql database backup. I read documentation about mysqldump command and use, but I forgot something because it not works for me. I put this in bash: # mysqldump --opt -c -C dp > /var/tmp_save/dproject.sql But when I

Help with query optimization & query SUM

Hi: I'm develop a simple shopping cart. I have this two tables: carro_de_compras -- IDU int(11) NOT NULL IDA int(11) NOT NULL CantidadDeArticulos int(11) NOT NULL os_articulo -- IDA int(11) NOT NULL auto_increment, IDC int(11) NOT NULL default '0', ANombre varchar(200) NOT NULL def

MySQL 5.0.15 in Linux OS

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 I read the online documentation looking if I need some configuration changes and see that for execut

Query How To

Hi list I need to make a Quero that select all fields in wich the date are inferior in 10 days to actual date. Something like this: Actual date: 18-04-2005 Select all fields in which are bigger than: 08-04-2005. How can I do this? Regards Reynier Pérez Mira 3ero. Ing. Informática Ent