Re: Question

On Tuesday 03 October 2006 10:57, Feliks Shvartsburd wrote: Does anybody know how can I see what queries are currently being executed? From the mysql commandline, use show processlist; There is also a program called mytop which shows what's executing. -Chris -- MySQL General Mailing List

Combined Primary Key and Auto Increment Primary Key

; note that this table will mostly consist of table writes (updates, inserts, deletes). -- Chris White PHP Programmer Interfuel -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

communication error

it is corrected? mysql: Ver 14.12 Distrib 5.0.22, for sun-solaris2.8 (sparc) using EditLine wrapper Thanks for any insights. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: fields separator

sed -r s/ +/\t/g infile.txt or perl -e s/\s+/\t/g and print $_.\\n\ while infile.txt -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: where url = 'x' with url a TEXT field

Peter Van Dijck wrote: Thanks.. the problem is I'm running MySQL 4.1.16 I might try FULLTEXT... U can create normal indexes on text columns if u specify a prefix length. -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http

Re: dir /w mysql

perl -e chomp and print \INSERT INTO FILES SET `fname` = '$_'\n while current.tmp -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: dir /w mysql

U can install perl for windows from ActiveState. U can also get sed for windows from Cygwin. These tools should be considered mandatory. Scott Hamm wrote: Sorry, I'm using Windows cmd shell, no perl, no linux stuff. :( -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED

Re: making varchar field to act like numeric field

suggested. However I'm unclear as to why you would store numeric data in a var char field. If at all possible it would be better to store it in a numeric field. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere

Re: Mysql Stat - Help required

Ratheesh K J wrote: Hlo, I got this Stat of MySQL. I want to know is there something to worry about, especially the number of temp tables. That looks like a sign of missing indexes. Temporary tables shouldn't be created that often if your queries are indexed properly, even though they're

Re: fields separator

[EMAIL PROTECTED] wrote: hi, everyone! I have a text file like this: 10:10:00 0 0 1 99 10:20:00 0 0 1 99 10:40:00 11 3 4 83 11:00:00 1 1 2 97 11:05:00 2 1 1 96 I need to load this

Re: Mysql Stat - Help required

, grouping, table joins, subqueries (possibly).. - Original Message - From: Chris [EMAIL PROTECTED] To: Ratheesh K J [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Wednesday, September 27, 2006 12:50 PM Subject: Re: Mysql Stat - Help required Ratheesh K J wrote: Hlo, I got this Stat

Re: fields separators

Pe 27 Sep 2006, la 10:29, Chris [EMAIL PROTECTED] a scris: Did you try using a space (' ') as the separator? Did you get an error? And at 7:41 + 27/9/06, [EMAIL PROTECTED] wrote: Yes, I did. ... So, I need to specify somehow that the fields are delimited by any number of spaces

Re: Red Hat slow query log

Brian Dunning wrote: Before I do this, I just wanted to check with you all to see if this is the correct command: /etc/rc.d/init.d/mysqld restart --log-slow-queries If so, where exactly will I find the slow query log? Will the slow query log be turned off by default next time I restart it?

Re: Low priority copy?

This is a situation where u should use mysqlhotcopy. That gives u a snapshot of the current table and lets u work on it offline while the real table is available. hotcopy table A to B blank table A to allow inserts work on table B merge A into B delete A rename B to A -- Chris Wagner CBTS GE

Re: How to delete all rows....

mos wrote: At 08:41 PM 9/25/2006, you wrote: Dilipkumar wrote: Hi, Its delete * from table will only do if you go for a truncate it will recreate the table structure ? It's better to use delete. Can you explain why? I'd go for instant truncate rather than waiting around for delete to

Re: Requesting help with subquery

= lv.baseitemid )), 'Y', 'N') AS Lang Avail Looks to me as if your parentheses don't balance here - you have an extra ')' in that last line. -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ I once preached peaceful coexistence with Windows. You may laugh at my expense - I

Re: How to delete all rows....

Dilipkumar wrote: Hi, Its delete * from table will only do if you go for a truncate it will recreate the table structure ? It's better to use delete. Can you explain why? I'd go for instant truncate rather than waiting around for delete to finish. -- MySQL General Mailing List For

Re: FIND DATA location

Hal Wigoda wrote: how do you find where mysql data resides? The my.cnf file contains a line like this: datadir=/var/lib/mysql -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: What mysql 5.0 binary relase use for CentOS 4.4 Pentium?

[EMAIL PROTECTED] wrote: Hi. What binary relase use for CentOS 4.4: * Linux (x86, glibc-2.2, standard is static, gcc): mysql-standard-5.0.24a-linux-i686.tar.gz * Linux (x86): mysql-standard-5.0.24a-linux-i686-glibc23.tar.gz In

Re: How to delete all rows....

But how will that interact with the auto increment counter? Will truncate reset the counter. Chris wrote: Peter Lauri wrote: DELETE FROM table Truncate will be a lot better. DELETE FROM table will do it row by row which also means it will have to update any indexes applicable

Re: How to delete all rows....

Peter Lauri wrote: DELETE FROM table Truncate will be a lot better. DELETE FROM table will do it row by row which also means it will have to update any indexes applicable to the table as it goes... Lots of data lots of indexes = very slow. -- MySQL General Mailing List For list archives:

Re: How to delete all rows....

Wagner, Chris (GEAE, CBTS) wrote: But how will that interact with the auto increment counter? Will truncate reset the counter. According to the docs it will: http://dev.mysql.com/doc/refman/5.1/en/truncate.html The table handler does not remember the last used AUTO_INCREMENT value

Re: Difficult query

Neil Tompkins wrote: Hi I've the following tables (holds a list of companies) TableName:Company CompanyID (int) CompanyName (varchar) (holds a list of areas) TableName:Area AreaID (int) AreaName (varchar) (holds a list of what areas are near to what companies),

Re: How to sort last n entries?

At 10:41 +0200 15/9/06, Dominik Klein wrote: I have a table with primary key id. Another field is date. Now I want the last n entries, sorted by date. Is this possible in one SQL statement? ORDER BY `date` DESC LIMIT n -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk

Re: Sort Problem

. Of course the output is not rounded. The following are a few examples of the output of the round statement. ROUND(23.632, 2) = 23.63 ROUND(23.632, 1) = 23.6 ROUND(23.632, 0) = 24 ROUND(23.632, -1) = 20 -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts

taking MySQL down into admin mode

? I haven't seen anything promising in the manual. We're on 5.0.24. -- Chris Wagner CBTS GE Aircraft Engines [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: taking MySQL down into admin mode

Thanks for that but I was hoping there was a way to do it live that didn't require restarting/reloading. Something to do at the mysql prompt. We had to repair a table and all the backed up connections were threatening to take down the daemon. Mikhail Berman wrote: Hi Chris, In my.cnf

Re: query to find duplicate rows

Philip Hallstrom wrote: Hi all, a though query problem for me... I have a table with 2 rows that matter: url and id If url and id are the same in 2 rows, then that's no good (bad data). I need to find all the rows that are duplicates. I can't think of how to approach the sql for this.. any

Re: anyone using subversion to sync mysql dbs ?

Graham Anderson wrote: Is anyone using subversion to sync live and development databases? If so, how? Is this desired or a best practice? Everything except my databases are under version control. In theory, I would like my databases to sync with the same subversion 'svn update' command. That

Re: dose mysqldump --single-transaction lock table?

Leo wrote: Hi,all.I want to use mysqldump to backup a innodb table,and add the option --single-transaction,dose it lock all the table?thanks. It has to so it can give you one transaction and make sure nothing else gets entered after it starts and before it finishes. -- MySQL General Mailing

Re: anyone using subversion to sync mysql dbs ?

No, I don't generally go along with underhand political activity. :-) (but I expect that's an old joke - I haven't been MySQLing all that long, you see...) -- Cheers... Chris Highway 57 Web Development -- http://highway57.co.uk/ Any inaccuracies in this index may be explained by the fact

Re: query to find duplicate rows

Philip Hallstrom wrote: Philip Hallstrom wrote: Hi all, a though query problem for me... I have a table with 2 rows that matter: url and id If url and id are the same in 2 rows, then that's no good (bad data). I need to find all the rows that are duplicates. I can't think of how to approach

Re: myisam primary key with innodb primary key..

Lakshmi wrote: Hi, I want to know is there any difference between myisam primary index vs innodb primary index... One's for a myisam table one's for an innodb table. They are treated exactly the same - both are unique, both have indexes. -- MySQL General Mailing List For list archives:

Re: Moving database to another machine

Nico Sabbi wrote: Ratheesh K J wrote: Hlo all, I wanted to move around 50 GB of data on Machine A to Machine B. Both the machines are of same architecture ( LAMP ) Dumping and restoring takes a lot of time. Is there a faster method to accomplish the same? Is there a way to tar the whole

Re: Computing a column based on other columns

BY derived_column ; This works on a table I have. SELECT MIN(tone) as `min`, MAX(tone) as `max`, MIN(tone)/MAX(tone) as ratio FROM pltone p I put the back tick mark around min and max alias, I'm not sure you need it but it is always a good idea anyway. -- Chris W KE5GIX Gift Giving Made Easy Get

Re: does DISTINCT kill ORDER BY?

Markus Hoenicka wrote: Hi, is the following behaviour intended? Are my queries wrong? The output shows only the Extra field as the other fields are identical in all cases. EXPLAIN SELECT t_refdb.refdb_id FROM t_refdb WHERE t_refdb.refdb_id0 ORDER BY t_refdb.refdb_id; = Using where; Using

K12 Academics

Hello, My name is Chris Glavin. I emailed you because you are an educator. I run a website which is all about Education Disabilities. It is geared towards parents, students, teachers, district officials professionals. I ask that you take a few minutes out of your busy schedule to visit my

Re: problem with InnoDB

[EMAIL PROTECTED] wrote: Hi Dan, Thanks for yur response. Does it makes sense to create an index on a primary key ..as that is my smallest field ? A primary key already has an index. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:

INSERT into select ... ON DUPLICATE KEY??

-0002 ON DUPLICATE KEY UPDATE FAC_ID=FAC-0003 Now in my untrained mind, this should create 4 new, identical records with only the fac_id field changed. Where am I going wrong? Thanks. Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General

Re: Is there a way to load non-native Date type with LOAD DATA

] Chris Jones 14 Oneida Avenue Toronto, ON M5J 2E3. Tel. 416-203-7465 Fax. 416-946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Is there a way to load non-native Date type with LOAD DATA

is the first thing on the line, replace the first space on each line with a ^ and remove the second space. If the date is quoted, replace both spaces on each line with a quote. If the date is preceded by just a tab, replace both spaces on each line with a \t -- Chris W KE5GIX Gift Giving Made Easy

Re: mysql_upgrade script problems on MySQL 5.0.24

error: Found option without preceding group in config file: /u07/mysql/data/upgrade_defaults at line: 2 Fatal error in defaults handling. Program aborted This is your problem. What's in that file (/u07/mysql/data/upgrade_defaults) ? -- MySQL General Mailing List For list archives:

Re: help with insert +php

on this table that could be doing this? -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Table permissions - before the table is created?

privileges. Chris Jones, P.Eng. 14 Oneida Avenue Toronto, ON M5J2E3 Tel. 416 203-7465 Fax. 416 946-1005 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Table permissions - before the table is created?

Thanks for that. Will create the two tables ahead of time which won't affect the existing application. At 11:57 30/08/2006, [EMAIL PROTECTED] wrote: Chris Jones wrote: Can the mysql administrator grant permissions on a table in an existing database if that table doesn't exist yet

Group By question

[EMAIL PROTECTED] F [EMAIL PROTECTED] The query would return row A, D, B, and E, in that order. It would not return C or F -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http

Mysql 5.x Solaris 8 crashes?

stack trace info, but the debug version didn't generate anything. Has anyone else encountered such a problem with Solaris 8 and mysql 5.x? I dug around online and couldn't find any mention of such a problem. -chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Some non-transactional changed tables couldn't be rolled back

obed wrote: Hi all... i'm developing an aplication and i'm need to use begin, commit, rollback, but when i try to use rollback i get a warning | Warning | 1196 | Some non-transactional changed tables couldn't be rolled back | Transactions only work for table types that support them. MyISAM is

Re: MyISAM Performance for fixed row_format

Boyd Hemphill wrote: The documentation for 4.1 says that changing to a row_format of fixed will increase disk look up. I did this with several tables where a query was taking about 3 minutes. I expected (from the doc and past experience) for the query to run in about 1 to 1 ½ minutes.

Re: Connecting mySQL to ColdfusionMX7

Ruth wrote: All, I am having difficulties getting the Coldfusion Administrator to establish a database connection to a database called accounting that I created using the command line utility. Any help would be very appreciated This is the error that CF is throwing: Connection

Re: mysql-bin.00000X

Tanner Postert wrote: there are ton of these files in my mysql data directory on fedora core 5 they are about a GB a piece. it appears that they are snapshots or some kind of log file. what is creating these files? http://dev.mysql.com/doc/refman/5.1/en/binary-log.html -- MySQL General

Re: Conditional Insert

the previous value is. You probably should define a stored procedure and call that. Here is an example which seems to work: Why not use this INSERT INTO table VALUES(..) ON DUPLICATE KEY UPDATE X = $X, y=$y .. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give

Re: Zip Code Distance

to figure out the distance. Not sure where you get the data but someone here probably knows. You can find details on the calculations here... http://williams.best.vwh.net/avform.htm -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any

Re: SOS

李彦 wrote: Dear Sir: I have some problems with mysql 5.0 binary source in Linux(RedHat).I'm able to startup the mysql process. But when i type in :mysql -u root -h localhost -p, and then put the correct password, I can not enter the database. I took almost one week to

Re: Server-Crash - What to do?

PS: I already tried with myisamchk -r -o *.MY*, but then all datasets are gone and the table is empty. :-( man myisamchk I tried myisamchk already. But after running the above rescue attempt, the tables are empty. Then I hope you made backups You, do keep backups right? -- Chris

Re: Server-Crash - What to do?

back out of that... But otherwise, I'd say you're out of luck. -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Seperating Application server and Database server

also help. If you move it, you need to be sure to have enough network band width between the two machines. -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com

IP Address Function?

nicely at http://www.aboutmyip.com/AboutMyXApp/IP2Integer.jsp But how to do this as part of a query... *frown* Any help appreciated... Regards, Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: IP Address Function?

RTFM! Let that be a good lesson for me now :) INET_ATON() and INET_NTOA() Brilliant!!! Regards, Chris. - Original Message - From: Chris Knipe [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Saturday, August 26, 2006 9:03 PM Subject: IP Address Function? Hi, I need to make

Re: MERGE table problem

Eric Anderson wrote: I've got a master (Master) with a MERGE table of foo_t (comprising of bar_a, bar_b, bar_c) in database 'Igloo'. There are 5 slaves that replicate the Igloo table, but ignore the Igloo.foo_t table. This setup was working fine. If the Master server crashed or had a

Re: MySQL NOW() function producing 0000-00-00 00:00:00

, a couple of hours later, I had about 5 million records in a table. Not a single one of them experienced the above I'm pretty sure your -00-00 does not come from NOW() -- Chris -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http

Re: Testing Email

INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: Renato Golin [EMAIL PROTECTED] To: Nicholas Vettese [EMAIL PROTECTED] Cc: mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:31 PM Subject: Re: Testing Email Nicholas Vettese wrote: I have been having

Re: MySQL NOW() function producing 0000-00-00 00:00:00

Doh.. Wrong email ;) INSERT INTO a VALUES (NOW()) ? Regards, Chris. - Original Message - From: Renato Golin [EMAIL PROTECTED] To: Chris Knipe [EMAIL PROTECTED] Cc: [EMAIL PROTECTED]; mysql@lists.mysql.com Sent: Friday, August 25, 2006 4:30 PM Subject: Re: MySQL NOW() function

Re: Search Engine type search

Neil Tompkins wrote: Thanks for the info. I think that problem was the fact I only had a couple of records. When creating the FULLINDEX field, does anything else happen to the field, other than the fact you can search FULLINDEX. The reason I ask is because I have about 1600 text fields

Re: Return list where no data exists

Neil Tompkins wrote: Using this query seems to hang my computer and mySQL server reported the queries had been LOCKED. How many records are in each table? It could take a while, especially if you don't have indexes on the join fields. -- MySQL General Mailing List For list archives:

Re: Buffer size for innodb tables

Ratheesh K J wrote: Hello All, I wanted to know what is the best size for Innodb key cache. We are currently running MySQL 4.1.11 And we have set the buffer size to 1GB. innodb_buffer_pool_size = 1G The system has 4 GB RAM. 1) In such a case is the above setting ok? 2) All the tables are of

Re: Tuning MySQL

Jürgen Ladstätter wrote: hi all, i developed a programm which needs my external mysql database server. now i have to transfer a lot of data and i have todo a lot of select queues. how can i tune that, so that it would be faster? in my monitoring system i saw, that CPU load is 0, the only

Re: Query takes different times for execution...

On 8/23/06, Ratheesh K J [EMAIL PROTECTED] wrote: Hello all, I wanted to know why a select query takes ,say, 18 sec to execute the first time I execute it and then for every successive execution it takes, say, 10 sec. I have disabled Query Caching on the server. If its not Query Caching then

Re: replace delayed not working

On 8/23/06, matt_lists [EMAIL PROTECTED] wrote: Not sure if this is a bug we are updating a large table with replace delayed from our feeder systems, 1000 records at a time using limit's on the input data pull this works great when there's fast selects from the table, while the insert is

Re: backup locking tables on 5.0.24

On 8/23/06, matt_lists [EMAIL PROTECTED] wrote: We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the tables for selects the backup takes 3 hours, so the site is down the whole time I'm using this backup line mysqldump -d -f --quote-names --skip-add-locks database outfile

Re: replace delayed not working

matt_lists wrote: It's not a bug. I guess this is a myisam table? http://dev.mysql.com/doc/refman/5.1/en/table-locking.html Any time the table is changed with myisam, the whole table is locked. That's the way it works. Innodb doesn't do it this way but it might cause other issues for you.

Re: backup locking tables on 5.0.24

matt_lists wrote: chris smith wrote: On 8/23/06, matt_lists [EMAIL PROTECTED] wrote: We did not see this on 5.0.19, with 5.0.24 our backup jobs lock the tables for selects the backup takes 3 hours, so the site is down the whole time I'm using this backup line mysqldump -d -f --quote-names

Re: Best way to copy between two databases with the same tables but different number of rows

axis wrote: Hi, I'm trying to copy between two databases with the same tables, but the destination one has a different number of rows. I used SQLyog first to create the script with the necessary commands and it partially worked after applying it to the second table, but my problem is with

Re: dates in mysql

Visolve DB Team wrote: hi MySQL automatically converts a date or time type value to a number (numeric context) viceversa. When the server starts, it attempts to determine the time zone of the host machine and uses it to set the *system_time_zone* system variable. The value does not

Re: Search Engine type search

Jerry Schwartz wrote: Actually, by default a full text search ignores words that are three characters or less, not less than three characters. I found this out by searching on red. Ahh, oops :) Thanks! -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To

Re: Search Engine type search

Neil Tompkins wrote: OK, I appear to be getting somewhere with the FULL TEXT search. Does anyone have any good resources about producing search engine type results ? for example if some enters a search phrase like londn how would I suggest the word london ? I was listening to a podcast

Re: Backup Errors in MySQL Cluster (5.0.24)

Dilipkumar wrote: Hi, While taking backup in MySQL 5.0.24 for (ndbcluster tables) i am getting the following errors : mysqldump: Error 1296: Got error 241 'Invalid schema object version' from ndbcluster when dumping table `iib_candidate_tracking` at row: 0 When i checked out using ndberror :

What to index?

referencing the UserChecks tables (except for the GROUP BY and ORDER BY). I've added an index on the Attribute column (VARCHAR(32)) but the EXPLAIN still shows that it is not using the index Is the above optimised? What can be done here to improve things Thanks allot, Chris

Re: MySQL 4.0.27-client and MySQL-4.1.21 server

http://dev.mysql.com/doc/mysql/en/old-client.html Regards, Chris. - Original Message - From: Odhiambo Washington [EMAIL PROTECTED] To: mysql@lists.mysql.com Sent: Tuesday, August 22, 2006 7:38 PM Subject: MySQL 4.0.27-client and MySQL-4.1.21 server hi Why is it that I cannot

Re: Some questions on Storage engine

Ratheesh K J wrote: Hello all, I have a couple of questions on storage engine types wrt performance 1.. Will there be any performance degrade when we do joins with tables having different storage engines ? Depends on the type of queries I think. There could be something here

Re: What to index?

Chris Knipe wrote: Hi, I got 4 relatively big (for me at least) queries. At the moment, the data in the tables are merely test data, but once the system goes into production, I'm expecting millions of records in most of the tables. I'm trying very hard thus to optimise my queries

Re: Search Engine type search

Neil Tompkins wrote: I followed the instructions, but when doing a search I get no results returned. here is my table CREATE TABLE /*!32300 IF NOT EXISTS*/ MyTest ( id int(10) unsigned NOT NULL auto_increment, title varchar(200) , body text , PRIMARY KEY (id), INDEX title

dates in mysql

it back to UTC and so on manually.. I've looked through the manual a few times but can't find an answer either way :( Thanks, Chris. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

Re: Become mysql user

On Monday 21 August 2006 08:40 am, Karl Larsen wrote: I think I need to su - mysql and it askes for a password. What is that password? If you're root you don't need to enter a password. If you can't become root then the system admin has that information. Karl -- Chris White PHP

Audit trail

in MySQL to do this, or do I just need to write code to track any changes as they are entered? -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General

Re: Audit trail

Well MySQL will see all the changes coming from a single user (the user who the web site connects to the database as). You'll have to add your own routines to log that info to a table or something... Unless ofcourse, I'm missing something, which I doubt :) Regards, Chris. - Original

Re: Should Joins always be using an index? (where possible?)

On 8/20/06, Ow Mun Heng [EMAIL PROTECTED] wrote: I'm have a query like so select A, index_A from tableA join tableB on tableB.indexA = tableA.indexA select A, index_A from tableA join tableB on tableB.A = tableA.A whcih would be more efficient? using the where clause which uses the index or

Re: query question: most active user

BY UserID ORDER BY Count DESC LIMIT 5 -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql

Re: Should Joins always be using an index? (where possible?)

Ow Mun Heng wrote: On Sun, 2006-08-20 at 19:59 +1000, chris smith wrote: On 8/20/06, Ow Mun Heng [EMAIL PROTECTED] wrote: I'm have a query like so select A, index_A from tableA join tableB on tableB.indexA = tableA.indexA select A, index_A from tableA join tableB on tableB.A = tableA.A

Re: HELP needed for speeding up a query!

Nicholas Wyatt wrote: Hello to all! has anybody got any ideas how i can speed up the following query? it's so awfully slow (about 1 second). the test_item table is the main problem. currently, it has about 108.000 entries. is it normal that it takes so long? and if it isn't, how can i

Re: Query needed to convert varchar to int ....sorry previous posting was incomplete

VenuGopal Papasani wrote: Dear all, I have a table with the following structure. ield Type CollationNullKey Default Extra Privileges Comment --- -- -- ---

Re: HELP needed for speeding up a query!

[ always cc the list so others can share the fix or make appropriate comments ] Nicholas Wyatt wrote: hi chris, thanks for answering! however, i do already have indexes on those columns. all my tables use the myisam storage engine. what are the differences you mentioned between these engines

Re: Calculation distances

://williams.best.vwh.net/avform.htm -- Chris W KE5GIX Gift Giving Made Easy Get the gifts you want give the gifts they want One stop wish list for any gift, from anywhere, for any occasion! http://thewishzone.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe

Re: Calculation distances

Mike Blezien wrote: Chris, this is something very similar to what we are attempting to accomplish: http://www.papajohnsonline.com/restlocator/RestaurantLocator The math in the link I gave you will still work for the distance calculations, however if you want what that site does you will need

Re: help needed to mount data from /var/lib/mysql

On 8/19/06, balaraju mandala [EMAIL PROTECTED] wrote: Hi Everybody, I need small help from you. In my Linux box i have limitation of Size in partition. I have only 5 GB space for /var. MySQL is installed in this partition only. I want to give another path like /home, where i have 120GB of

Re: mysqladmin claims password in crontab !

Marc MENDEZ wrote: Hi, I work under Mandrake 10.1 First, I have a .my.cnf, which works quite well, since I can enter mysql without entering any password. Even mysqladmin works ! But, I have a batch process run by crontab as root, which tests if mysql is running (mysqladmin version --silent).

Re: Slow queries

Jon Molin wrote: Hi list I have 5 tables: words (word_id int auto_increment, word varbinary(40)) (has ~3.5M rows) with the keys: PRIMARY KEY (`word_id`),UNIQUE KEY `word_ind` (`word`) phrases (phrase_id int auto_increment, phrase varbinary(100)) (has ~11M rows) with the keys: PRIMARY KEY

Re: mysqladmin claims password in crontab !

Marc MENDEZ wrote: Hi, For mysqladmin, this parameter does not exist. I'll try anyway by forcing password and user on the command line. I'll check tomorrow. Sure it does. $ mysqladmin --help | grep extra --defaults-extra-file=# Read this file after the global files are read -- MySQL

Re: Slow queries

Unfortunately didn't that help, it leads to: ++-+---+---+--- | id | select_type | table | type | possible_keys | key | key_len | ref | rows| Extra | ++-+---+---+--- | 1

Re: 1 to many relationship

EXPLAIN is documented in the manual http://dev.mysql.com/doc/refman/4.1/en/explain.html. So it is, but it doesn't show me the decisions it makes. It shows me whether it will use an index or not, it won't show me how it puts the whole thing together. Compare to the postgres one:

<    1   2   3   4   5   6   7   8   9   10   >