RE: Reg SubQuery

Or.. Select * from emp order by id asc limit 0,1 if you want to fetch all details. -Original Message- From: Jason McKnight [mailto:[EMAIL PROTECTED] Sent: Wednesday, December 01, 2004 7:21 PM To: [EMAIL PROTECTED] Subject: Re: Reg SubQuery You could also do it like this: select

Changing Date Type

I know that defining a Data datatype in a table renders the date in the form that the database is set to, Ie. -mm-dd by default. I want this to remain, but for one particular table, I want to set it to d-mmm-yy Eg. 5-nov-04 or 15-nov-04 instead of 2004-11-05 like the rest of my tables. I do

RE: Changing Date Type

Yes, but I want to be able to insert into the column dates in the format d-mmm-yy -Original Message- From: Martijn Tonies [mailto:[EMAIL PROTECTED] Sent: Friday, November 05, 2004 8:38 PM To: Wadhwa, Amit; [EMAIL PROTECTED] Subject: Re: Changing Date Type I know that defining a Data

RE: Changing Date Type

Because im reading data from another source which is always going to be in this format, and then inserting into the database. Thought if there was a way I could escape having to change the format before I insert into mysql... Sorry abt the high importance, it was turned on by default in my editor.

Java.lang.outOfMemoryError on large ResultSet

MySQL 5.0 Alpha Jdbc Driver: Connector J OS: Windows 2000 Professional Table Size 1 Mil. Records. Table Structure: Table1 logid - autoincrement int(11) Timestamp - timestamp Timestamp2 - timestamp Tag - varchar(15) Query/Code: --- PreparedStatement pst = con.prepareStatement(Select

RE: Long Running Queries

You need Appropriate Indexes on the tables. -Original Message- From: Jason Williard [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 1:11 AM To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Long Running Queries Hello, I recently began experiencing issues that I would like

RE: Long Running Queries

appropriate indexes would mean indexes on columns specified in your where criteria. On this List, people mostly post table structures, as well as the queries they are firing, or else it really doesn't help. -Original Message- From: Danny Willis [mailto:[EMAIL PROTECTED] Sent: Thursday,

RE: show processlist state value 'statistics'

I have seen a similar option in PHPMyAdmin which says 'Enable Statistics' I suppose when the status shows statistics, mysql is just updating the statistics in there for the query just run? -Original Message- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004

RE: Speeding up index creation

Use Alter table Disable Keys, before loading the Data to your system, and then Alter table enable keys, This way you wont have to recreate your indexes -Original Message- From: Ananth Reddy [mailto:[EMAIL PROTECTED] Sent: Wednesday, October 06, 2004 10:08 PM To: [EMAIL PROTECTED]

RE: Long Running Queries

Do this and tell me if it helped ALTER TABLE `asticketsdata` ADD INDEX ( `ticketidchar` ) Regards, Amit -Original Message- From: Jason Williard [mailto:[EMAIL PROTECTED] Sent: Thursday, October 07, 2004 1:42 AM To: Wadhwa, Amit Cc: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re:

RE: how to add time to NOW() function

Use DATE_ADD(NOW(),INTERVAL 1 HOUR) Or DATE_ADD(NOW(),INTERVAL 60 MINUTE) Or DATE_ADD(NOW(),INTERVAL 3600 SECOND) -Original Message- From: Deepak Dhake [mailto:[EMAIL PROTECTED] Sent: Saturday, August 07, 2004 1:58 AM To: [EMAIL PROTECTED] Subject: how to add time to NOW() function

RE: Insert problems with InnoDB (big table)

Are you disabling autocommit before doing the inserts? And committing after all inserts are complete? -Original Message- From: Luc Charland [mailto:[EMAIL PROTECTED] Sent: Tuesday, August 03, 2004 7:54 PM To: [EMAIL PROTECTED] Subject: Insert problems with InnoDB (big table) We are

RE: slow query when searching database of over 2 million records

Use MySQL Query Caching -Original Message- From: Aasef Iqbal [mailto:[EMAIL PROTECTED] Sent: Monday, June 28, 2004 4:46 PM To: [EMAIL PROTECTED] Subject: slow query when searching database of over 2 million records Hi, I am working on a web project project where one of my pages has to

Speeding up Inserts

Hi All, Whats the fastest way to speed up inserts? I have a table which I insert into once a week (about 20-30k Rows) And select from all the time... Is the only way to speed up inserts to remove indexes? And to speed up selectes, ...add the indexes again? Regards, Amit -- MySQL General

RE: Speeding up Inserts

That fixed it, Thanks! -Original Message- From: Mirza [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 25, 2004 7:46 PM To: [EMAIL PROTECTED] Subject: Re: Speeding up Inserts Use: ALTER TABLE DISABLE KEYS ... inserts here ALTER TABLE ENABLE KEYS mirza [EMAIL PROTECTED] wrote: Hi

RE: Query question

Select count(distinct(field)) from table where field = 0 ? -Original Message- From: Laercio Xisto Braga Cavalcanti [mailto:[EMAIL PROTECTED] Sent: Monday, May 24, 2004 11:18 PM To: 'John Nichel'; 'MySQL List' Subject: RE: Query question You can do: Select count(distinct(field)) from

RE: Speeding up Inserts

I should have mentioned, I get data in a text file, Pipe Seperated, Double Quotes Qualifiers, Eg. col1|col2|col3 I tried Load Datafile, Didn't work for me, It skips an additional left most character from Col1, So I get 'ol1' instead of 'col1' ..so as of now, I am

Datetime format in MySQL

Hi All, Can you specify what format to use for the datetime column eg. in oracle you can say I wanna use DD-MMM- HH:MM:SS and so on? Regards, Amit -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL

Slow Query Question - Need help of Gurus.

Hi All, I have a huge Database which contains about 500,000 records, (will be adding about 20-25k records every week) I need to run group queries and output the same to a web interface. An example is: SELECT DISTINCT(`Call Svc Tag ID`),Count(`Call Svc Tag ID`) as counter, `Journal Create Date`

RE: export to csv or excel

Use phpmyadmin. Damn good for data dump in any format you wish... -Original Message- From: Bart De Man [mailto:[EMAIL PROTECTED] Sent: Thursday, April 15, 2004 6:59 AM To: [EMAIL PROTECTED] Subject: export to csv or excel Hi, Do you know a good tool to export mysql tables to csv or

RE: Reinstall Windows.

Backup the data folder under the mysql folder, that's it -Original Message- From: Alejandro C. Garrammone [mailto:[EMAIL PROTECTED] Sent: Monday, April 12, 2004 10:11 AM To: MySQL Mailing List Subject: Reinstall Windows. I need to re-install windows, so I need to re-install mysql.