Is there mysqlfiddle?

Question

I really loved jsfiddle and how easy it is to use.

Does anyone know something that works with mysql and possibly php mixed?

Answer 1

You might be interested in my site: http://sqlfiddle.com . I only recently created it, but it maintains a decent range of database types (including MySQL), and I got quite a lot of benefit from StackOverflow recently (see Mention of the sql wiki ). You can create indexes and views and do almost everything you would normally want to do in a database. Be sure to check out some sample scripts or see how other SO users use it:

MySQL - optimized -> http://sqlfiddle.com/#!2/1fde2/39

Multilevel users in the database table - > http://sqlfiddle.com/#!2/0de1f/7 p>

How to compare value with csv value in mysql? → http://sqlfiddle.com/#!2/b642c/4

I think I should mention that another potential useful feature for SO would be that each request displays an execution plan, so if several people have submitted answers to the sql question, you can easily evaluate their effectiveness and then increase / accept respectively.

Answer 2

Try SQLize .

It has some annoying limitations, such as an inability to create presentations, but overall I find it very useful. (Tip: CREATE INDEX doesn't work either, but you can still create indexes inside CREATE TABLE .)