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 syst

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

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

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 int(

Antwort: RE: Antwort: Re: any ASP/ADO/MySQL programmers out there? (LONG answer)

Ja, das is ganz richtig. Ich glaube wenn Mann hier postet, shreibt hier nur English bitte. Kein Deutsch order Nederlander (ich glaube das ist Nederlander. Vieliecht nicht). -Original Message- From: John Dean [mailto:[EMAIL PROTECTED]] Sent: Wednesday, February 28, 2001 8:33 AM To: [E

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) http://lists.mysq

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 nume

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 dat

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 wil

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 wil

Re: system requirements for MySQL db requiring large selects

t's bandwidth > between CPU and RAM. > If money is no object, a Power5 (PowerPC) based > system can scale pretty > high, going well beyond dual or quad processors in a > single box. > > > On Jan 23, 2005, at 12:12 PM, why me wrote: > > > We are lookin

Lost connection to MySQL server during query

ed the /var/lib/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