Re: is 'start' a keyword?

From: "rik onckelinx" <[EMAIL PROTECTED]> > where "FULLTEXT" was causing the error. My workaround was renaming (in the sql > create table scirpt) > > fulltext -> ful_text > option -> optio_ The easiest solution to preventing these errors from popping up from time to time is to put backticks (`)

Re: Copy table?

John Mistler wrote: Is there a way to make an exact copy of a table and give the copy a new name? Thanks, John From the doc : As of MySQL 3.23, you can create one table from another by adding a SELECT statement at the end of the CREATE TABLE statement: CREATE TABLE new_tbl SELECT * FROM orig_tbl

Re: match a fulltext search with a "-" dash, can't match if - exist

> mysql> select * from fullsearch where match (title,body) against ('018-E'); > Empty set (0.00 sec) > > > it returns an empty set, is it possible to also search with "-" dash? chars? I'm not an expert but others will correct me : In a fulltext search, the search string must be at least 4 char

Re: flush and flush delay

Thanks for this. Very useful. In particular your idea of using a RAM disk sounds interesting but I am not sure how you imagine I use it? I presume that on power down everythign on a ramdisk is lost so on every power=up I would have to put my data directory on the RAM-disk while the settings in

match a fulltext search with a "-" dash, can't match if - exist

this is a working example i found on mysql.com this is my example of fullsearch mysql> desc fullsearch; +---+--+--+-+-++ | Field | Type | Null | Key | Default | Extra | +---+--+--+-+-+-

RE: COUNT Problem

Hi Shaun! I beg you pardon, my last message was incomplete! I will quote the last lines from my previous post: ---8<- Cut here ---8<--- > > - Thanks to the LIMIT clause, we get only the first result, which by > the way is one of the projects with the most assigned tasks.

Re: COUNT Problem

Frederic Wenzel wrote: On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh <[EMAIL PROTECTED]> wrote: A Project will have 1 or more tasks assigned to it. Using the following query, how can I modify it so that I can find out the largest number of tasks assigned to a group of projects. SELECT P.*

RE: COUNT Problem

Hi Shaun! > A Project will have 1 or more tasks assigned to it. Using the > following > query, how can I modify it so that I can find out the largest > number of > tasks assigned to a group of projects. > > SELECT P.*, T.* > FROM Projects P, Tasks T > WHERE P.Project_ID = T.Project_ID > AND P

Re: COUNT Problem

On Sun, 17 Oct 2004 19:36:34 +, shaun thornburgh <[EMAIL PROTECTED]> wrote: > A Project will have 1 or more tasks assigned to it. Using the following > query, how can I modify it so that I can find out the largest number of > tasks assigned to a group of projects. > > SELECT P.*, T.* > FROM Pr

Re: COUNT Problem

Hi, Tihs looks to me as too few information. What is in your tables (the information)? What does the query return (a empty set)? Maybe 'cause in your where clause where you have Project_ID >2 you should have Project_ID=2? Or you have several projects with ID>2 and you want tasks for all of

COUNT Problem

Hi, I have the following two tables in my database: mysql> DESCRIBE Projects; +--+--+--+-+-++ | Field| Type | Null | Key | Default | Extra | +--+--+--+-+-++ | Pro

Re: Show databases shows all even if no rights;

On 10/17/2004 7:12 AM, Michael J. Pawlowsky <[EMAIL PROTECTED]> wrote: > All priviliges for that user in mysql.user are set to N. > I know this is hard to read but here are the outputs from user and db. [snip] > Paul DuBois wrote: > >> At 10:02 -0400 10/16/04, Michael J. Pawlowsky wrote: >> >>

Re: flush and flush delay

Those 2 variables are explained in the manual . flush This is ON if you have started mysqld with the --flush option. This variable was added in MySQL 3.22.9. flush_time If this is set to a non-zero value, all tables w

Re: Query help

In article <[EMAIL PROTECTED]>, John Mistler <[EMAIL PROTECTED]> writes: > I need help coming up with the following query: > My table: > +-+--+ > | rowID | dateOfPurchase | > +-+--+ > | 1 | '2004-1-17 08:00:00'

Re: Can MySQL do this?

Hi Skip, See my remarks interspersed in your note. By the way, I'm copying the mailing list so that others can benefit from the discussion, either now or somewhere down the road via the archives. Rhino - Original Message - From: "Skip Taylor" <[EMAIL PROTECTED]> To: "Rhino" <[EMAIL PRO

Re: Replication: update to data missing

Ralf E. Stranzenbach wrote: i have a mysterious problem regarding a replication set-up of two mysql databases (4.0.18). If i change data in the mysql database, this data is not replicated. If i create a new database on the master, this database does not show on the slave. If i change the existing d

Re: Show databases shows all even if no rights;

All priviliges for that user in mysql.user are set to N. I know this is hard to read but here are the outputs from user and db. +---++--+-+-+--- --+-+-+---+-+---+--- ---+

flush and flush delay

Hello, I am using a MySQL database for a somewhat odd application. In this application I will have relatively small tables and relatively few tables. I would like to set the variables so that all the operations on the database takes place in RAM and that it does not write to disk unless explici