Pg_size_pretty (pg_relation_size (' Geodata_json ':: Regclass)) as JSON,
Pg_size_pretty (pg_relation_size (' geodata_jsonb ':: Regclass)) as JSONB;
JSON | jsonb
---------+---------
3274 MB | 3816 MB
(1 row)
Indexing the JSON data starts with the 9.3 version, such as using an operator (note that '->> ' is adopted because it returns text, and the index uses different keywords depending on the query)
=# CREATE INDEX Geodata_index on Geodata_json ((data->> ' Country_code '), (da
multiple discontinuous periods]
1.25 8-11 * * * * * ls//25 minutes per day at 8-11 o ' time execute ls command [note: "-" used to connect consecutive periods]
1.*/15 * * * ls///////////////////////////////15 min.
1.30 6 */10 * * ls///every month, every 10 days 6:30 execute the LS command [that is 1, 11, 21, 31st of every month, yes 6:30 executes the LS command once. ] Executes every executable file in the/etc/cron.daily directory as root 7:50 daily
1.50 7 * * * * root run-parts/etc/cron.dai
*/15 * * * lsThat is, the No. 0 15 30 45 60 minutes per hour executes the LS command
9, every month, every 10 days 6:30 execute the LS command6 */10 * * lsThat is, 1, 11, 21, 31st of the month, yes 6:30 executes the LS command.
10. Execute all executable files in the/etc/cron.daily directory as root 7:50 every day7 * * * Root run-parts/etc/cron.dailyNote: The Run-parts parameter indicates that all executable files in the following directory are executed.
Second, the new scheduling taskThere are
of the $ symbol.1.var jp=$.noconflict ();JP (document). Ready (function () {JP ("button"). Click (function () {JP ("P"). Text ("JQuery is still running!") ");2.$.noconflict ();jquery (document). Ready (function () {jquery ("button"). Click (function () {jquery ("P"). Text ("jquery is still running!") ");Both of the ab
();
Notnull---and isnotnull equivalence;
The like---is equivalent to the "as" in SQL, such as Findbyusernamelike (String user);
The notlike---is equivalent to "not like" in SQL, such as Findbyusernamenotlike (String user);
The order-by---is equivalent to the "FINDBYUSERNAMEORDERBYSALARYASC" in SQL, such as the String user;
The not---is equivalent to "in SQL"! = ", such as Findbyusernamenot (String user);
In---is equivalent to ' in ' in SQL, such as Findbyusernamein (Collection
The
J all have only one. And J appears after Z,B> = 1 can ensure that J appears after Z.
import java.util.*;public class Main { public static boolean check(String s) { int p=0,q=0,zp,jp,a,b,c; p=s.indexOf("z"); q=s.lastIndexOf("z"); if(p!=q) return false; if(p==-1) return false; zp=p; p=s.indexOf("j"); q=s.lastIndexOf("j"); if(p!=q) return fa
Site Instance
The code is as follows
Copy Code
/* Convert internal character encoding to SJIS */$str = mb_convert_encoding ($str, "SJIS");/* Convert EUC-JP to UTF-7 */$str = mb_convert_encoding ($str, "UTF-7", "EUC-JP");/* Auto detect encoding from JIS, Eucjp-win, Sjis-win, then convert str to Ucs-2le */$str = mb_convert_encoding ($str, "Ucs-2le", "JIS, Eucjp-win, Sjis-w
Example of character encoding conversion function usage in PHP, php example
In this paper, the use of the character encoding conversion function in PHP is described and shared for everyone's reference. The implementation method is as follows:
In general, in the Web program, especially when it comes to the reading process of the database, the most annoying is the problem of character encoding, php4.0.6 the version above provides mb_convert_encoding can be easily converted code.
Specific as follo
corresponding task. The wq disk will exit.2. directly edit the/etc/crontab file, that is, vi/etc/crontab, and add the corresponding task.
View scheduled tasksCrontab-l // list all current scheduling tasksCrontab-l-u jp // list all scheduling tasks of user jp
Delete Task SchedulingCrontab-r // delete all task scheduling tasks
Redirection of task scheduling execution resultsExample 1: Execute the ls command
cultureinfo class (under the system. Globalization namespace) is used to control the region where the date is displayed.
The japanesecalendar class (under the namespace system. Globalization) indicates the Japanese calendar.
The following code converts dates:
1) 2006/09/26 to 18/09/26
Cultureinfo CI = new cultureinfo ("Ja-JP ");
Calendar Cal = new japanesecalendar ();
CI. datetimeformat. Calendar = Cal;
Datetime dt = datetime. parse ("2006/09/26 ");
failure.
Usage:
1. It is found that iconv will encounter an error when converting the character "-" To gb2312. If the ignore parameter is not available, all strings after this character cannot be saved. Either way, this
"-" Cannot be converted successfully, and cannot be output. In addition, mb_convert_encoding does not have this bug.
2. mb_convert_encoding can specify multiple input encodings, which are automatically identified based on the content, but the execution efficiency is much lower
corresponding task. The wq disk will exit.2. directly edit the/etc/crontab file, that is, vi/etc/crontab, and add the corresponding task.
3. View scheduling tasksCrontab-l // list all current scheduling tasksCrontab-l-u jp // list all scheduling tasks of user jp
4. delete task schedulingCrontab-r // delete all task scheduling tasks
V. Transition of task scheduling execution resultsExample 1: execute the ls
This article describes how to solve the problem of truncation characters during iconv function transcoding in PHP. the solution provided in this article is to use mb_convert_encoding instead of iconv, if you need iconv, refer to iconv conversion encoding. However, the iconv is not fully displayed during Chinese transcoding.
The code is as follows:
Iconv ("UTF-8", "GB2312 // IGNORE", $ data); with // IGNORE, IGNORE errors
Or use mb_convert_encoding ()
The code is as follows:
/* Con
France (France)
84,937
5
JP Morgan Corp.
JP Morgan Chase Et CO
United States (USA)
81,055
6
Mitsubishi UFJ Financial Group
Mitsubishi UFJ Financial Group
Japan (Japanese)
68,464
7
Icbc
ICBC
China (PRC)
59,166
8
Royal Bank of Scotland
Royal Bank of Scotland
United King
bug.2. mb_convert_encoding can specify multiple input encodings, which are automatically identified based on the content, but the execution efficiency is much lower than that of iconv. for example: $ str = mb_convert_encoding ($ str, "euc-jp ", "ascii, jis, euc-jp, sjis, utf-8"); the order of "ascii, jis, euc-jp, sjis, UTF-8" varies with the effect.3. generally,
Php code conversion function. Generally, iconv is used. the mb_convert_encoding function is used only when the encoding of the original encoding cannot be determined or The iconv cannot be normally displayed after conversion. Iconv function syntax: generally, iconv is used. the mb_convert_encoding function is used only when the encoding of the original encoding cannot be determined or cannot be properly displayed after iconv conversion.
Iconv function syntax:
echo iconv("ISO-8859-1", "UTF-8"
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.