Hello and welcome to our community! Is this your first visit?
Register
Enjoy an ad free experience by logging in. Not a member yet? Register.
Results 1 to 2 of 2

Thread: splitting table

  1. #1
    Regular Coder
    Join Date
    Apr 2003
    Location
    Canada, Ontario, Mississauga
    Posts
    312
    Thanks
    0
    Thanked 0 Times in 0 Posts

    splitting table

    I have a table called song

    Song contains name, size, and language

    Only 'e' and 'c' are in the language ( e for english and c for chinese)

    how do I make this one table (Song) into 2 different talbes (English_song and Chinese_song) according to it's language?

    Thank you

  • #2
    raf
    raf is offline
    Master Coder
    Join Date
    Jul 2002
    Posts
    6,589
    Thanks
    0
    Thanked 0 Times in 0 Posts
    do you really need to split the table in two? I will make things harder for your code.

    The easiest way would be to copy (using a db frontend or mysqlhotcopy) the table, and then run a deletestatement on each table

    delete from englishtable where language='c'
    delete from chinisetable where language='e'


  •  

    Posting Permissions

    • You may not post new threads
    • You may not post replies
    • You may not post attachments
    • You may not edit your posts
    •