#1
  1. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Lakewood, CO, USA
    Posts
    8
    Rep Power
    0
    OS=Linux
    DB=Mysql

    Did it once, but discarded notes, so asking someone.

    Question: Command-line syntax to create table from a schema file.

    Ex: $mysql -u dave -p somedb schema.tablename<cr>

    I know this is wrong, but not too far off. Correct syntax appreciated.

    Thanks in Advance,

    Dave
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jul 1999
    Location
    Bombay,Maharastra,India
    Posts
    8
    Rep Power
    0
    $mysql -u dave -p somedb < schema.tablename<cr>

    should do the job.
  4. #3
  5. No Profile Picture
    Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Jan 2000
    Location
    Lakewood, CO, USA
    Posts
    8
    Rep Power
    0
    <BLOCKQUOTE><font size="1" face="Verdana,Arial,Helvetica">quote:</font><HR>Originally posted by chyrag:
    $mysql -u dave -p somedb < schema.tablename<cr>

    should do the job.
    [/quote]

    It worked. Thanks. It's time to write it down and save this time.

    Dave

Similar Threads

  1. syntax error : identifer 'Hole'
    By bootrecker in forum C Programming
    Replies: 2
    Last Post: February 2nd, 2004, 08:08 AM
  2. syntax error
    By DQSJR in forum MySQL Help
    Replies: 2
    Last Post: December 31st, 2003, 01:28 PM
  3. mysql syntax error
    By TweetyPie in forum MySQL Help
    Replies: 2
    Last Post: July 25th, 2003, 10:22 AM
  4. MySQL Update Syntax Help needed: "Unknown table"
    By databasiqs in forum MySQL Help
    Replies: 1
    Last Post: January 21st, 2003, 01:44 PM
  5. Replies: 4
    Last Post: June 16th, 2001, 04:24 PM

IMN logo majestic logo threadwatch logo seochat tools logo