Tuesday, 25 December 2012

Subtract and Concatinate date and time from a table and get the date and update in table


UPDATE lock_TKT
SET  TOTAL_TIME=To_Days(CONCAT(`fix_date`,' ',`fix_time`))-To_Days(CONCAT(`Tran_date`,' ',`lock_time`))
where ticket_no in ( select ticket from excelupload)

How to upload CSV file using Toad for MySql


-- Conditionally drop the table.
DROP TABLE IF EXISTS excelupload;

-- Create the new upload target table.
CREATE TABLE excelupload
( ticket   int(20)
, remarks varchar(500) ) ENGINE=MEMORY;

-- Load the data from a file, don't forget the \n after the \r on Windows or it won't work.
LOAD DATA INFILE 'f:/tickettoclose.csv'
INTO TABLE excelupload
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
ESCAPED BY '\\'
LINES TERMINATED BY '\r\n';

-- Select the uploaded records.
SELECT * FROM excelupload;

Thursday, 13 December 2012

How to set the program at windows start

create a shortcut to the program you want to run then put the short cut in your start> all programs> start up with msconfig you can disable programs that have start up keys in the registry in the start up section