1

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.

Improve this question

1 Answer 1

Reset to default
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
Improve this answer
Sign up to request clarification or add additional context in comments.

1 Comment

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 !

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.