Consider the following schema:
CREATE TABLE loadtest (
pkey int(11) NOT NULL auto_increment,
name varchar(20),
exam int,
score int,
time_enter timestamp(14),
PRIMARY KEY (pkey),
);
And the data you need to load:
'name22999990',2,94 'name22999991',3,93 'name22999992',0,91
Running this query would load the data into the columns name, exam, score:
mysql> LOAD DATA INFILE '/tmp/out.txt' INTO TABLE loadtest
-> FIELDS TERMINATED BY ',' (name,exam,score);
** Note: This tip borrowed from the Linux Gazette. You can read the complete article at http://www.linuxgazette.com/node/9059.
dataloadmysqlqueriesschemasql
To list all the high memory processes in cmd:
C:\Windows\System32>tasklist /fi "memusage gt 10000" Image Name PID Session Name Session# Mem Usage ========================= ====== ================ ======== ============ svchost.exe 1600 Console 0 30,296 K MsDtsSrvr.exe 964 Console 0 14,272 K Rtvscan.exe 920 Console 0 47,524 K searchindexer.exe 2364 Console 0 33,392 K explorer.exe 3220 Console 0 38,992 K vmware-tray.exe 2452 Console 0 20,068 K DSAgnt.exe 4252 Console 0 11,664 K Launchy.exe 4892 Console 0 17,704 K WindowsSearch.exe 5448 Console 0 11,800 K OUTLOOK.EXE 5004 Console 0 84,624 K pidgin.exe 5744 Console 0 24,308 K firefox.exe 4756 Console 0 122,652 K
cmddosloadmemoryprocessestasklist