data can be transmitted through a string, which is indeed much more convenient to work with Ajax.Next let's take a look at the role of the PHP serialize function.
JSON parsing Example 4:
$arr = array
(
'Peter'=> array
(
'Country'=>'USA',
'Age'=>20
),
'Li Ming'=> array
(
'Country'=>'CHINA',
'Age'=>21
Turkey
The program has been caught
94.122.2.16157 -- 09:53:39 --/
1917
Turkey, USA
The program has been caught
94.54.37.54 -- 02:44:07 --/
1096
Turkey, USA
The program has been caught
95.14.1.97 -- 08:30:10 --/
167
Turkey, USA
95.15.248.177 -- 11:14:54 --/
1454
Turkey,
what to do. The above example indicates loading data.(2): * indicates to load all the data (Example 1). You can also specify the name of the data file (Example 2 ).(3): This will tell the table to which sqlldr is to be loaded. Complete Syntax: [insert | append | replace | truncate] into table dept insert-the default value is insert. The following dept table must be empty; append-append, the following dept table can not be blank; replace-is the first to delete and then insert; truncate-is the fi
.# Chkconfig sybase onIn this way, the connection file S85sybase in/etc/rc.3 and/etc/rc.5 will be started automatically when the system is started.
To enable automatic sybase Shutdown# Ln-sf/etc/init. d/sybase/etc/rc0.d/K25sybaseProcedure# Service sybase status# Service sybase start# Service sybase stop
Or execute Common Startup commands.# Unset LANG# Startserver-f/opt/sybase/ASE-15_0/install/RUN_PDCSS-f/opt/sybase/ASE-15_0/install/RUN_PDCSS_BSDisable the server# Isql-
') |+ ---------------------------------------------------- +| 1, 20080808222301 |+ ------------------------------------------------ + Mysql> select time_format ('22: 23: 01', '% H. % I. % s ');+ ------------------------------------- +| Time_format ('22: 23: 01', '% H. % I. % s') |+ ------------------------------------- +| 22.23.01 |+ ------------------------------------- +MySQL date and time conversion functions: date_format (date, format), time_format (time, format) can convert a date/time to a
/2008', '%m/%d/%Y'); -- 2008-08-09
select str_to_date('08/09/08' , '%m/%d/%y'); -- 2008-08-09
select str_to_date('08.09.2008', '%m.%d.%Y'); -- 2008-08-09
select str_to_date('08:09:30', '%h:%i:%s'); -- 08:09:30
select str_to_date('08.09.2008 08:09:30', '%m.%d.%Y %h:%i:%s'); -- 2008-08-09 08:09:30
We can see that the str_to_date (str, format) Conversion Function can convert disordered strings into date formats. In addition, it can be converted to time. For "format", see the MySQL manual.
4. MySQL
Turkey
The program has been caught
94.122.2.16157 -- 09:53:39 --/
1917
Turkey, USA
The program has been caught
94.54.37.54 -- 02:44:07 --/
1096
Turkey, USA
The program has been caught
95.14.1.97 -- 08:30:10 --/
167
Turkey, USA
95.15.248.177 -- 11:14:54 --/
1454
Turkey,
MySQL multi-table operations and batch processing methods (3) 3. add Records
We have already discussed how to add a record to repeat this record for ease of viewing:
Mysql> insert into mytable-> Values ('ABC', 'F', '1966-08-17', 'China', 'n ′);Query OK, 1 row affected (0.05 sec)
Check it out:
Mysql> select * from mytable;+ ---------- + ------ + ------------ + ----------- + -------- +| Name | sex | birth | birthaddr | single |+ ---------- + ------ + ------------ + ----------- + -------- +|
:
Li Ming: Benz
Through the simple example above, some complex data can be transmitted through a string, which is indeed much more convenient to work with Ajax.
Next let's take a look at the role of the PHP serialize function.Procedure 4:
$arr = array ( 'Peter'=> array ( 'Country'=>'USA', 'Age'=>20 ), 'Li Ming'=> array ( 'Country'=>'CHINA', 'Age'=>21
changes will affect you dynamically. * P1: ' Jack ', [' Hangzhou ', ' Guangzhou ']; __proto__:{__proto__:18,[' Shenzhen ', ' Shanghai ']} * p2: ' Mark '; __proto__:{__proto__:18,[' Shenzhen ', ' Shanghai ']} */person.prototype.lastname = ' Jin '; /* Rewrite the prototype and react dynamically to the instance. Just as your mother is trendy, the neighbors mention you say your mother is really a tide. * Note, here we rewrite the person's prototype, is to add a lastName att
key)
country)
Population
China
600
USA
100
Canada
100
UK
200
France
300
Japan
250
Germany
200
Mexico
50
India
250
The population of Asia and North America is counted based on the population data of this country. The following result is returned.
purpose: 1. arcGIS API for flex allows you to browse your ArcGIS. the map published in server.9.3, is a basic example. preparation: 1. in ArcGIS. server.9.3 publishes a map service named USA and starts the service. 2. Install flex builder3. 3. download the ArcGIS API for flex Library Development Kit arcgis_flex_api_1.0-beta and decompress it to the folder, address: http://resources.esri.com/arcgisserver/apis/flex/index.cfm after completio
key)
country)
Population
China
600
USA
100
Canada
100
UK
200
France
300
Japan
250
Germany
200
Mexico
50
India
250
The population of Asia and North America is counted based on the population data of this country. The following result is returned.
1, "International Pop"--Hank Art Center (Minneapolis City, Minnesota, USA)650) this.width=650; "Src=" http://www.souism.com/template/admin/editor41/attached/image/20150722/20150722140344_ 56722.jpg "/>The museum exhibits a record of pop art from the early the 1950s to the the 1970s. Pop Art is also known as neo-realism, capital realism, surf Art, and Dada. The exhibition brings together 140 works from 14 countries, which were made by Roy Lichtenstein,
') |
+ ---------------- +
| Friday August 2008 |
+ ---------------- + Mysql> select date_format ('2017-08-08 22:23:01 ',' % Y % m % d % H % I % S ');
+ ------------------ +
| Date_format ('2017-08-08 22:23:01 ',' % Y % m % d % H % I % S') |
+ ------------------ +
| 1, 20080808222301 |
+ ------------------ + Mysql> select time_format ('22: 23: 01', '% H. % I. % S ');
+ ------------- +
| Time_format ('22: 23: 01', '% H. % I. % S') |
+ ------------- +
| 22.23.01 |
+ ------------- +
MySQL date and t
time conversion functions: date_format (date, format), time_format (time, format) can convert a date/time to a variety of string formats. It is an inverse conversion of the str_to_date (str, format) function.
5. MySQL returns the country/region time format function: get_format ()
MySQL get_format () syntax:
Get_format (date | time | datetime, 'eur' | 'USA' | 'jis '| 'ISO' | 'internal'
All examples of MySQL get_format () usage:
Select get_format (date
articles published by employees, including the author's name, article title, and publication date.
1. view the contents of mytable in the first table.
mysql> select * from mytable; +----------+------+------------+-----------+ | name | sex | birth | birthaddr | +----------+------+------------+-----------+ | abccs | f | 1977-07-07 | china | | mary | f | 1978-12-12 | usa | | tom | m | 1970-09-02 | usa
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.