Monday, 31 December 2012
Sunday, 30 December 2012
Friday, 28 December 2012
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, 20 December 2012
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
Thursday, 6 December 2012
Subscribe to:
Comments (Atom)

