Laut Kurs soll ich ja mal die SQL-BEFEHLE Eingeben mit 400 testadressen.
Gut mache ich...dannFehler
PHP
<span class="syntaxdefault">SQL</span><span class="syntaxkeyword">-</span><span class="syntaxdefault">Befehl</span><span class="syntaxkeyword">:<br /><br /></span><span class="syntaxdefault">CREATE TABLE testadressen</span><span class="syntaxkeyword">(<br /></span><span class="syntaxdefault">id mediumint</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 8 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> unsigned NOT NULL AUTO_INCREMENT </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">nachname varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 255 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">vorname varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 255 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">anrede varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 255 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">land varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 50 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">geburtsdatum varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 50 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">motto TEXT default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">lieblingsfarbe varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 255 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">familienstand varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 255 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">gehalt varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 50 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">abteilung varchar</span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> 50 </span><span class="syntaxkeyword">)</span><span class="syntaxdefault"> default NULL </span><span class="syntaxkeyword">,<br /></span><span class="syntaxdefault">PRIMARY KEY </span><span class="syntaxkeyword">(</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">`</span><span class="syntaxdefault">id</span><span class="syntaxkeyword">`</span><span class="syntaxdefault"> </span><span class="syntaxkeyword">)<br />)</span><span class="syntaxdefault"> TYPE </span><span class="syntaxkeyword">=</span><span class="syntaxdefault"> MYISAM AUTO_INCREMENT </span><span class="syntaxkeyword">=</span><span class="syntaxdefault">1</span><span class="syntaxkeyword">;<br /><br /></span><span class="syntaxdefault">MySQL meldet</span><span class="syntaxkeyword">:</span><span class="syntaxdefault"> Dokumentation<br /></span><span class="syntaxcomment">#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 'TYPE=MyISAM AUTO_INCREMENT=1' at line 14 </span><span class="syntaxdefault"></span>
was nun?
MfG drPHIP132