Results 1 to 21 of 21

Thread: [RESOLVED] How to write and run ANY query in MySql?

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Resolved [RESOLVED] How to write and run ANY query in MySql?

    I am an experienced Sql programmer, but I gained all that experience using Microsoft Sql at work.
    Now that I need to do Sql programming at home for myself, obviously I cannot use Microsoft Sql because it is super expensive.
    So, I am going to do my personal Sql programming at home in MySql (which is free).
    I just installed MySql (Community edition), and the installation completed successfully.
    But I can't find a program (that I assume has been installed) that provides the environment for me (the developer) to write a query and run it.
    Where is the IDE?
    I am completely lost!
    I want to create a database and write queries, but, I don't know where to find the IDE.
    Please note that my whole system (hardware) is one and only one desktop computer (my home computer with Windows 8.1). I want to create a database on my home computer and write queries in it. So, my home computer will be both the server and the client.
    Can you please help?
    Thanks.

  2. #2
    Frenzied Member
    Join Date
    May 2014
    Location
    Central Europe
    Posts
    1,290

    Re: How to write and run ANY query in MySql?

    sorry i cant help on the topic of a MySQL Query Analyzer, but why don't you use MSSQL Express at home? its free and you are familiar with it.
    here is the 2012 version: http://www.microsoft.com/en-us/downl....aspx?id=29062

  3. #3
    Wall Poster TysonLPrice's Avatar
    Join Date
    Sep 2002
    Location
    Columbus, Ohio
    Posts
    3,471

    Re: How to write and run ANY query in MySql?

    I think there are free versions of Toad that will give you what you are looking for:

    http://www.toadworld.com/m/freeware/default.aspx
    Please remember next time...elections matter!

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Thank you for the great advice.
    I am going to experiment with both the suggestions that you provided.
    First off I am going to install Microsoft Sql Express.
    When I try to download and install MSSQL Express, it asks me to choose the things that I need to install on this page:
    http://www.microsoft.com/en-us/downl....aspx?id=29062
    And I don't know which ones to choose.
    I just need to create a database on my desktop home computer (Windows 8.1) and write queries and run those queries.
    That's all I need.
    So, what should I choose on that installation page?
    Please help.
    Thanks.

  5. #5
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    5,641

    Re: How to write and run ANY query in MySql?

    SQL Express Database engine and SQL express Management studio should be the minimum requirements.
    Slow as hell.

  6. #6
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,954

    Re: How to write and run ANY query in MySql?

    Quote Originally Posted by IliaPreston View Post
    I am an experienced Sql programmer, but I gained all that experience using Microsoft Sql at work.
    Now that I need to do Sql programming at home for myself, obviously I cannot use Microsoft Sql because it is super expensive.
    So, I am going to do my personal Sql programming at home in MySql (which is free).
    I just installed MySql (Community edition), and the installation completed successfully.
    But I can't find a program (that I assume has been installed) that provides the environment for me (the developer) to write a query and run it.
    Where is the IDE?
    I am completely lost!
    I want to create a database and write queries, but, I don't know where to find the IDE.
    Please note that my whole system (hardware) is one and only one desktop computer (my home computer with Windows 8.1). I want to create a database on my home computer and write queries in it. So, my home computer will be both the server and the client.
    Can you please help?
    Thanks.
    It's the MySQL WorkBench - https://www.mysql.com/products/workbench/

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  7. #7

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Thank you for the response.
    SQL Express Database engine and SQL express Management studio should be the minimum requirements.
    When I go to this page:
    http://www.microsoft.com/en-us/downl....aspx?id=29062
    There are 11 different installation files that I have numbered in this picture:
    http://i.imgur.com/bGHq0EQ.jpg
    When I click on the Download button, the same 11 files are there, so that I choose some of them before I proceed with installation:
    http://i.imgur.com/na7vKMi.jpg
    You are saying that I should choose SQL Express Database engine and SQL express Management studio.
    1. Which one of these 11 files is SQL Express Database engine
    2. And there are multiple SQL express Management studio files to choose from such as number 5 and number 11. Which one should I choose? Please note that My computer is 64 bit and it runs Windows 8.1 (64bit).
    3. And the last question is: Are you sure that I need to install the Management studio? As I said in the previous posts, (aside from the database engine) I only need a tool with which I could write queries and execute them. I also need to create a database first. Isn't Management Studio too much for that simple purpose?
    Please advise.
    Thanks.

  8. #8

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    It's the MySQL WorkBench - https://www.mysql.com/products/workbench/
    Thanks for the advice.
    When I go to this page that you linked: https://www.mysql.com/products/workbench/
    and click on the button "Download Now", it takes me to this page:
    http://dev.mysql.com/downloads/workbench/
    In there, the only installation instruction is on the bottom of the page, and it looks like this:
    http://i.imgur.com/FLnFlD1.jpg
    In the above picture you can clearly see that it says: MySQL Workbench 6.2.5
    But then underneath it, it clearly says: MySQL Installer 5.6 (All MySQL products).
    Correct me if I am wrong, but to me, it clearly means that it is not ONLY the Workbench. Rather, it is (as I understand) the whole MySQL (Including, but not limited to Workbench)!
    This is what I have already installed (four days ago).
    I am not sure what is it that I am missing. I am totally confused.
    I have already installed that (four days ago) by clicking on the first "Download" button (shown in the above picture).
    And it took me to this page:
    http://i.imgur.com/pspsoUA.jpg
    And then I followed the instructions and installed the whole thing.
    When I look at the installed programs in the control panel, I see these ones:
    http://i.imgur.com/t0lr3HS.jpg
    But, is any of them Workbench?
    If yes, which one?
    If no, why? and how do I install it?
    It looks very confusing.
    I am really confused.
    Please help.
    Thanks.

  9. #9
    Superbly Moderated NeedSomeAnswers's Avatar
    Join Date
    Jun 2002
    Location
    Manchester uk
    Posts
    2,623

    Re: How to write and run ANY query in MySql?

    Quote Originally Posted by IliaPreston View Post
    Thank you for the response.

    When I go to this page:
    http://www.microsoft.com/en-us/downl....aspx?id=29062
    There are 11 different installation files that I have numbered in this picture:
    http://i.imgur.com/bGHq0EQ.jpg
    When I click on the Download button, the same 11 files are there, so that I choose some of them before I proceed with installation:
    http://i.imgur.com/na7vKMi.jpg
    You are saying that I should choose SQL Express Database engine and SQL express Management studio.
    1. Which one of these 11 files is SQL Express Database engine
    2. And there are multiple SQL express Management studio files to choose from such as number 5 and number 11. Which one should I choose? Please note that My computer is 64 bit and it runs Windows 8.1 (64bit).
    3. And the last question is: Are you sure that I need to install the Management studio? As I said in the previous posts, (aside from the database engine) I only need a tool with which I could write queries and execute them. I also need to create a database first. Isn't Management Studio too much for that simple purpose?
    Please advise.
    Thanks.
    1 , Select Microsoft SQL Server 2012 Express

    2, When you download it should grab all those files, all you need to run is the .MSI file, which is the installer. This will then take you through the options of installing the various MS SQL Server components.

    3,It shouldn't matter whether you are 32bit or 64 bit, just run the installer.

    4, Yes you absolutely need to install the management studio otherwise you have no front end, no visual way of seeing and working on your database.

    The reason there are a bunch of files is that SQL Server has various components, like Analytic & Report services which are optional installs. You just need the main stuff which is the database engine, and the management studio so you can write queries, Stored Procedures and create Databases and the like.
    Please Mark your Thread "Resolved", if the query is solved & Rate those who have helped you



  10. #10
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,954

    Re: How to write and run ANY query in MySql?

    Quote Originally Posted by IliaPreston View Post
    Thanks for the advice.
    When I go to this page that you linked: https://www.mysql.com/products/workbench/
    and click on the button "Download Now", it takes me to this page:
    http://dev.mysql.com/downloads/workbench/
    In there, the only installation instruction is on the bottom of the page, and it looks like this:
    http://i.imgur.com/FLnFlD1.jpg
    In the above picture you can clearly see that it says: MySQL Workbench 6.2.5
    But then underneath it, it clearly says: MySQL Installer 5.6 (All MySQL products).
    Correct me if I am wrong, but to me, it clearly means that it is not ONLY the Workbench. Rather, it is (as I understand) the whole MySQL (Including, but not limited to Workbench)!
    This is what I have already installed (four days ago).
    I am not sure what is it that I am missing. I am totally confused.
    I have already installed that (four days ago) by clicking on the first "Download" button (shown in the above picture).
    And it took me to this page:
    http://i.imgur.com/pspsoUA.jpg
    And then I followed the instructions and installed the whole thing.
    When I look at the installed programs in the control panel, I see these ones:
    http://i.imgur.com/t0lr3HS.jpg
    But, is any of them Workbench?
    If yes, which one?
    If no, why? and how do I install it?
    It looks very confusing.
    I am really confused.
    Please help.
    Thanks.
    Back at the Workbench download page, if you look at the Other Downloads, the second one, x86, 64-bit, MSI Installer was just the workbench... you can tell by the name: mysql-workbench-community-6.2.5-win64.msi ... what's listed at the top is the recommended, and of course they're going to recommend the whole thing. Usually when people are downloading mySQL, they need the whole thing. But since you already had the engine, all you needed was the workbench.

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  11. #11

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Back at the Workbench download page, if you look at the Other Downloads, the second one, x86, 64-bit, MSI Installer was just the workbench... you can tell by the name: mysql-workbench-community-6.2.5-win64.msi
    Thanks a lot.
    I don't know how I missed it.
    I downloaded and started to install Workbench, when the installation wizard required me to install the prerequisites first. The prerequisites are Visual C++ redistributable package and also the .Net.
    I am reluctant to install these things. Especially most of all I am reluctant to install .Net.
    Is there any alternative to Workbench?
    Is there any other application that would install really easily and does not require dot Net platform and can provide the integrated development environment to help me do the following:
    1. Create a MySQL database.
    2. Write queries and run them against MySQL?
    Please advise.
    Thanks.

  12. #12
    PowerPoster techgnome's Avatar
    Join Date
    May 2002
    Posts
    32,954

    Re: How to write and run ANY query in MySql?

    You want advice? Install the prerequisites... are there alternatives? Sure, perhaps. What are they? Beats me. Did you try Toad?

    -tg
    * I don't respond to private (PM) requests for help. It's not conducive to the general learning of others.*
    * I also don't respond to friend requests. Save a few bits and don't bother. I'll just end up rejecting anyways.*
    * How to get EFFECTIVE help: The Hitchhiker's Guide to Getting Help at VBF - Removing eels from your hovercraft *
    * How to Use Parameters * Create Disconnected ADO Recordset Clones * Set your VB6 ActiveX Compatibility * Get rid of those pesky VB Line Numbers * I swear I saved my data, where'd it run off to??? *

  13. #13
    King of sapila
    Join Date
    Oct 2006
    Location
    Greece
    Posts
    5,641

    Re: How to write and run ANY query in MySql?

    What PC are you using?
    I think .NET is installed by default in newer Windows Versions. So you may have it installed.
    VC++ will also install if you want to play some games so you may have that installed also.
    Why do you afraid to install .NET? It's one of the few MS things that is relatively safe to install without messing up you computer. If you don't use it, it just sit there.
    Also what is the problem with installing MS SQL express (+SP1)? You have second thoughts?
    I can respect that since almost everything MS installs will bug out , one way or another (and I am also an MS hater but also an MS Developer (go figure)) but, in this extreme coincidence, .NET and MS SQL are from the safest bets. .NET because it is extensively tested by all us .NET developers and SQL Express(+SP1) because it is a database system and if MS screwed this up he would have gotten so may lawsuits that he could build all of it's employees (law) suits.
    Also lemmy(sic) take this opportunity since the OP is an MS skeptic to say that I hate W8 WServer2012 and MS MVC. I also hate All windows versions but W7 and XP and i also hate MS keyboards, speakers and other peripherals except the Classic optical MS Mouse that , strangely enough, it recently died on me after 8 years of usage.Replaced it with an 8 years exact spare and got a new MS mouse optical again.
    Ah, also hate MS games.
    Also hate MS developers including Myself. I would have gone PHP instantly, and i mean INSTANTLY if i did not have an MS requirement job.
    OK hate mode off.
    I love pink flowers and Nortel phone devices!
    Slow as hell.

  14. #14

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Thanks for the help.
    I finally decided to install the prerequisites, so that I can install Workbench.
    When I try to install VC++ redistributable it asks me to choose some of these three items:
    http://i.imgur.com/2vT2S9o.jpg
    Which ones should I choose?
    It doesn't explain what each one of these three items is. So, how can I choose them?
    Please note that my computer is 64 bit, running Windows 8.1 (64 bit).
    Please advise.
    Thanks.

  15. #15
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,501

    Re: How to write and run ANY query in MySql?

    The file names use a very common naming convention, where the end part describes the processor type.

    _arm is for Arm processors (you would know if you had one)
    _x86 is for 32 bit processors
    _x64 is for 64 bit processors

  16. #16

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    The file names use a very common naming convention, where the end part describes the processor type.

    _arm is for Arm processors (you would know if you had one)
    _x86 is for 32 bit processors
    _x64 is for 64 bit processors
    Thanks a lot for the great advice.
    I selected x64 (because my computer has a 64 bit cpu) and managed to install Workbench successfully.

    Just I have two questions if you don't mind:

    1. I am curious as to why they use the number x86 for 32 bit processors. Shouldn't they use x32 for that purpose?
    As far as I know, these standard Intel processors began many years ago with 8086, then later processors in that same line were 80286, 80386, 80486, and then Pentiums which were all in the same category (the x86 category).
    And the current most recent processors (whether 32 bit or 64 bit) are BOTH in that same group, so, both of them are x86 processor types.
    Then why is only one of them (the 32 bit cpu) referred to as x86?
    Can you please clarify this?

    2. Even though I successfully installed MySql (including Workbench), I am also experimenting with the other option (Microsoft SQL Express).
    When I try to install Microsoft SQL Express, it asks me to choose some of these:
    http://i.imgur.com/na7vKMi.jpg
    The full list being this one:
    http://i.imgur.com/bGHq0EQ.jpg
    Based on your explanation, all of the options 1 to 5 relate to my computer (because my computer has a 64 bit cpu).
    But do I really need ALL five of them?
    I only need to to do the following:
    A. Create a database
    B. I need the application (the Integrated Development Environment) so that I can write queries
    C. I need to be able to write queries in Visual Basic 6 (which I already have installed), and call the SQL via VB6 to execute those queries.
    I don't need fancy stuff like SQL profiler or other advanced tools.
    So, should I choose ALL those options (1, 2, 3, 4 and 5) or just some of them?

    Please advise.
    Thanks.

  17. #17
    Superbly Moderated NeedSomeAnswers's Avatar
    Join Date
    Jun 2002
    Location
    Manchester uk
    Posts
    2,623

    Re: How to write and run ANY query in MySql?

    On the MS SQL Server Express download page it says this -

    LocalDB (MSI installer)
    New to the Express family, LocalDB is a lightweight version of Express that has all its programmability features, yet runs in user mode and has a fast, zero-configuration installation and short list of pre-requisites. Use this if you need a simple way to create and work with databases from code. It can be bundled with Application and Database Development tools like Visual Studio and or embedded with an application that needs local databases.
    Express (Containing only the database engine)
    The core Express database server. Use this if you need to accept remote connections or administer remotely.
    Express with Tools (with LocalDB) Includes the database engine and SQL Server Management Studio Express)
    This package contains everything needed to install and configure SQL Server as a database server. Choose either LocalDB or Express depending on your needs above.
    SQL Server Management Studio Express (Tools only)
    This does not contain the database, but only the tools to manage SQL Server instances, including LocalDB, SQL Express, SQL Azure, etc. Use this if you already have the database and only need the management tools. This package includes LocalDB.
    Express with Advanced Services (contains the database engine, Express Tools, Reporting Services, and Full Text Search)
    This package contains all the components of SQL Express. This is a larger download than “with Tools,” as it also includes both Full Text Search and Reporting Services.
    Which means basically all you need is Option 3 (Express with Tools), which should contain everything you need !
    Please Mark your Thread "Resolved", if the query is solved & Rate those who have helped you



  18. #18
    Super Moderator si_the_geek's Avatar
    Join Date
    Jul 2002
    Location
    Bristol, UK
    Posts
    41,501

    Re: How to write and run ANY query in MySql?

    2 has been answered, so:
    Quote Originally Posted by IliaPreston View Post
    1. I am curious as to why they use the number x86 for 32 bit processors. Shouldn't they use x32 for that purpose?
    As far as I know, these standard Intel processors began many years ago with 8086, then later processors in that same line were 80286, 80386, 80486, and then Pentiums which were all in the same category (the x86 category).
    And the current most recent processors (whether 32 bit or 64 bit) are BOTH in that same group, so, both of them are x86 processor types.
    Then why is only one of them (the 32 bit cpu) referred to as x86?
    Can you please clarify this?
    ... the 32 bit only CPUs are still part of the same family (all ending in 86, hence x86), and can run exactly the same programs as the original 8086 processors (but the 8086 processors can't run programs that are specifically designed for 80286 and higher). There are other types of 32 bit processors too, but the x86 family is what was standard for Windows etc.

    To make it awkward, most 64 bit processors are hybrids - so they can run in 64 bit mode (x64) or 32 bit mode (x86), and can often do both at the same time (eg: I run Windows as 64 bit, but some programs run as 32 bit).

  19. #19

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Thanks for all the great advice.
    I installed Microsoft SQL Express a few days ago, and the installation completed successfully.
    Now, I need to open the Query Analyzer (and write queries in it), but I cannot find it.
    The installation did not add an icon to my desktop (did not even ask me if I wanted such an icon), and when I take a look at all the files that are installed, I find nothing like the Query Analyzer that I am familiar with. I need to open the Query Analyzer, so that I can write queries in it and run them.
    Where do I find the Query Analyzer?
    During the installation, I chose only this item (as per your advice):
    http://i.imgur.com/QXuUt3G.jpg
    and when I look at my control panel, I see this:
    http://i.imgur.com/linpxM4.jpg
    Also, when I look at my C: drive, I see that the installation Wizard has created new subfolders under both
    C:\Program Files
    and:
    C:\Program Files (x86)
    There are three such subfolders as follows:
    C:\Program Files\Microsoft SQL Server
    C:\Program Files (x86)\Microsoft SQL Server
    C:\Program Files (x86)\Microsoft SQL Server Compact Edition
    I opened a DOS command, and ran the following DOS command:
    dir/s
    three times (once for each of the above three directories, and the three results are attached in here to this post (three .txt files attached to this post).
    Looks like there is NOTHING like the Query Analyzer (the IDE for Microsoft SQL Server)
    Is there something that I am missing?
    Where is the Query Analyzer?
    Thanks.
    Attached Files Attached Files

  20. #20
    Superbly Moderated NeedSomeAnswers's Avatar
    Join Date
    Jun 2002
    Location
    Manchester uk
    Posts
    2,623

    Re: How to write and run ANY query in MySql?

    Query Analyser hasnt been part of the SQL Server since SQL Server 2000.

    The Query feature is now a part of the SQL Server Management Studio you should be looking for an icon like this -

    Name:  SQLSERVER.png
Views: 55
Size:  20.5 KB

    Once you open the Management Studio it will look like the image below, hit the New Query button and you get what is now the Query tool (which is basically Query Analyser). It isnt a seperate application anymore just part of the sql management studio

    Name:  SQLSERVER2.jpg
Views: 55
Size:  19.8 KB
    Please Mark your Thread "Resolved", if the query is solved & Rate those who have helped you



  21. #21

    Thread Starter
    Fanatic Member
    Join Date
    Mar 2010
    Posts
    564

    Re: How to write and run ANY query in MySql?

    Wow!
    Great advice!
    Actually everybody's advice in here was great.
    My problem is now resolved, and I am going to close this thread.
    My best regard goes to everyone who helped.
    Ilia

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width