String data types
STRING
VARCHAR
CHAR
VARCHAR
CHAR
TINYINT
SMALLINT
INT
BIGINT
FLOAT
DOUBLE
DECIMAL
BOOLEAN
SMALLINT
INT
BIGINT
FLOAT
DOUBLE
DECIMAL
BOOLEAN
TIMESTAMP
DATE
DATE
Sometimes we may need to get records count from file . For that we can use wc -l , command with file name. In some situation the file will be in compressed format . wc -l will not directly work with zipped files . In this case we can do zcat the file and pipe the word count command with it. Example : Let say we have a file cricketData.dat.gz To get word count from the file use : zcat cricketData.dat.gz | wc -l This will give the record count.
ReplyDeleteGood day! I know this is somewhat off topic but I was wondering if you knew where I could find a captcha plugin for my comment form? I'm using the same blog platform as yours and I'm having trouble finding one? Thanks a lot! paypal mastercard login