#1652 Auto Completion for SQL statements

[Minhaz]

I was using PMA writing long JOIN statements when I realised it'd be really cool to have autocompletion in PMA where ever I write SQL statements. Initial goal should be to implement auto completion for standard keywords, but then later also based on selected database -> {i.e take into account the tables, and their structures present in the database} to provide better suggestion for auto completion. It'd be really helpful in case of huge JOIN statements...

I'm willing to write this, if you like the idea... I already miss contributing to PMA :)

[Minhaz]

Wow awesome! You can close this ticket :)

---

Kind Regards,
Minhaz | My Projects http://cistoner.org/projects | M
http://cistoner.org/minhaz/y blog http://cistoner.org/minhaz/

On Thu, Apr 9, 2015 at 2:40 PM, Madhura Jayaratne madhuracj@users.sf.net
wrote:

• status: open --> pending
• Comment:

I believe we already have this. Try at
http://demo.phpmyadmin.net/master/db_sql.php?db=sakila

---

• [feature-requests:#1652]
  http://sourceforge.net/p/phpmyadmin/feature-requests/1652 Auto Completion
  for SQL statements*

Status: pending

Group: Needs_decision
Labels: auto completion sql queries
Created: Wed Apr 08, 2015 04:31 PM UTC by Minhaz
Last Updated: Wed Apr 08, 2015 04:31 PM UTC
Owner: nobody

I was using PMA writing long JOIN statements when I realised it'd be
really cool to have autocompletion in PMA where ever I write SQL
statements. Initial goal should be to implement auto completion for
standard keywords, but then later also based on selected database -> {i.e
take into account the tables, and their structures present in the database}
to provide better suggestion for auto completion. It'd be really helpful in
case of huge JOIN statements...

I'm willing to write this, if you like the idea... I already miss
contributing to PMA :)

---

Sent from sourceforge.net because you indicated interest in
https://sourceforge.net/p/phpmyadmin/feature-requests/1652/

To unsubscribe from further messages, please visit
https://sourceforge.net/auth/subscriptions/

[Madhura Jayaratne]

I believe we already have this. Try at http://demo.phpmyadmin.net/master/db_sql.php?db=sakila