parsed.org

Tips by tag: load

Loading Data From File by xinu on Dec 31, 2005 04:06 PM

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
Memory Hogs by xinu on Apr 21, 2008 11:28 AM

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
RSS