Заявка MySQL

[niksdevil]

Здравейте, задавам тази заявка

DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE piwik_log_profiling (
   query text NOT NULL,
   count int(10) unsigned,
   sum_time_ms float,
   KEY query (query)
);

А ми връща това

SQL заявка:

CREATE TABLE piwik_log_profiling(

query TEXT NOT NULL ,
count INT( 10 ) UNSIGNED,
sum_time_ms FLOAT,
KEY query( query )
);

MySQL отговори: 

#1170 - BLOB/TEXT column 'query' used in key specification without a key length

Как да го оправя ?

 

[tedo96]

Задай им някаква дъкжина в скоби.

 

[smileface]

[sql]DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE `piwik_log_profiling` (
`query` text(255) NOT NULL,
`count` int(10) unsigned,
`sum_time_ms` float,
KEY query (query)
);
[/sql]

 

[tedo96]

[sql]DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE `piwik_log_profiling` (
`query` text(255) NOT NULL,
`count` int(10) unsigned,
`sum_time_ms` float,
KEY query (query)
);


[/sql]

 

[niksdevil]

Ето пак отговора

CREATE TABLE  `piwik_log_profiling` (

 `query` TEXT( 255 ) NOT NULL ,
 `count` INT( 10 ) UNSIGNED,
 `sum_time_ms` FLOAT,
KEY query( query )
);

MySQL отговори: 

#1170 - BLOB/TEXT column 'query' used in key specification without a key length

 

[tedo96]

Така? :idea:
[sql]DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE `piwik_log_profiling` (
`query` text(255) NOT NULL,
`count` int(10) unsigned,
`sum_time_ms` float
);

[/sql]

 

[smileface]

[sql]DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE `piwik_log_profiling` (
`query` text(255) NOT NULL auto_increment,
`count` int(10) unsigned,
`sum_time_ms` float,
PRIMARY KEY (`query`)
);
[/sql]

или така

[sql]DROP TABLE IF EXISTS piwik_log_profiling;
CREATE TABLE `piwik_log_profiling` (
`query` text(255) NOT NULL ,
`count` int(10) unsigned,
`sum_time_ms` float,
PRIMARY KEY (`query`)
);
[/sql]

 

[dhtodorov]

[sql]
DROP TABLE IF EXISTS piwik_log_profiling;

CREATE TABLE `piwik_log_profiling` (
`query` text NOT NULL,
`count` int(10) unsigned,
`sum_time_ms` float
);

[/sql]

Няма как да сложиш auto_increment на text field