Bonjour Quelle est l'erreur svp? Static analysis: 1 errors were found during analysis. Unrecognized alter operation. (near ";" at position 68) SQL query: Copy alter table a add id int(4) not null auto_increment after difficulty; MySQL said: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int(4) not null auto_increment after difficulty' at line 1

Bonjour Quelle est la structure de la table "a" que tu essaies de modifier ?

Il faut que tu fasses ALTER TABLE `a` ADD COLUMN `id` INT(4) NOT NULL AUTO_INCREMENT AFTER `difficulty`, ADD PRIMARY KEY (`id`);

Message d'erreur MySQL alter table.

Olive -

Bonjour

Quelle est l'erreur svp?

Static analysis:

1 errors were found during analysis.

Unrecognized alter operation. (near ";" at position 68)

SQL query: Copy

alter table a add id int(4) not null auto_increment after difficulty;

MySQL said: Documentation

#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'int(4) not null auto_increment after difficulty' at line 1

Afficher la suite

2 réponses

Réponse 1 / 2
jordane45 Modérateur
Il faut que tu fasses
```
ALTER TABLE `a`
	ADD COLUMN `id` INT(4) NOT NULL AUTO_INCREMENT AFTER `difficulty`,
	ADD PRIMARY KEY (`id`);
```
1
1. Olive
  
  Cool! Merci ????????
  
  0
Réponse 2 / 2
jordane45 Modérateur
Bonjour

Quelle est la structure de la table "a" que tu essaies de modifier ?
0
1. Olive
  
  CREATE TABLE `a` (
  
  `content` varchar(30) NOT NULL,
  `status` varchar(10) NOT NULL DEFAULT 'undefined ',
  `difficulty` varchar(10) NOT NULL DEFAULT 'Pour tous'
  ) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_general_ci;
  
  0
2. Olive
  
  Precision: j'ai effectué l'opération manuellement avec PhpMyAdmin et copié la requête générée. C'est cette requête qui donne un message d'erreur.
  
  0
3. jordane45 Modérateur
  
  @Olive
  Tu avais bien mis en primary ??
  
  ADD PRIMARY KEY (`id`);
  
  0

Message d'erreur MySQL alter table.

2 réponses

Discussions similaires

Newsletters