1DBIx::SearchBuilder::HaUnsdelre:C:omnytsrqilb(u3t)ed PerDlBIDxo:c:uSmeeanrtcahtBiuoinlder::Handle::mysql(3)
2
3
4
6 DBIx::SearchBuilder::Handle::mysql - A mysql specific Handle object
7
10 This module provides a subclass of DBIx::SearchBuilder::Handle that
11 compensates for some of the idiosyncrasies of MySQL.
12
14 Insert
15 Takes a table name as the first argument and assumes that the rest of
16 the arguments are an array of key-value pairs to be inserted.
17
18 If the insert succeeds, returns the id of the insert, otherwise,
19 returns a Class::ReturnValue object with the error reported.
20
21 SimpleUpdateFromSelect
22 Customization of "SimpleUpdateFromSelect" in
23 DBIx::SearchBuilder::Handle. Mysql doesn't support update with
24 subqueries when those fetch data from the table that is updated.
25
26 DatabaseVersion
27 Returns the mysql version, trimming off any -foo identifier
28
29 CaseSensitive
30 Returns undef, since mysql's searches are not case sensitive by default
31
32 SimpleDateTimeFunctions
33 Returns hash reference with specific date time functions of this
34 database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
35
36 ConvertTimezoneFunction
37 Custom implementation of "ConvertTimezoneFunction" in
38 DBIx::SearchBuilder::Handle.
39
40 Use the following query to get list of timezones:
41
42 SELECT Name FROM mysql.time_zone_name;
43
44 Read docs about keeping timezone data up to date:
45
46 http://dev.mysql.com/doc/refman/5.5/en/time-zone-upgrades.html
47
49 Jesse Vincent, jesse@fsck.com
50
52 DBIx::SearchBuilder, DBIx::SearchBuilder::Handle
53
54
55
56perl v5.28.1 2016-07-D1B1Ix::SearchBuilder::Handle::mysql(3)