Cytat(ShadowD @ 29.03.2008, 13:03:37 )
Każda tabela musi mieć kolumnę kluczową...
Popraw na tka:
<?php
CREATE TABLE map(
wiersz int(11),
kol1 int(11),
kol2 int(11), [................],
kol996 int(11),
kol997 int(11),
kol998 int(11),
kol999 int(11),
kol1000 int(11)
?>
Powinno pomuc...
Ps O ile mi wiadomo to jest jakieś ograniczenie co do tworzenia kolumn w mysql i chyba wynosi ono coś koło 40...
KAZDA? Mi sie wydaje, ze nie musi byc primary_key'a, sorry ze taki dlugi nieuporzadkowany cytat, ale chce pokazac calosc bo chcialem sprawdzic czy rzeczywiscie musi byc kolumna kluczowa:
Kod
mysql> create table costam (jedno_cos char(20), drugie_cos char(20), trzecie_cos
char(10));
Query OK, 0 rows affected (0.06 sec)
mysql> show tables;
+----------------+
| Tables_in_test |
+----------------+
| costam |
+----------------+
1 row in set (0.00 sec)
mysql> select * from costam;
Empty set (0.00 sec)
mysql> insert into costam values (1, 2);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into costam values (cos, cos2);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> insert into costam values (cos);
ERROR 1136 (21S01): Column count doesn't match value count at row 1
mysql> show columns from costam
->;
+-------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| jedno_cos | char(20) | YES | | NULL | |
| drugie_cos | char(20) | YES | | NULL | |
| trzecie_cos | char(10) | YES | | NULL | |
+-------------+----------+------+-----+---------+-------+
3 rows in set (0.03 sec)
mysql> insert into costam values ('cos', 'cos2', 'cos3');
Query OK, 1 row affected (0.00 sec)
mysql> select * from costam;
+-----------+------------+-------------+
| jedno_cos | drugie_cos | trzecie_cos |
+-----------+------------+-------------+
| cos | cos2 | cos3 |
+-----------+------------+-------------+
1 row in set (0.00 sec)
mysql> describe costam;
+-------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+-------------+----------+------+-----+---------+-------+
| jedno_cos | char(20) | YES | | NULL | |
| drugie_cos | char(20) | YES | | NULL | |
| trzecie_cos | char(10) | YES | | NULL | |
+-------------+----------+------+-----+---------+-------+
3 rows in set (0.02 sec)
