-- Insert Anastasia Dualla from Sagittaron into the bsg_people table. You should use a subquery to do this.

MySQL problem

SELECT * FROM `bsg_people' ORDER BY `homeworld' DESC Profiling [ Edit inline ] [ Edit ] [ Explain SQL][ Create PHP code ] [ Refresh] Show all Number of rows: 25 Filter rows: Search this table Sort by key U + Options +T Edit - Copy Edit Fc Copy Edit - Copy Edit - Copy Edit - Copy Edit Fc Copy Edit Copy Edit Copy Edit - Copy Edit Copy Edit - Copy Edit : Copy Edit - Copy Edit Copy Edit Copy U 0 0 0 0 0 0 0 0 0 0 0 0 0 id fname Iname homeworld - 1 age Delete 11 Samuel Anders 19 NULL Delete 1 William Adama 3 61 Delete 2 Lee Adama 3 30 Delete 3 Laura Roslin 3 NULL Delete 4 Kara Thrace 3 NULL Delete 5 Gaius Baltar 3 NULL Delete 8 Galen Tyrol 1 32 Delete 7 Karl Agathon 1 NULL Delete 9 Callandra Henderson NULL NULL Delete 6 Saul Tigh NULL 71 Delete 12 Margaret Edmondson NULL NULL Delete 13 Brendan Costanza NULL 36 Delete 14 Sharon Valerii NULL NULL Delete 235 Sherman Cottle NULL 66 U U O O O Delete 236 Felix Gaeta NULL 28 SELECT * FROM `bsg_planets Profiling ( Edit inline ] [ Edit ] [ Explain SQL] [ Create PHP code ] [ Refresh ] Show all Number of rows 25 Filter rows: Search this table Sort by key: None 0 + Options +T+ Edit c Copy Edit t Copy Edit - Copy Edit Copy Edit : Copy Edit Copy Edit - Copy Edit Copy Edit - Copy Edit Copy Edit - Copy U 0 id name population language capital Delete 1 Gemenon 2800000000 Old Gemenese Oranu Delete 2 Leonis 2600000000 Leonese Luminere Delete 3 Caprica 4900000000 Caprican Caprica City Delete 7 Sagittaron 1700000000 NULL Tawa Delete 16 Aquaria 25000 NULL NULL Delete 17 Canceron 6700000000 NULL Hades Delete 18 Libran 2100000 NULL NULL Delete 19 Picon 1400000000 NULL Queestown Delete 20 Scorpia 450000000 NULL Celeste Delete 21 Tauron 2500000000 Tauron Hypatia Delete 22 Virgon 4300000000 NULL Boskirk O O O O O