table status: Create_time

on the number of rows and the Create_time. We have far too many tables to just alter them all in one sitting so we do them as needed. Thanks. -- Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: aggregate count and group by

Jim Grill [EMAIL PROTECTED] wrote on 02/18/2005 03:17:39 PM: Hi, I need some SQL guru help on this one. I'm trying to re factor an existing application where a number of clicks grouped by keyword for two different time periods are needed. For example, a user picks a date range

Re: replication, table db already exists

. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

aggregate count and group by

help. ??? Thank you for the help! -- Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Temporal values VS. int values

consisting of up to a few months worth of data at a time. Thanks, Jim Grill

Re: Sync db

that will shed some light on the subject. Jim Grill yeah, I seen that have. Have you tried that before? I need to do it two-way. But have not seen any special setup for that. Each site will be entering data and all sites will need to see the updated change. On Fri, 01 Oct 2004 10:38:07

Re: (if !update then insert) sequence - result Duplicate key :(

logic and try to use REPLACE or INSERT ... ON DUPLICATE KEY UPDATE. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: high availability question

how safe this idea is and I'm sure that some unnecessary overhead is introduced by testing for live connections all the time. My best advice to you is to set up a few servers and start testing. Replication is not at all hard to accomplish. Best of luck. Jim Grill Hi Jim, Hi all! Doing a two

Re: How to pick the oldest row

? Try adding something like ORDER BY d DESC LIMIT 1 Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Addslashes / data sort

' | +--+--+ The slashes never actually get inserted into the table so there is no need to call strip_slashes() on the results either. :-) Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Conexiones no autorizadas

Hola , Estoy empezando a notar intentos de ingreso con usuarios ilegales no existentes) a mi server. Mi pregunta es : Como lo rastreo teniendo como unico dato el numero de ip desde el cual se esta conectando? O si alguien tiene una mejor idea o ha pasado por lo mismo, le agradecere

Re: SELECT queries on replicate DB server

administrator would probably do it a different way. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: studying for the certification exam

kind of confidence with MySQL. Although I have not taken the exam, I am feeling pretty confident that I can pass after reading the online manual and the study guide from front to (almost) back. I hope I'm right about that feeling! Wish me luck :-) Best of luck to you, too. Jim Grill

Re: [OFF-TOPIC] MySQL License Question

and this is covered in the first chapter of the study guide. :-) Regards Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to change mysqldump output txt file format?

not actually get inserted into your table with the slashes. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: how to change mysqldump output txt file format?

. That would be a cool option though. :-) There are a number programs that can assist with converting to and from MySQL if that's the goal. Regards, Jim Grill - Original Message - From: [EMAIL PROTECTED] To: Jim Grill Cc: Monet ; mysql Sent: Friday, September 24, 2004 1:59 PM

Re: how to change mysqldump output txt file format?

-by= to make a csv file. You can use BCP or MS DTS to load a csv into sql server tables. There may be another sql server equivelant to LOAD DATA INFILE that can accept csv or tsv. Who knows??? Good luck, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: browser form question

(name) VALUES(CONCAT(UCASE(LEFT('jim',1)),SUBSTRING('jim',2))); SELECT CONCAT(UCASE(LEFT(name,1)),SUBSTRING(name,2)) FROM testing; :-) There might be a better way to do this too??? I do agree that you should probably handle this with simpler functions in your app like php's ucfirst(). Jim Grill

Re: mysql still can't start up

http://www.catb.org/~esr/faqs/smart-questions.html Stop repeating the same question or you will never get an answer. Try again please. Hi I have installed some software on aix5.2 . the list of software: apache-1.3.29-1.aix4.3.ppc.rpm php-4.0.6-5.aix4.3.ppc.rpm

Re: Mysql and PHP

a year ago. Any ideas? Thanks! Nestor :-) http://www.IneedWork.org How about some more info. Did you install PHP from source or an RPM? Did you configure PHP --with-mysql or --with-mysqli? Did you install MySQL after you installed PHP and Apache or before? Regards Jim Grill -- MySQL

Re: 4.1.4a-gamma in production?

Gamma to Production. However, Gamma status indicates that no major bugs have been found for over a month. IMHO: With an estimated (and growing) user base of over 4 million (early 2003) I'd say that Gamma is more than safe enough to use in a production environment. Regards, Jim Grill -- MySQL

Re: mysql still can't start up OT

/to/mysql.sock Make sure that the directory is owned (or at least writable) by the user that MySQL runs as or you will get the dreaded MySQL ended errors when starting the server. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: mysql still can't start up OT

without the quotes under the [mysqld] and [client] sections of your my.cnf file. 2) Specify it when starting the server like mysqld_safe --socket=/path/to/mysql.sock 3) Reconfigure mysql adding --with-unix-socket-path=/path/to/mysql.sock Regards, Jim Grill -- MySQL General Mailing List For list

Re: Problem with tables;

| ++ 1 rows in set (0.00 sec) Try doing 'desc spamdata' There is no table named id; hence the error. Regards, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: question

connect to local MySQL server through socket '/tmp/mysql.sock' (2) is due to the fact that mysqld is not running when you try to connect via the mysql client. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Re: Compilation Error

a clean start.) CFLAGS=-O3 -mcpu=pentiumpro CXX=gcc CXXFLAGS=-O3 -mcpu=pentiumpro \ -felide-constructors -fno-exceptions -fno-rtti \ ./configure --your options here change -mcpu=pentiumpro to suite your system (i386, i486, i586, i686, pentium, pentiumpro, k6, or athlon). Jim Grill -- MySQL

Re: MYSQL CONNECT ISSUE

port is 3306 Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: help urgent please

The --add-drop-table will add a DROP TABLE IF EXISTS tablename to your script before creating and populating the tables. This is useful when restoring a possibly corrupt table. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: when to use backquote in SQL

if an application your working on requires table names or field names to be supplied from user input (always a bad idea) like a select box. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table fixed BUT...Re: Table crashed! Please help

table WHERE id=[your duplicate value] LIMIT 6; Now you have one left. I hope that helps. Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table fixed BUT...Re: Table crashed! Please help OT

communication problems between Navicat and MySQL caused the problem to begin with, which brings me back to my first thought. Best of luck to you, Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: sql problem

an IF. SELECT parent.id, parent.name, IF(child.parent_id IS NULL, 'none', COUNT(child.parent_id)) AS child_count FROM PARENT INNER JOIN CHILD ON parent.id=child.parent_id GROUP BY parent.id; Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: sql problem

This is not meant as an rtfm, but this helped me in the past. http://www.devshed.com/c/a/MySQL/Understanding-SQL-Joins/ Jim Grill -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]