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
vielleicht solltest du erstmal den relevanten teil der abfrage, bzw den kompletten replace posten, damit man sehen kann, was da schief läuft...
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),
auch das letzte zeichen (ein komma) gehört da nicht hin, wenn's denn das ende ist...
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! |
> 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...
Wie lösche ich alle Tabellen einer Datenbank ohne die Datenbank selbst zu löschen per SQL-Befehl?
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
Mit Google-Account einloggen
Noch kein Account? Hier anmelden.