<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2900.2963" name=GENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=#ffffff>
<DIV><FONT face=Arial size=2>salve alla lista</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>ho un problemino come da topic, praticamente ho una
macchina di sviluppo con mysql 5.0.22 e una di produzione con mysql 4.0.26, ora
quando devo spostare un db mi trovo di fronte a questo problema, le istruzioni
di create table non mi impostano gli autoincrement sui campi sia con
phpmyadmin che con mysqldump --compatible=MYSQL40, esempio:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>esportazione di una tabella con
phpmyadmin:</FONT></DIV>
<DIV><FONT face=Arial size=2>CREATE TABLE `t` (<BR> `id` int(11) NOT
NULL,<BR> PRIMARY KEY (`id`)<BR>) TYPE=MyISAM AUTO_INCREMENT=1
;</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>esportazione di una tabella con mysqldump
--compatible=MYSQL40:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>CREATE TABLE `t` (<BR> `id` int(11) NOT
NULL,<BR> PRIMARY KEY (`id`)<BR>) TYPE=MyISAM;<BR></FONT></DIV>
<DIV><FONT face=Arial size=2>invece dovrebbe essere cosė:</FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><SPAN class=syntax><SPAN
class="syntax_alpha syntax_alpha_reservedWord">CREATE</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">TABLE</SPAN> <SPAN
class="syntax_quote syntax_quote_backtick">`t`</SPAN> <SPAN
class="syntax_punct syntax_punct_bracket_open_round">(</SPAN></DIV>
<DIV class=syntax_indent1><SPAN
class="syntax_white syntax_white_newline"></SPAN><SPAN
class="syntax_quote syntax_quote_backtick">`id`</SPAN> <SPAN
class="syntax_alpha syntax_alpha_columnType">INT</SPAN><SPAN
class="syntax_punct syntax_punct_bracket_open_round">(</SPAN> <SPAN
class="syntax_digit syntax_digit_integer">11</SPAN> <SPAN
class="syntax_punct syntax_punct_bracket_close_round">)</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">NOT</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">NULL</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">AUTO_INCREMENT</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">PRIMARY</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">KEY</SPAN> <SPAN
class="syntax_white syntax_white_newline"></SPAN></DIV>
<DIV><SPAN class="syntax_punct syntax_punct_bracket_close_round">)</SPAN><SPAN
class="syntax_white syntax_white_newline"></SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">ENGINE</SPAN> <SPAN
class=syntax_punct>=</SPAN> <SPAN
class="syntax_alpha syntax_alpha_reservedWord">MYISAM</SPAN> <SPAN
class="syntax_punct syntax_punct_queryend">;</SPAN></DIV>
<DIV><SPAN class="syntax_punct syntax_punct_queryend"></SPAN> </DIV>
<DIV><SPAN class="syntax_punct syntax_punct_queryend"><FONT face=Arial
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class="syntax_punct syntax_punct_queryend"><FONT face=Arial
size=2>avete idee su come risolvere?</FONT></SPAN></DIV>
<DIV><SPAN class="syntax_punct syntax_punct_queryend"></SPAN></SPAN></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV>
<DIV><FONT face=Arial size=2>------------------------------------<BR>Tinazzi
Matteo<BR>X-Elefant Software s.r.l.<BR>Via Treviso 61/13 31057 Silea
(Treviso)<BR>ICQ#
71-883-066<BR>------------------------------------</FONT></DIV></BODY></HTML>