Search
-
Categories
Tags
5.2 best php editor css debian error finger eleven google htaccess javascript javascript function life lifehouse linux love Lyrics mod_rewrite mysql mysql error mysql function nickelback nusphere nusphere phped nusphere phped 5.2 palawan palawan vacation paralyzer pdflib php4 pdflib php5 photoshop php phped php editor php error php function plugin regex regular expression regular expressions vacation vhcs video windows vista wordpress wordpress error wow
Category Archives: mysql
What is utf8
Share What Is UTF-8 And Why Is It Important? Unicode is a character set supported across many commonly used software applications and operating systems. For example, many popular web browser, e-mail, and word processing applications support Unicode. Operating systems that … Continue reading
INSERT SELECT
Share I was trying to duplicate a record and the best solution I can find is to do it like this. INSERT INTO table SELECT * FROM table WHERE {CONDITION} But this is not a good idea if you have … Continue reading
CONCAT_WS
ShareCONCAT_WS(separator,str1,str2,…) CONCAT_WS() stands for Concatenate With Separator and is a special form of CONCAT(). The first argument is the separator for the rest of the arguments. The separator is added between the strings to be concatenated. The separator can be … Continue reading
MYSQL: FIND_IN_SET AND IN()
ShareUsing IN() for comma delimited and my query is something like SELECT * FROM TABLE WHERE FLD IN(’33, 148′) TABLE (ID) (FLD) COMMA DELIMITED FIELD 1 42, 148 2 234, 25423,148 It wont be able to retrieve any records at … Continue reading
PLESK – how to create remote access on mysql
Sharecreate a user for any host or %. And you will be able to access mysql remotely.