dropping multiple tables with one command question

Happy New Year!!! What's the command for dropping multiple tables? Example: 12 tables that all start with: phpbb_ What? Well, the install isn't going as planned. I am having to reinstall as I try to work out script path (I think) or some other piece of info that isn't entered correctly, yet.

mySQL in Hebrew/my.cnf

I asked about a week ago how to get mySQL to index correctly in Hebrew, and the best answer that I received was to define a my.cnf file as follows [mysqld] set-variable = default-character-set = hebrew I created the file /etc/my.cnf using the root account, stopped the mysql daemon then restarted.

ZeosDBO 5.5 x 6.1.2 Version

Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform is a future you believe in this new plataform? Regards. Carlos J Souza >From Brazil -- inline: C:\\Documents and Settings\\Administrator\\My Documents\\vectra.JPG

SQL syntax error

Hi All I have been pushing my syslogs to the following mysql table However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax Here are two lines with ' from my syslog: Jan 1 03:58:15 dal-svcs-02.inet.qwest.net 203: *Jan 1 08:58:13.926 UTC: %PFINIT-SP-5-CONFIG_SYNC:

Re: ZeosDBO 5.5 x 6.1.2 Version

Hi Carlos, I tested zeos in my application and 6.1 seems to be faster, and much more simple. Happy new year From Brazil too ;) - Luciano Barcaro Depto. Informática - Laboratório Alvaro Carlos J Souza wrote: Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform

Re: SQL syntax error

Hi Asif, Asif Iqbal wrote: I have been pushing my syslogs to the following mysql table However whenever it sees lines with a ' (apostrophe) it complains about SQL syntax You need to escape those reserved characters, i.e. have ' replaced by \' because otherwise mysql will treat the apostrophe as

Installation Question

I am trying to install MySQL from source distribution by following the instructions under section: 2.3.1 Quick Source Installation Overview. I notice that the configure state is listed as follows: shell ./configure --prefix=/usr/local/mysql which means to install the software in

RE: Installation Question

Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source distribution because it is supposed to be optimized!! Is binary distribution is also optimized or it makes no difference? I personally prefer binary myself. I will wait for a response before I start

RE: Installation Question

-Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I was trying to install the source

Re: Installation Question

I second Ugo's opinion. dan Ugo Bellavance wrote: -Message d'origine- De : Kirti S. Bajwa [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 12:16 PM À : '[EMAIL PROTECTED]' Objet : RE: Installation Question Dan: Thank you fast reply on New Year Day. The only reason I

Remote access FROM a secure server

I have a Perl script running on a secure server (https) and am trying to access the mysql server on a different (unsecure) server. My ISP administrator has done the following: GRANT ALL ON database_name.* TO [EMAIL PROTECTED] IDENTIFIED BY 'password' Then he restarted the server. But I'm still

RE: Remote access FROM a secure server

Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a secure facility so I

Re: Remote access FROM a secure server

Larry Brown wrote: Have you tried to telnet to port 3306 on the server from your local machine to the foreign server? It should give you some feedback as to why your connection is refused. If it times out, the server probably had 3306 blocked. I've not used remote servers other than inside a

RE: Remote access FROM a secure server

-Message d'origine- De : Amer Neely [mailto:[EMAIL PROTECTED] Envoyé : Thursday, January 01, 2004 3:07 PM À : Larry Brown Cc : MySQL List Objet : Re: Remote access FROM a secure server Larry Brown wrote: Have you tried to telnet to port 3306 on the server from your local

Re: Subtracting date fields

Dan, DATEDIFF() only works in MySQL 4.1.1+. RTFM! ;-) Matt - Original Message - From: [EMAIL PROTECTED] Sent: Wednesday, December 31, 2003 2:10 PM Subject: RE: Subtracting date fields Kenneth, try SELECT id, DATEDIFF(firstdate, postdate) AS diff FROM calendar RTFM!

Replicating Table Schema

Hi everyone, I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; Thanks in advance, -gohaku -- MySQL General Mailing List For list

Re: Replicating Table Schema

On Thu, Jan 01, 2004 at 05:42:59PM -0500, Gohaku wrote: Hi everyone, I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; CREATE

RE: Subtracting date fields

Matt, Good point, although he didn't specify what version he was using so I assumed a newer one. Perhaps a disclaimer should have been included? Anyways, Kenneth, if you're using an older version try this: SELECT id, TO_DAYS(firstdate) - TO_DAYS(postdate) AS diff FROM calendar Dan

ZeosDbo Performance question

Dear friends, What version of zesdbo is more faster, 5.5 or 6.1.2? .NET Plataform is a future you believe in this new plataform? Regards. Carlos J Souza From Brazil -- inline: C:\\Documents and Settings\\Administrator\\My Documents\\vectra.JPG

Re: Replicating Table Schema

* Gohaku I was just curious if there's a shorthand way of replicating a Table Schema. I use the following to create a new Table with the same schema. create table new_table ( select * from table); delete from new_table; You can avoid the DELETE by specifying a non-true WHERE clause:

Re: Subtracting date fields

Hi Bob, I did. So it should be assumed he's using 4.1.1 or 5.0? That's pretty stupid. What % of people do you think are using those versions? 1%? 0.1%? 0.01%? I think most people want the most compatible code/syntax/functions if they accomplish the same thing. If you want things to be

Re: special characters as field values

Hi Chris, You're fine with mysql_real_escape_string(). % or _ only need to be escaped if you're using them in LIKE and want them to match iterally. -- never needs to be escaped in a string. BTW, if you're using PHP and the stupid magic_quotes_gpc is on, you don't want to escape stuff yourself

Time series

Hi, I work for a large financial instituition. We are currently evaluating databases to store intraday stock data. These are large tables with 40 million rows per day. We've done some initial testing with MySQL and have been extremely impressed with its speed and ease of use. I know that it

Re: Time series

Hmmm... First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 - Original Message - From: Schulman, Michael [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent: Thursday, January 01, 2004 6:47 PM Subject: Time series Hi, I work for

RE: Time series

That only returns one number.. what we are really looking for is something like SELECT ticker, hour, first(price), last(price) from pricedata group by hour Sorry for the confusion. Thanks, Mike -Original Message- From: Fredrick Bartlett [mailto:[EMAIL PROTECTED] Sent:

Re: Time series

Is Hour a DateTime? If so, will this work... SELECT ticker, DATE_FORMAT(Hour,'%H' ), min(price), max(price) from pricedata order by DATE_FORMAT(Hour,'%H' ) group by DATE_FORMAT(Hour,'%H' ) - Original Message - From: Schulman, Michael [EMAIL PROTECTED] To: 'Fredrick Bartlett' [EMAIL

RE: Time series

As far as I know min(price) and max(price) will return the lowest and higest price, not the first and last in the group. Again I know first and last break the paradaigm of SQL's bucket mentality but it is crucial to doing timeseries analysis. And timeseries aggregation as the query I gave is

Re: Time series - Response....

Hi Mike, I'm working in a large Data Capture Division of Lason Inc. in India, I have developed a Database which is used to report Server Load Server space utilization online, I'm designing this layout with some what critical process. It's not in millian rows per day, but in thousands...

re: mySQL in Hebrew/my.cnf

You should check the error log about why the server didn't start. It should be called yourhostname.err in your data directory. I think the problem is that you put spaces around the second equal sign. The first equal sign set-variable = ... can be surrounded by spaces but the second one ...

Newbie: need form to input records View report

I know this sounds stupid but I'm totally lost. I've created a MySQL DB whose purpose is to track customers who have not gotten a newspaper. I've created all the necessary fields, and have managed to learn how to add/delete/modify the records in mysqlcc, but what I want is to have a predesigned

Re: Time series

First: select * from table1 order by field1 asc limit 1 Last: select * from table1 order by field1 desc limit 1 That only returns one number.. what we are really looking for is something And worse: as far as I can tell 3.22.x even if field1 is indexed, ONE of those queries is going to be very

Re: Time series

on 1/1/04 9:59 PM, Schulman, Michael wrote: That only returns one number.. what we are really looking for is something like SELECT ticker, hour, first(price), last(price) from pricedata group by hour Well, if you're using MySQL 4.1+, you're in luck. A subquery should help. SELECT ticker,

Primary Key

I saw an example of creating tables (see below). I wonder what the primary key (user_name, role_name) in the table user_roles means? Does it mean that both user_name and role_name are the primary key of the user_roles table? How does a table have two primary keys? create table users (