Creating an SQL table from another table

Discussion in 'Software' started by Bustergut, Jul 13, 2005.

  1. Bustergut

    Bustergut Private E-2

    I've been stuggling on and have got an Apache server running, along with PHP and MySQL on XP Home. I created a database, but need to decrypt this bit of advice

    $ mysql test < tables.my.sql where

    test is the name of my database and tables.my.sql is supplied. I think it means it's trying to create predefined tables within my database from the supplied table. I'm not sure exactly what to type in. SQl 4.0.21. Anybody help ?
     
  2. theefool

    theefool Geekified

    Have you tried it? Des it give you an error?
     
  3. Bustergut

    Bustergut Private E-2

    Tearing my hair out and just tried it outside of Mysql and it just worked a treat or at least didn't give an error. Just have to work out how to list the structure of the database and its tables.
     

MajorGeeks.Com Menu

Downloads All In One Tweaks \ Android \ Anti-Malware \ Anti-Virus \ Appearance \ Backup \ Browsers \ CD\DVD\Blu-Ray \ Covert Ops \ Drive Utilities \ Drivers \ Graphics \ Internet Tools \ Multimedia \ Networking \ Office Tools \ PC Games \ System Tools \ Mac/Apple/Ipad Downloads

Other News: Top Downloads \ News (Tech) \ Off Base (Other Websites News) \ Way Off Base (Offbeat Stories and Pics)

Social: Facebook \ YouTube \ Twitter \ Tumblr \ Pintrest \ RSS Feeds