Bash - reading stuff from MySQL..

Discussion in 'Programming/Scripts' started by edge, Mar 31, 2006.

  1. edge

    edge Active Member Moderator

    Hi all,

    I could really use some help with some bash coding, and reading stuff from a database.

    Lets say that the owner of the DB is named: root
    His password is: 12345
    The name of the MySql databaes it: somename
    The server is: localhost

    The quiry to create the database looks like this:
    CREATE TABLE `name_users` (
      `ID` int(10) NOT NULL auto_increment,
      `user_name` varchar(50) default NULL,
      `user_emailaddress` varchar(50) default NULL,
      `user_info` varchar(50) default NULL,
      UNIQUE KEY `ID` (`ID`)

    Now how do I read the database named 'somename', read the table 'named_users' and show only the results of 'user_name' and 'user_info' (like this)

    frank		some user info about frank here
    peter		some user info about peter here
    steven		some user info about steven here
    This all needs to be dumped in a 'txt' file.

    Anyone here who could give me some help / samples with this?
  2. sbovisjb1

    sbovisjb1 Member HowtoForge Supporter

  3. falko

    falko Super Moderator Howtoforge Staff

    If you want to do this from a shell script, have a look at the mysql command:
    man mysql
    There's an option (-e) that lets you execute MySQL queries directly from the shell.
  4. 22hosting

    22hosting New Member

    mysql -e SELECT user_name, user_info FROM named_users -u <mysqlusername> -p <mysqlpassword> somename

    or something like that
    Stage Grinder
    Last edited: Aug 22, 2011

Share This Page