Fehlersuche in SQL-Ausgabe

Gast #3057274
Lesenswert?

Habe folgenden Fehler. Was ist die Ursache?

REPLACE `tl_style` (`id`, `pid`, `sorting`, `tstamp`, `invisible`, 
`selector`, `category`, `comment`, `size`, `width`, `height`, 
`minwidth`, `minheight`, `maxwidth`, `maxheight`, `positioning`, `trbl`, 
`position`, `floating`, `clear`, `overflow`, `display`, `alignment`, 
`margin`, `padding`, `align`, `verticalalign`, `textalign`, 
`background`, `bgcolor`, `bgimage`, `bgposition`, `bgrepeat`, 
`gradientAngle`, `gradientColors`, `shadowsize`, `shadowcolor`, 
`border`, `borderwidth`, `borderstyle`, `bordercolor`, `borderradius`, 
`bordercollapse`, `borderspacing`, `font`, `fontfamily`, `fontsize`, 
`fontcolor`, `lineheight`, `fontstyle`, `whitespace`, `texttransform`, 
`textindent`, `letterspacing`, `wordspacing`, `list`, `liststyletype`, 
`liststyleimage`, `own`) VALUES (418, 6, 8832, 1279097259, '', 
'.rss_items_only h2 a', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '1', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";[...]

MySQL meldet:
 #1064 - You have an error in your SQL syntax; check the manual that 
corresponds to your MySQL server version for the right syntax to use 
near 'unit,
 (434, 6, 10880, 1279097259, '', '.book .mod_sitemap', '', '', '1', 
'a:2:{' at line 17
Gast #3057325
Lesenswert?

REPLACE `tl_style` (`id`, `pid`, `sorting`, `tstamp`, `invisible`, 
`selector`, `category`, `comment`, `size`, `width`, `height`, 
`minwidth`, `minheight`, `maxwidth`, `maxheight`, `positioning`, `trbl`, 
`position`, `floating`, `clear`, `overflow`, `display`, `alignment`, 
`margin`, `padding`, `align`, `verticalalign`, `textalign`, 
`background`, `bgcolor`, `bgimage`, `bgposition`, `bgrepeat`, 
`gradientAngle`, `gradientColors`, `shadowsize`, `shadowcolor`, 
`border`, `borderwidth`, `borderstyle`, `bordercolor`, `borderradius`, 
`bordercollapse`, `borderspacing`, `font`, `fontfamily`, `fontsize`, 
`fontcolor`, `lineheight`, `fontstyle`, `whitespace`, `texttransform`, 
`textindent`, `letterspacing`, `wordspacing`, `list`, `liststyletype`, 
`liststyleimage`, `own`) VALUES
(418, 6, 8832, 1279097259, '', '.rss_items_only h2 a', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '1', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";}', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:2:"15";s:4:"unit";s:2:"px";}',  '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '1', '', 
'a:2:{s:5:"value";s:2:"14";s:4:"unit";s:2:"px";}', '', 
'a:2:{s:5:"value";s:2:"18";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', 'background:url(tl_files/simpag/img/rss_10.png) 
no-repeat left 1px;'),
(419, 6, 8960, 1279097259, '', '#footer .rss_items_only .description', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', 
'a:5:{s:3:"top";s:2:"10";s:5:"right";s:1:"0";s:6:"bottom";s:2:"10";s:4:" 
left";s:1:"0";s:4:"unit";s:2:"px";}', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";}',  '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '1', '', 
'a:2:{s:5:"value";s:2:"10";s:4:"unit";s:2:"px";}', 'eeeeee', 
'a:2:{s:5:"value";s:2:"14";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', NULL),
(420, 6, 9088, 1279097259, '', '.pdf_link', '', '.mod_glossaryMenu 
------------------------------------------------------------------------ 
------------------------------',  '1', 
'a:2:{s:5:"value";s:4:"auto";s:4:"unit";s:0:"";}', '', '', '', '', '', 
'', 'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', 'top:80px;'),
(421, 6, 9216, 1279097259, '', '.pdf_link a', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '1', '', 
'a:2:{s:5:"right";s:2:"20";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', NULL),
(422, 6, 9344, 1279097259, '', '.submit', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', 'cursor:pointer;'),
(423, 6, 9472, 1279097259, '', '#small_search', '', 'Eigene Bereiche und 
Elemente 
------------------------------------------------------------------------ 
------------------------------',  '1', '', '', '', '', '', '', '', 
'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', 'top:28px;'),
(424, 6, 9600, 1279097259, '', '#small_search input', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'1', 'eee', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', NULL),
(425, 6, 9728, 1279434949, '', '#header .mod_article', '', 'SEHR 
SPEZIELL CUSTOM', '1', 
'a:2:{s:4:"unit";s:1:"%";s:5:"value";s:3:"100";}', 
'a:2:{s:4:"unit";s:0:"";s:5:"value";s:0:"";}', '', '', '', '', '', 
'a:5:{s:6:"bottom";s:0:"";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top" 
;s:0:"";s:4:"unit";s:0:"";}',  'relative', '', 'both', '', '', '1', 
'a:5:{s:6:"bottom";s:1:"0";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top 
";s:0:"";s:4:"unit";s:2:"px";}', 
'a:5:{s:6:"bottom";s:0:"";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top" 
;s:0:"";s:4:"unit";s:0:"";}',  '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', 'min-height:260px;'),
(426, 6, 9856, 1279097259, '', '#header .mod_article .ce_text.first', 
'', '', '1', 'a:2:{s:5:"value";s:2:"40";s:4:"unit";s:1:"%";}', '', '', 
'', '', '', '', 'a:2:{s:3:"top";s:2:"40";s:4:"unit";s:2:"px";}', 
'absolute', '', '', '', '', '1', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";}', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";}',  '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', 'left:20px;\nborder:none;'),
(427, 6, 9984, 1279097259, '', '#header .mod_article .ce_text.first p', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '1', '', 'a:2:{s:5:"value";s:2:"36";s:4:"unit";s:2:"px";}', '', 
'', 'a:1:{i:0;s:6:"normal";}', '', '', '', '', '', '', '', '', 
'text-transform:lowercase;'),
(428, 6, 10112, 1279097259, '', '#header .mod_article .second', '', '', 
'1', '', '', '', '', '', '', '', 
'a:2:{s:4:"left";s:2:"20";s:4:"unit";s:2:"px";}', 'absolute', '', '', 
'', '', '1', 'a:2:{s:3:"top";s:1:"0";s:4:"unit";s:0:"";}', 
'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"le 
ft";s:1:"0";s:4:"unit";s:0:"";}',  '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', 'top:90px;'),
(429, 6, 10240, 1279097259, '', '#header .mod_article .second p', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '1', '', 'a:2:{s:5:"value";s:2:"18";s:4:"unit";s:2:"px";}', '', 
'a:2:{s:5:"value";s:2:"34";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', 'text-transform:lowercase;'),
(430, 6, 10368, 1279097259, '', '#header .mod_article .ce_image', '', 
'', '1', '', '', '', '', '', '', '', 
'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', 'bottom:0px;'),
(431, 6, 10496, 1279097259, '', '.book .back', '', '', '1', '', '', '', 
'', '', '', '', '', '', '', '', '', 'none', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', NULL),
(432, 6, 10624, 1279097259, '', '.book h1', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '1', 
'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', NULL),
(433, 6, 10752, 1279097259, '', '.book #main', '', '', '1', 
'a:2:{s:5:"value";s:3:"950";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', NULL)unit,
(434, 6, 10880, 1279097259, '', '.book .mod_sitemap', '', '', '1', 
'a:2:{s:5:"value";s:3:"300";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', 'right', '', '', '', '1', 
'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
'', '', '', '', '', '', '', '', '', '', '', NULL),
Gast #3057523
Lesenswert?

Servus,

Ich nehme nun mal an, das es bei MySQL erlaubt ist, den Tabellennamen 
und die Spaltenbezeichner in diese lokalisierten hochkomma zu schreiben. 
Abraten würde ich davon dennoch alle mal.

Wie meine vorredner schon sagen Passt das unit, und das letzte, 
irgendwie garnicht ins Bild.
Sollte das Statement danach noch weiter gehen muss das , da natürlich 
stehen.

REPLACE ist eine MySQL spezifische Erweiterung des SQL-Standards. Wenn 
du auf kompatibiltät Wert legst wäre ohnehin ein INSERT (mit vorherigem 
DELETE) oder ein UPDATE besser.
Aber das ist nur meine Meinung ;-)

Anbei noch die Abfrage in etwas schöner formatiert.
1
REPLACE `tl_style` 
2
(
3
    `id`, `pid`, `sorting`, `tstamp`, `invisible`, `selector`, `category`, 
4
    `comment`, `size`, `width`, `height`, `minwidth`, `minheight`, 
5
    `maxwidth`, `maxheight`, `positioning`, `trbl`, `position`, `floating`, 
6
    `clear`, `overflow`, `display`, `alignment`, `margin`, `padding`, 
7
    `align`, `verticalalign`, `textalign`, `background`, `bgcolor`, 
8
    `bgimage`, `bgposition`, `bgrepeat`, `gradientAngle`, `gradientColors`, 
9
    `shadowsize`, `shadowcolor`, `border`, `borderwidth`, `borderstyle`, 
10
    `bordercolor`, `borderradius`, `bordercollapse`, `borderspacing`, `font`
11
    , `fontfamily`, `fontsize`, `fontcolor`, `lineheight`, `fontstyle`, 
12
    `whitespace`, `texttransform`, `textindent`, `letterspacing`, 
13
    `wordspacing`, `list`, `liststyletype`, `liststyleimage`, `own` 
14
)
15
VALUES 
16
(
17
    418, 6, 8832, 1279097259, '', '.rss_items_only h2 a', '', '', '', '', ''
18
    , '', '', '', '', '', '', '', '', '', '', '', '1', 
19
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:1:"0";s:4:"unit";s:0:"";}', 
20
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:2:"15";s:4:"unit";s:2:"px";}',
21
        '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', 
22
    'a:2:{s:5:"value";s:2:"14";s:4:"unit";s:2:"px";}', '', 
23
    'a:2:{s:5:"value";s:2:"18";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
24
    '', '', '', '', 
25
    'background:url(tl_files/simpag/img/rss_10.png) no-repeat left 1px;'
26
), 
27
(
28
    419, 6, 8960, 1279097259, '', '#footer .rss_items_only .description', ''
29
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', 
30
    'a:5:{s:3:"top";s:2:"10";s:5:"right";s:1:"0";s:6:"bottom";s:2:"10";s:4:"left";s:1:"0";s:4:"unit";s:2:"px";}', 
31
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:1:"0";s:4:"unit";s:0:"";}', 
32
        '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', '', 
33
    'a:2:{s:5:"value";s:2:"10";s:4:"unit";s:2:"px";}', 'eeeeee', 
34
    'a:2:{s:5:"value";s:2:"14";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
35
    '', '', '', '', NULL 
36
), 
37
(
38
    420, 6, 9088, 1279097259, '', '.pdf_link', '', 
39
    '.mod_glossaryMenu ------------------------------------------------------------------------------------------------------', '1', 
40
    'a:2:{s:5:"value";s:4:"auto";s:4:"unit";s:0:"";}', '', '', '', '', '', 
41
    '', 'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', ''
42
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
43
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
44
    , '', '', 'top:80px;' 
45
), 
46
(
47
    421, 6, 9216, 1279097259, '', '.pdf_link a', '', '', '', '', '', '', '', 
48
    '', '', '', '', '', '', '', '', '', '1', '', 
49
    'a:2:{s:5:"right";s:2:"20";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
50
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
51
    '', '', '', '', '', '', '', '', '', '', NULL 
52
), 
53
(
54
    422, 6, 9344, 1279097259, '', '.submit', '', '', '', '', '', '', '', '', 
55
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
56
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
57
    '', '', '', '', '', '', '', '', 'cursor:pointer;' 
58
), 
59
(
60
    423, 6, 9472, 1279097259, '', '#small_search', '', 
61
    'Eigene Bereiche und Elemente ------------------------------------------------------------------------------------------------------', '1', '', '', '', '', '', '', '', 
62
    'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', '', ''
63
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
64
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
65
    , '', 'top:28px;' 
66
), 
67
(
68
    424, 6, 9600, 1279097259, '', '#small_search input', '', '', '', '', '', 
69
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '1', 
70
    'eee', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
71
    '', '', '', '', '', '', '', '', '', '', '', '', NULL 
72
), 
73
(
74
    425, 6, 9728, 1279434949, '', '#header .mod_article', '', 
75
    'SEHR SPEZIELL CUSTOM', '1', 'a:2:{s:4:"unit";s:1:"%";s:5:"value";s:3:"100";}', 
76
    'a:2:{s:4:"unit";s:0:"";s:5:"value";s:0:"";}', '', '', '', '', '', 
77
    'a:5:{s:6:"bottom";s:0:"";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top";s:0:"";s:4:"unit";s:0:"";}', 'relative', '', 'both', '', '', '1', 
78
    'a:5:{s:6:"bottom";s:1:"0";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top";s:0:"";s:4:"unit";s:2:"px";}', 
79
    'a:5:{s:6:"bottom";s:0:"";s:4:"left";s:0:"";s:5:"right";s:0:"";s:3:"top";s:0:"";s:4:"unit";s:0:"";}', '', '', '', '', '', '', '', '', '', '', '', '', ''
80
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
81
    , '', '', 'min-height:260px;' 
82
), 
83
(
84
    426, 6, 9856, 1279097259, '', '#header .mod_article .ce_text.first', '', 
85
    '', '1', 'a:2:{s:5:"value";s:2:"40";s:4:"unit";s:1:"%";}', '', '', '', 
86
    '', '', '', 'a:2:{s:3:"top";s:2:"40";s:4:"unit";s:2:"px";}', 'absolute', 
87
    '', '', '', '', '1', 
88
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:1:"0";s:4:"unit";s:0:"";}', 
89
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:1:"0";s:4:"unit";s:0:"";}', '', '', '', '', '', '', '', '', '', '', '', ''
90
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
91
    , '', '', '', 'left:20px;\nborder:none;' 
92
), 
93
(
94
    427, 6, 9984, 1279097259, '', '#header .mod_article .ce_text.first p', 
95
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
96
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
97
    '', '', '1', '', 'a:2:{s:5:"value";s:2:"36";s:4:"unit";s:2:"px";}', '', 
98
    '', 'a:1:{i:0;s:6:"normal";}', '', '', '', '', '', '', '', '', 
99
    'text-transform:lowercase;' 
100
), 
101
(
102
    428, 6, 10112, 1279097259, '', '#header .mod_article .second', '', '', 
103
    '1', '', '', '', '', '', '', '', 
104
    'a:2:{s:4:"left";s:2:"20";s:4:"unit";s:2:"px";}', 'absolute', '', '', ''
105
    , '', '1', 'a:2:{s:3:"top";s:1:"0";s:4:"unit";s:0:"";}', 
106
    'a:5:{s:3:"top";s:1:"0";s:5:"right";s:1:"0";s:6:"bottom";s:1:"0";s:4:"left";s:1:"0";s:4:"unit";s:0:"";}', '', '', '', '', '', '', '', '', '', '', '', ''
107
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
108
    , '', '', '', 'top:90px;' 
109
), 
110
(
111
    429, 6, 10240, 1279097259, '', '#header .mod_article .second p', '', '', 
112
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
113
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
114
    '1', '', 'a:2:{s:5:"value";s:2:"18";s:4:"unit";s:2:"px";}', '', 
115
    'a:2:{s:5:"value";s:2:"34";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
116
    '', '', '', '', 'text-transform:lowercase;' 
117
), 
118
(
119
    430, 6, 10368, 1279097259, '', '#header .mod_article .ce_image', '', '', 
120
    '1', '', '', '', '', '', '', '', 
121
    'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', 'absolute', '', '', ''
122
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
123
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
124
    , '', 'bottom:0px;' 
125
), 
126
(
127
    431, 6, 10496, 1279097259, '', '.book .back', '', '', '1', '', '', '', 
128
    '', '', '', '', '', '', '', '', '', 'none', '', '', '', '', '', '', '', 
129
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
130
    '', '', '', '', '', '', '', '', '', '', '', NULL 
131
), 
132
(
133
    432, 6, 10624, 1279097259, '', '.book h1', '', '', '', '', '', '', '', 
134
    '', '', '', '', '', '', '', '', '', '1', 
135
    'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', '', '', '', '', '', ''
136
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
137
    , '', '', '', '', '', '', '', '', '', '', NULL 
138
), 
139
(
140
    433, 6, 10752, 1279097259, '', '.book #main', '', '', '1', 
141
    'a:2:{s:5:"value";s:3:"950";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
142
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
143
    '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', 
144
    '', '', '', '', '', '', '', NULL 
145
) unit, --< Gehört hier nicht hin!
146
(
147
    434, 6, 10880, 1279097259, '', '.book .mod_sitemap', '', '', '1', 
148
    'a:2:{s:5:"value";s:3:"300";s:4:"unit";s:2:"px";}', '', '', '', '', '', 
149
    '', '', '', 'right', '', '', '', '1', 
150
    'a:2:{s:5:"right";s:1:"0";s:4:"unit";s:2:"px";}', '', '', '', '', '', ''
151
    , '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', '', ''
152
    , '', '', '', '', '', '', '', '', '', '', NULL 
153
), -- < nur erlaubt wenn es hiernach noch weiter geht!
#3057991
Lesenswert?

> Abraten würde ich davon dennoch alle mal.

Wenn man Spaltennamen hat, die mit Schlüsselwörtern identisch sind, 
gehts AFAIK nicht anders. Warum man das haben will, ist was anderes ;)

Und das mit der Kompatibilität ist eh so eine Sache. Selbst wenn man nix 
grossartiges braucht, muss man bei verschiedenen DBs oft rumfummeln. So 
spontan fallen mir zB. die andere Join-Syntax und das fehlende LIMIT bei 
Oracle ein...

Antwort schreiben

Bitte melde dich an, um einen Beitrag zu schreiben.

oder

Mit Google-Account einloggen

Die Registrierung ist kostenlos und dauert nur eine Minute.

Jetzt registrieren