Queries? Forms?

[fredws]

OK, forgive me if these are stupid questions.

First off, I don't see where to create a query. I see where you can run a query, but of course there is nothing in the list, because I have not figured out where to create them.

Second, is there any way to create forms? Such as for data entry? I would like to have a form to fill in information from different tables at the same time. I come from a MS Access background, and would like to have some kind of form in MySQL.

TIA!

[CalEvans]

Quote:

OK, forgive me if these are stupid questions.

Ok but only if you promise not to take my message the wrong way. 🙂

1: If by create you mean a WYSIWYG query builder then no, there is no way to have the system create the queries for you. This tool is primarily for people who write SQL and need a tool to execute it. there are other tools available (some free, some even good) that will help you do this. My sincere hope is that SQLyog does not become one of those. (Because I write SQL for a living and it's great to have a tool minus these features.) You 'create' the query in SQLyog by hand coding it in the query window. (Then you execute it)

If all else fails, install the mysql ODBC drivers, connect to your server in ACCESS and use it's query builder. (Or do what I did low these many years ago and purchase a copy of SQL for Dummies. GREAT book!)

2: Again, no. SQLyog is a SQL query tool. It has some great features like being able to generate the DML to sync 2 database structures, generate a rudimentary insert statement for a table (saves me a LOT of typing!) and the best user management system I've seen for mySQL. (mySQL's paradigm for user permissions is a bit goofy to begin with) It is not comparable to ACCESS, it is more comparable to the old iSQL that used to come with M$SQL. (Now known as Query Builder but as with everything they have added so much crap to it that it has become bloated and slow.)

Check http://www.freshmeat.net. There are some systems that will help you generate web forms from your tables. Some of them are mature enough to be used in developing real systems. (Some of them are still toys though, be careful which ones you use)

SQLyog is a great tool for doing exactly what it does. Managing a mySQL server and developing new databases and code. Personally, I hope the development team does not lose it's focus and start adding everything in the world to it. (This is nothing new, Ritesh has heard this rant from me before. (I have the great honor of being one of their beta testers and being an ancillary participant in developing this great tool)

Anyhow, it's probably not the answers that you wanted. 🙂

=C=

[Ritesh]

Hello

• Visual Query Builder will be implemented in SQLyog Max
• We dont have any plans to give facility for forms

Quote:

Personally, I hope the development team does not lose it's focus and start adding everything in the world to it.

Dont worry !!! SQLyog will never become a bloatware and will always have the features that makes SQLyog such a great tool 😀

HTH

[Ritesh]

Hello

We do have plans to support Forms with simple scripting in one of the future releases of SQLyog

HTH

[Author]

Posts