Advertisement
If you have a new account but are having problems posting or verifying your account, please email us on hello@boards.ie for help. Thanks :)
Hello all! Please ensure that you are posting a new thread or question in the appropriate forum. The Feedback forum is overwhelmed with questions that are having to be moved elsewhere. If you need help to verify your account contact hello@boards.ie
Hi there,
There is an issue with role permissions that is being worked on at the moment.
If you are having trouble with access or permissions on regional forums please post here to get access: https://www.boards.ie/discussion/2058365403/you-do-not-have-permission-for-that#latest

SQL help

  • 06-03-2008 1:43pm
    #1
    jayteecork
    Site Banned Posts: 5,676 ✭✭✭


    I'm doing a course that has a small element of SQL in it and have an exam in it next Monday.
    I have no SQL program on my own computer and was wondering if some sort of free download is available for practice on.

    The type of SQL we are doing is like this:
    eg: Show the salary, name, and a salary increase by 25%. label the columns with proper names.

    (answer: SELECT ename "Name", sal "Salary", ROUND(SAl*1.25,0)"New Salary"
    From emp;

    This really has nothing to do with my course as a whole but I need to do well on it.
    Anyone know where I can get a program to practice.


Comments

  • #2
    aidan_walsh
    Closed Accounts Posts: 17,208 ✭✭✭✭aidan_walsh


    I have no SQL program on my own computer and was wondering if some sort of free download is available for practice on.
    www.mysql.com


  • #3
    jayteecork
    Site Banned Posts: 5,676 ✭✭✭jayteecork


    aidan_walsh wrote: »
    www.mysql.com

    cool, thanks.

    There seems to be a lot of content on the site, what should I be aiming for?


  • #4
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    I think this is what you need - havn't downloaded it though:

    http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-5.0.51a-win32.zip/from/http://ftp.heanet.ie/mirrors/www.mysql.com/

    Then once you've that install and it running - might require restart, download
    http://sourceforge.net/projects/mysqlcc/

    Default username should be root
    Default password should be empty.


  • #5
    jayteecork
    Site Banned Posts: 5,676 ✭✭✭jayteecork


    Can't get the bloody thing working.
    The MySql command line client flashes up for a split second then disappears.
    When I try to config it says something about setting up a set association on the control panel.


  • #6
    Webmonkey
    Registered Users, Registered Users 2 Posts: 9,579 ✭✭✭Webmonkey


    When you installed it, you should make it run as a service. It should start automatically then when you start your computer.

    It runs in the background, you can use MySQL Control Center to log into it then and do you DB creating with SQL in there.

    Edit: Click start-> Run. Type cmd and click ok. In the black dos box that appears type net start mysql.
    What does it say? If it says it is already running then you should be able to use MySQL Control Center. Even if it says the service starts, you can do it then. But if it says it cannot start the service then you have problems.


  • Advertisement
Advertisement