MySql and Batch Queries

Discussion in 'MySQL' started by kolucoms6, Mar 19, 2009.

0
  1. #1
    I am using CentoS.

    I have mysql installed.

    I want to run around 60 queries.

    Whats the best way to do it ?

    If batch file then how to create batch file and how to run it in mysql environment ?
     
    kolucoms6, Mar 19, 2009 IP
  2. nirajkum

    nirajkum Active Member

    Messages:
    815
    Likes Received:
    5
    Best Answers:
    0
    Trophy Points:
    58
    #2
    Create a .sql file write all your queries in that and run it . If you want to run it at some specific time then write a cron job
     
    nirajkum, Mar 19, 2009 IP
  3. mwasif

    mwasif Active Member

    Messages:
    816
    Likes Received:
    23
    Best Answers:
    1
    Trophy Points:
    70
    #3
    mwasif, Mar 20, 2009 IP
  4. basecore

    basecore Peon

    Messages:
    47
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    0
    #4
    or you can use phpmyadmin
     
    basecore, Mar 20, 2009 IP
  5. kmpoaquests

    kmpoaquests Active Member

    Messages:
    55
    Likes Received:
    3
    Best Answers:
    0
    Trophy Points:
    63
    #5
    why not use a free alternative opensource to cpanel ?
     
    kmpoaquests, Mar 20, 2009 IP