J'ai un probleme lors de l'installation de pragmamx sur mon hebergeur (DREAMHOST) requête SQL:
-- phpMyAdmin SQL Dump
-- version 2.9.0.3
-- http://www.phpmyadmin.net
--
-- Serveur: localhost
-- G鮩r頬e : Mercredi 07 Mars 2007 ࠱9:35
-- Version du serveur: 5.0.27
-- Version de PHP: 5.2.0
--
-- Base de donn饳: `mysql`
--
-- --------------------------------------------------------
--
-- Structure de la table `columns_priv`
--
CREATE TABLE "columns_priv"(
"Host"char( 60 ) COLLATE utf8_bin NOT NULL default '',
"Db"char( 64 ) COLLATE utf8_bin NOT NULL default '',
"User"char( 16 ) COLLATE utf8_bin NOT NULL default '',
"Table_name"char( 64 ) COLLATE utf8_bin NOT NULL default '',
"Column_name"char( 64 ) COLLATE utf8_bin NOT NULL default '',
"Timestamp"timestamp NOT NULL default CURRENT_TIMESTAMP ,
"Column_priv"set( 'Select', 'Insert', 'Update', 'References' ) CHARACTER SET utf8 NOT NULL default '',
PRIMARY KEY ( "Host", "Db", "User", "Table_name", "Column_name" )
);
MySQL a répondu:
#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 '"columns_priv" (
"Host" char(60) collate utf8_bin NOT NULL default '',
"Db' at line 1
