To import a local CSV file into MySQL, use the syntax below : LOAD DATA LOW_PRIORITY LOCAL INFILE ‘/path/tofile.csv’ INTO TABLE database.table FIELDS TERMINATED BY ‘;’ OPTIONALLY ENCLOSED BY ‘”‘ ESCAPED BY ‘”‘ LINES TERMINATED BY ‘\n’ IGNORE 1 LINES (`field1`,`field2`,…)
To export a mysql results in CSV format, use the syntax below : SELECT field1, field2, … FROM table WHERE condition INTO OUTFILE ‘/tmp/toto.csv’ FIELDS TERMINATED BY ‘;’ ENCLOSED BY ‘”‘ LINES TERMINATED BY ‘\n’ ;
By default, in Cheyenne, the header size limit for a post request is 102’400. If you want to ajust this limit you can define the post-mem-limit parameter in the global context or in a specific webapp. For example, to double the initial limit in the httpd.cfg, : … default [ root-dir %./www/ default [%index.html %index.rsp]
Get rid of graphic boot on Linux with a few modifications in grub configuration :
Git log in colors.
Default mysql client behaviour is to show column names and grid when returning results but how to get rid of this decorations ?
Just in case you absolutely have to insert a date in MySQL that does’nt exist, eg 2014-02-30, you can run MySQL server in a special mode that authorizes such dates : mysqld –sql-mode=”ALLOW_INVALID_DATES” MySQL will only check that the month is in the range from 1 to 12 and the day is in the range
byzanz-record -c –duration=60 –x=80 –y=310 –width=800 –height=600 out.gif
A few days ago, I started to have a very disturbing “Not permitted” message when trying to mount a usb disk from Thunar. The only way I found was to pmount the disk : not as intuitive as just clicking the disk on Thunar. But after some googling, I found where was the real problem :
In Windows, create a certificate via Start > All Programs > Microsoft Office > Microsoft Office Tools > Digital Certificate for VBA Projects In Microsoft Outlook, open the VB editor and copy/paste the code below Replace your@email.here and save Click on Tools > Digital Signature Click on [Choose] and select your certificate Click OK, then