Forum: PC-Programmierung Fehlersuche in SQL-Ausgabe


von MaiEsKuÄller (Gast)


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

von SQMinator (Gast)


Lesenswert?

vielleicht solltest du erstmal den relevanten teil der abfrage, bzw den 
kompletten replace posten, damit man sehen kann, was da schief läuft...

von MaiEsKuÄller (Gast)


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),

von Georg A. (georga)


Lesenswert?

... NULL)unit,
(434, ...

sieht etwas komisch aus...

von SQMinator (Gast)


Lesenswert?

auch das letzte zeichen (ein komma) gehört da nicht hin, wenn's denn das 
ende ist...

von DerKleineTyp (Gast)


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!

von Georg A. (georga)


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...

von MaiEsKuÄller (Gast)


Lesenswert?

Wie lösche ich alle Tabellen einer Datenbank ohne die Datenbank selbst 
zu löschen per SQL-Befehl?

von bluppdidupp (Gast)


Lesenswert?

google einfach mal nach "drop all tables", da wird er mit Sicherheit 
Lösungen für finden

Bitte melde dich an um einen Beitrag zu schreiben. Anmeldung ist kostenlos und dauert nur eine Minute.
Bestehender Account
Schon ein Account bei Google/GoogleMail? Keine Anmeldung erforderlich!
Mit Google-Account einloggen
Noch kein Account? Hier anmelden.