0

Having previously used Microsoft's SQL Management Studio, I often used the query syntax check feature, pretty handy especially in a production environment.

  • Is there a similar feature in phpMyAdmin ?
  • If not, is there a way to validate the proper syntax of an SQL script without executing it ?

Any help or link to a related would be much appreciated.

Somnath Muluk
  • 55,015
  • 38
  • 216
  • 226
Pierre Roudaut
  • 1,013
  • 1
  • 18
  • 32

1 Answers1

2

Currently phpMyAdmin give some error icons (red crosses) when you type invalid queries.

enter image description here There are many tools available online, but below are the two which I used most of the times

  1. MySQL Syntax Check
  2. SQL Fiddle A tool for easy online testing and sharing of database problems and their solutions
Somnath Muluk
  • 55,015
  • 38
  • 216
  • 226
  • The phpMyAdmin i'm using is running on version 4.0.10.10 which does not come with this dynamic query checking (the lattest stable version to this day is 4.5). It seems i'll have to use online tools... Thanks for your help ! – Pierre Roudaut Dec 15 '15 at 10:53