1set @old_concurrent_insert= @@global.concurrent_insert; 2set @@global.concurrent_insert= 0; 3drop table if exists t1; 4create table t1 ( 5`a&b` int, 6`a<b` int NOT NULL, 7`a>b` text 8); 9insert into t1 values (1, 2, 'a&b a<b a>b'); 10<?xml version="1.0"?> 11 12<resultset statement="select * from t1 13" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 14 <row> 15 <field name="a&b">1</field> 16 <field name="a<b">2</field> 17 <field name="a>b">a&b a<b a>b</field> 18 </row> 19</resultset> 20<?xml version="1.0"?> 21<mysqldump xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 22<database name="test"> 23 <table_structure name="t1"> 24 <field Field="a&b" Type="int(11)" Null="YES" Key="" Default="NULL" Extra="" Comment="" /> 25 <field Field="a<b" Type="int(11)" Null="NO" Key="" Extra="" Comment="" /> 26 <field Field="a>b" Type="text" Null="YES" Key="" Default="NULL" Extra="" Comment="" /> 27 </table_structure> 28 <table_data name="t1"> 29 <row> 30 <field name="a&b">1</field> 31 <field name="a<b">2</field> 32 <field name="a>b">a&b a<b a>b</field> 33 </row> 34 </table_data> 35</database> 36</mysqldump> 37<?xml version="1.0"?> 38 39<resultset statement="select count(*) from t1 40" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 41 <row> 42 <field name="count(*)">1</field> 43 </row> 44</resultset> 45<?xml version="1.0"?> 46 47<resultset statement="select 1 < 2 from dual 48" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 49 <row> 50 <field name="1 < 2">1</field> 51 </row> 52</resultset> 53<?xml version="1.0"?> 54 55<resultset statement="select 1 > 2 from dual 56" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 57 <row> 58 <field name="1 > 2">0</field> 59 </row> 60</resultset> 61<?xml version="1.0"?> 62 63<resultset statement="select 1 & 3 from dual 64" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 65 <row> 66 <field name="1 & 3">1</field> 67 </row> 68</resultset> 69<?xml version="1.0"?> 70 71<resultset statement="select null from dual 72" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"> 73 <row> 74 <field name="NULL" xsi:nil="true" /> 75 </row> 76</resultset> 77<?xml version="1.0"?> 78 79<resultset statement="select 1 limit 0 80" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset> 81-------------- 82select 1 limit 0 83-------------- 84 85<?xml version="1.0"?> 86 87<resultset statement="select 1 limit 0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"></resultset> 88Empty set 89 90Bye 91drop table t1; 92set @@global.concurrent_insert= @old_concurrent_insert; 93