Форум MySQL

Liudi dobrie pomogite pojaluista
vzeal fail php:

<?php

include "../include/config.php";

$query="CREATE TABLE categories (
id_categoria INT(11) NOT NULL AUTO_INCREMENT,
name TINYTEXT NOT NULL)";
if(mysql_query($query)) echo "Table created";
else exit(mysql_error());
$query="CREATE TABLE products (
id_product INT(11) NOT NULL,
name TINYTEXT NOT NULL,
rate FLOAT(4,1) NOT NULL default '0.0',
description TEXT NULL,
id_categoria INT(11) NOT NULL)";
if(mysql_query($query)) echo "Table created";
else exit(mysql_error());
?>

i pri ego ispolnenii okno pishet: Incorrect table definition; there can be only one auto column and it must be defined as a key
v ceom tut error?

Измените первый запрос на:

$query="CREATE TABLE categories ( id_categoria INT(11) NOT NULL AUTO_INCREMENT DEFAULT NULL, name TINYTEXT NOT NULL, PRIMARY KEY(`id_categoria`))";

spasibo! =)