SELECT by date plus get both next and last dates with data in it

Hello, Having some problems trying to get the correct data from MySQL. I need to grab a bunch of information based on a date the user selects (no problem there). However, this is an events type situation, where I want to give people an easy option to move forward or backwards through the

effective handling of fuzzy dates (MySQL/PHP)

Hello, Please excuse me if this has been posted in the wrong spot. I'm storing historical information in a MySQL database and am using the date field formatted in -MM-DD. For the most part, the data entered is correct and uses the full -MM-DD format, however, I've got numerous dates

Re: system requirements for MySQL db requiring large selects

or quad processors in a single box. On Jan 23, 2005, at 12:12 PM, why me wrote: We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select

system requirements for MySQL db requiring large selects

We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select performance. There will be multiple table joins to perform our query. I hope your experience

system requirements for large selects

We are looking for buying a new server for running MySQL database. The database is around 50-70G and individual tables run to 5 - 15 GB. There wont be any frequent updates instead we need maximum select performance. There will be multiple table joins to perform our query. I hope your experience

Re: privileges not updating

On Wednesday, July 2, 2003, at 04:42 AM, Victoria Reznichenko wrote: me [EMAIL PROTECTED] wrote: i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE

privileges not updating

hi everybody, i have a strange thing going on - i'm trying to update privileges on some databases but it doesn't happened - even after flush privileges - according to the manual the changes with GRANT an REVOKE should take effect immediately but they don't. i'm using command line also if i

CREATE TABLE with date as part of table name

I would like to know how to create a table within MySQL at the command prompt where the table name will be something like: MyTableName_TodaysDate Is this possible while at the command prompt? I am trying to create a batch file that will create a table in MySQL based on todays date. The

Lost connection to MySQL server during query

/mysql/* files again, and replaced them with the old backup, and restarted mySQL. Still the same problem. (Lost connection..) I now deletet all the mysql rpm's (and deletet /var/log/mysql/*) and reinstalled them. Still the same problem. Im not a guru or anything, but for me it looks like it act like

Creation query problem!!

Hello, will someone please point out what I am missing here for these creation query, one uses backquotes, while the other does not, for some reason, the one without back quotes errors!! What am i missing?? Is there a reserved word I am missing?? MySQL 3.23.41 CREATE TABLE email ( emailid

Re: mysql 3.23.50

Hi! http://www.mysql.com/downloads/mysql-3.23-pre.html EG where can i get the 3.23.50 packages with innodb support ? Pierre -- sql,query - Before posting, please check: http://www.mysql.com/manual.php

Re: InnoDB foreign key constraints

what's wrong. I've been reading TFM, and the sentence there must be an index where the foreign key and the referenced key are listed as the first columns seems to have something to do with my problem, I just find the above a bit... well... cryptic. If anyone could lend me a hand, I'd be more than happy

Re: Users

Hi! A little effort please http://www.mysql.com/doc/A/d/Adding_users.html and http://www.mysql.com/doc/D/e/Default_privileges.html EG Hi all How do i create users in mysql.. After installing i just start mysql and connect to it.. Whats the default username and password it uses..

Re: on update problem?

Hi! don't think ON UPDATE is supported. The manual : http://www.innodb.com/ibman.html doesn't mention anything about it except : Starting from version 3.23.50 you can also associate the ON DELETE CASCADE or ON DELETE SET NULL clause with the foreign key constraint. EG When I try to change

InnoDB Delete On Cascade

, INDEX par_ind (parent_id), FOREIGN KEY (parent_id) REFERENCES parent(id) ON DELETE CASCADE ) TYPE=INNODB; Created two records : insert into parent values(5); insert into child values(0,5); Ok this works all fine. Also geives me

Re: limitation in mysql

Hey, Hi, Is there any limitation about the number of rows in a table and about the number of tables that i can put in mysql? Question has been asked many times. Check the lists. Answer : no, only limited by drive space. EG

Re: time

as hh:mm:ss format. is there any query in mysql to get these things in the hh:mm:ss format. plz respond me to [EMAIL PROTECTED] tnx bobbie __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com

Re: Mysql.sock missing

Heya! Perhaps because its mysqld.sock ? Check your my.cnf file to see how your configuration is configured (what file and what path the socket file is) [mysqld] socket = /var/run/mysqld/mysqld.sock EG Hello all, I am facing very strange problem I am not having mysql.sock in

Re: New Problem with LAMP

my tables and put the data inside. This is fine. Next step is to create a PHP-Website which communicates with the database, but i am not able to connect over my apache (this is what it seems to me). to log into the database I use mysql -p dkv (password is ppp user is dcp) anything

Re: New Problem with LAMP (CORRECTION)

step is to create a PHP-Website which communicates with the database, but i am not able to connect over my apache (this is what it seems to me). to log into the database I use mysql -p dkv (password is ppp user is dcp) anything is ok. my php-script looks like this: ?php $host

Re: New Problem with LAMP (CORRECTION)

Hi! I'm not very used to php but its in php.ini : mysql.default_socket EG - Original Message - From: Dennis Peyerl [EMAIL PROTECTED] To: Me [EMAIL PROTECTED] Cc: mysql [EMAIL PROTECTED] Sent: Thursday, March 28, 2002 1:00 PM Subject: Re: New Problem with LAMP (CORRECTION) Thank

Any low budget database access available ???

Hi, I am hoping to find somebody who provides low budget mysql and php access. Thank you very much for any suggestion Andonny - Before posting, please check: http://www.mysql.com/manual.php (the manual)