Re: [NEWBIE] How To Trim Database To N Records

Is there a query that will, say, trim a table down to a million rows (with some sort order, of course, as I'm interested in deleting the oldest ones)? If you have got a datecolumn, you might also want to delete anything that is older than x days (2 in my example): DELETE FROM database.table W

RE: Fulltext and reserved words

Hi, I did everything but rebuild, I restarted the server but the variable still has the same value. And I don't know how to rebuild the table, I read the documentation, but I guess I am just missing something there, like I have no idea as a newbie where to enter those commands etc. Kind regards

RE: Fulltext and reserved words

Hi Taco - interesting thread. Did you rebuilt the FullText indexes after restarting the server? >From the 5.0.18 manual pages: 12.7.5. Fine-Tuning MySQL Full-Text Search Most full-text variables described in this section must be set at server startup time. A server restart is required to ch

~problem with select into outfile~

Hi Iam having a problem using "select into outfile" command, iam getting the following error. can anyone help me trace the problem. mysql> SELECT * INTO OUTFILE'/home/public1/data.txt' FROM temp_table WHERE last_time_update = "2006-04-01"; ERROR 1 (HY000): Can't create/write to file '/home/publi

innodb vs myisam

Hi. I have the following myisam table: The table is only 32,000 rows, but over 60Megs in size. And mysql seems to be wanting to write to that file alot, so it may well be trying to seek all over the disk looking for the right spot all the time. Does innodb do a better job at keeping the file on

Re: [NEWBIE] How To Trim Database To N Records

--- "David T. Ashley" <[EMAIL PROTECTED]> wrote: > Hi, > > I'm a beginning MySQL user ... > > I have a table of log entries. Over time, the entries could grow to > be > numerous. I'm like to trim them to a reasonable number. > > Is there a query that will, say, trim a table down to a millio

Re: question

--- Takanobu Kawabe <[EMAIL PROTECTED]> wrote: > Is there any way to set many columns of the table in one line? > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > The UPDATE command is n

Re: [NEWBIE] How To Trim Database To N Records

At 11:15 PM -0400 4/12/06, David T. Ashley wrote: Hi, I'm a beginning MySQL user ... I have a table of log entries. Over time, the entries could grow to be numerous. I'm like to trim them to a reasonable number. Is there a query that will, say, trim a table down to a million rows (with some

[NEWBIE] How To Trim Database To N Records

Hi, I'm a beginning MySQL user ... I have a table of log entries. Over time, the entries could grow to be numerous. I'm like to trim them to a reasonable number. Is there a query that will, say, trim a table down to a million rows (with some sort order, of course, as I'm interested in deleting

customized variations on words with fulltext

Hi all, sorry for all the questions lately, just getting my feet wet in MySQL. Is there any way to create my own variations on words so that MySQL will include those in the fulltext search? What I am after is for example if someone enters VB, I'd like the search to also look for; - Visual Bas

question

Is there any way to set many columns of the table in one line? -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

comparing 2 dbs and generating 'upgrade sql'

hey guys, A while ago I remembered using SQLYog or some other tool that could look at two databases (say dev and test versions) and work out the differences in structure between the two, and generate some SQL to 'upgrade' one to the other (bunch of alter table commands basically). I'm won

RE: Fulltext and reserved words

Thanks for that, you saved the day. I am now trying to change that variable, I did a search through the ini files and changed the only file that had ft_min_word_len in it to ft_min_word_len = 2 restarted the server did SHOW VARIABLES and it still shows as 4, not sure what I am missing, going throug

Re: MySql Error Number 1130

When you are trying to connect to port 3307, for example, are you specifying that port from your remote machine? Or are you connecting to the mysqld listening on port 3306? You could try shutting down the server listening on port 3306, and then connecting to port 3307. See if the error messag

MySql Error Number 1130

Hi all, I am setting up two additional instances of mysql on my mysql server, which is running version 5.0.18-standard-log. I've got the additional instances set up, and they are running. I can see that they are bound to the proper ports. I can connect to them locally like mysql -p --port=330

Re: Select a value between dates.

George Law wrote: This brings up a question I was asked... Which is more efficient? Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd hh:mm:ss' This one. Or Select . where unix_timestamp(date) between unix_timestamp('-mm-dd hh:mm:ss') and unix_timest

RE: Select a value between dates.

This brings up a question I was asked... Which is more efficient? Select . where date between '-mm-dd hh:mm:ss' and '-mm-dd hh:mm:ss' Or Select . where unix_timestamp(date) between unix_timestamp('-mm-dd hh:mm:ss') and unix_timestamp('-mm-dd hh:mm:ss')

Fw: Select a value between dates.

I'm putting your question back on the mailing list where it belongs. That enables others to help and to learn from the discussion, either now or in the future via the archives. -- Rhino - Original Message - From: "H L" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Wednesday, Apri

Re: Looking for advice on how to store and query some data

--- Russell Horn <[EMAIL PROTECTED]> wrote: > Hi, > > I'm storing data against a bunch of people and want to track how it > changes. So, I have a person table where everyone has a person ID and > a > results table a bit like this: > > | personID | classification | date | > | 1| 0

Re: Best practices

Answers intermingled below --- Bruno B B Magalh�es <[EMAIL PROTECTED]> wrote: > Hi guys I need some help with two things... > > I have the following table: > > CREATE TABLE `telephones` ( >`contact_id` int(20) unsigned NOT NULL default '0', >`telephone_id` int(20) unsigned NOT NUL

RE: Return virtual records

--- Ed Reed <[EMAIL PROTECTED]> wrote: > Thanks for the response but neither one of the responses I've > received does exactly what I need since they don't return multiple > rows. > > Are there any other ideas out there? > > Thanks > > >>> "Jay Blanchard" <[EMAIL PROTECTED]> 4/7/06 12:37:32

Do foreign keys affect query speed?

That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions , e.g., "If so, how best to optimize a query for them?" And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that can pro

Do foreign keys affect query speed?

That's the whole question. Do foreign keys (FKs) affect query speed? 'Course the answer could lead to sub-questions , e.g., "If so, how best to optimize a query for them?" And I guess a corollary question would be whether implementing FKs slows down MySQL processing in general, but that can pro

MySQL 5.0.20 has been released

Hi, MySQL 5.0.20, a new version of the popular Open Source Database Management System, has been released. The Community Edition is now available in source and binary form for a number of platforms from our download pages at http://dev.mysql.com/downloads/ and mirror sites. Note that not all

RE: Return virtual records

Thanks for the response but neither one of the responses I've received does exactly what I need since they don't return multiple rows. Are there any other ideas out there? Thanks >>> "Jay Blanchard" <[EMAIL PROTECTED]> 4/7/06 12:37:32 PM >>> [snip] Anyone have an idea on this? Can anyone exp

RE: Error on T_echo ?? what is this ?

t;>>>> -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 1.1485 (20060412) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL

RE: Error on T_echo ?? what is this ?

a into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo "Query Finished"; <<<<--here is ALL my code -->>>>> -- MySQL Ge

Re: Fulltext and reserved words

In the last episode (Apr 12), Taco Fleur said: > I am in need to search for sql reserved words with MATCH AGAINST it > turns it doesn't return anything when I feed it a reserved word like > 'sql' is there anything I can do about that? By default the full-text indexer skips words less than four cha

RE: Error on T_echo ?? what is this ?

or list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] __ NOD32 1.1485 (20060412) Information __ This message was checked by NOD32 antivirus system. http://www.eset.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Error on T_echo ?? what is this ?

Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo "Q

Re: Error on T_echo ?? what is this ?

This is not a PHP list and that's a PHP error. But you are missing a semi-colon at the end of the line "...`BondRem`)". Eric Brian E Boothe wrote: i,m getting the following error on my MySQL Code inserting data into a database, .? `OthrProjBill`, `OthrRem`, `BondAm`, `BondBill`, `BondRem`)

RE: Error on T_echo ?? what is this ?

I believe you are missing the trailing semicolon from the previous line of code, before the "//confirm" comment. It's a rather cryptic way of saying it found "echo" when it expected something else first. Gotta love those PHP error messages. -- Jason Teagle [EMAIL PROTECTED] > -Original Messa

RE: Error on T_echo ?? what is this ?

[snip] i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo "Query Finished

Error on T_echo ?? what is this ?

i,m getting the following error on my MySQL Code inserting data into a database, .? *Parse error*: parse error, unexpected T_ECHO in c:\inetpub\wwwroot\projects\testsum\adddata.php on line 30 LINE 30 is echo "Query Finished";

Re: Can't search words of three letters?

I ca try that one too. Since, I'm bad with reg expressions, what would be solution for something like "match searched word and it's plural - if one word entred, or match all words - if more words entered"? thanks -afan > Why not try regex? > > http://dev.mysql.com/doc/refman/4.1/en/regexp.html

Re: Can't search words of three letters?

On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > > Hi to all, hi I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt". > I was suggested to use MATCH() AGAINST() and it works perfect

Re: Can't search words of three letters?

Why not try regex? http://dev.mysql.com/doc/refman/4.1/en/regexp.html On 4/12/06, [EMAIL PROTECTED] <[EMAIL PROTECTED]> wrote: > Hi to all, > I have to build a search of products on web catalog site. It has to search > a whole words to avoid when somebody search for a pin and get "*pin*k > shirt"

Can't search words of three letters?

Hi to all, I have to build a search of products on web catalog site. It has to search a whole words to avoid when somebody search for a pin and get "*pin*k shirt". I was suggested to use MATCH() AGAINST() and it works perfect - until I dscovered that I'm getting alwayes 0 results if search for cap,

RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)

I don't have a 5.0+ server to test with right now but this should work --- Daevid Vincent <[EMAIL PROTECTED]> wrote: > I was using SQLYog 5.03 RC1. > > vmware ~ # mysql --version > mysql Ver 14.12 Distrib 5.0.19, for pc-linux-gnu (i686) using > readline 5.1 > > But just to sanity check. I ssh'

FW: Mysql C API character set

From: He, Gang Sent: Wednesday, April 12, 2006 8:43 PM To: '[EMAIL PROTECTED]' Subject: Mysql C API character set Hi, I install MySQL server 4.1.12 in Redhat Linux in Japanese environment ( env LANG=ja_JP.UTF-8 ), I setup MySQL server utf8 characte

Fulltext and reserved words

I am in need to search for sql reserved words with MATCH AGAINST it turns it doesn't return anything when I feed it a reserved word like 'sql' is there anything I can do about that? Thanks in advance Kind regards, Taco Fleur Free Call 1800 032 982 or Mobile 0421 851 786 Pacific Fox

RE: FW: New to TRIGGER and CALL. Example gives errors. (repost)

REMOVE the semicolon ";" from " END;//" SQLyog has a problem with all of the procedures, functions and triggers RE the DELIMITER syntax. > -Original Message- > From: Daevid Vincent [mailto:[EMAIL PROTECTED] > Sent: Tuesday, April 11, 2006 10:00 PM > To: mysql@lists.mysql.com > Cc: 'Shawn

RE: counting keywords

At 1:55 PM +1000 4/12/06, Taco Fleur wrote: Hello Steve, Your suggestion works like a charm, I am now trying to get my head around your following statement, I can't seem to get a grip on what you mean. Is there anyway you could elaborate a little on the following? It would be really nice if I co

Re: mySQL Backups

On 4/12/06, Tim Lucia <[EMAIL PROTECTED]> wrote: > Would you not lock tables on the slave? The idea of catching it up implies > this is way it is done. Catching up means once replication can proceed once > the tables are unlocked (on the slave). > > At least that is the way I read it... On the s

RE: [SOLVED] Making result rows to one row

Yes, you are correct. I tried it but I got some errors. I simplified my query and tried it, and it worked. Then I added the more complicated parts after that, and it works VERY good. This is what makes life worth living :) -Original Message- From: Peter Brawley [mailto:[EMAIL PROTECTED]