reset password
Author Message
Ghost50
Posts: 39
Posted 15:48 Mar 08, 2015 |

On numbers 8-10 on homework #7A what is it asking us to do? I need help, please!!! Thanks.

salleyn2
Posts: 2
Posted 16:18 Mar 08, 2015 |

It is asking us type in the commands, and describe what changes the command makes.

 

Ghost50
Posts: 39
Posted 19:48 Mar 08, 2015 |

What commands are you talking about?

Ghost50
Posts: 39
Posted 21:05 Mar 08, 2015 |

Can someone help me on question 11 please, thanks. the question is;The city council of Alverez, TX changes the spelling of the name of the town to "Alvarez". Update the members table accordingly. 

venny
Posts: 61
Posted 23:00 Mar 08, 2015 |

You will need to use the UPDATE command.  

From the lecture notes: 

To update existing records:

.
UPDATE tablename
SET field1 = value1, field2 = value2, ...
WHERE conditions;

 

 

 So if we need to update the title of the album with the ID of 3, I would need to do.

UPDATE Titles [<-- the tablename] SET Title [<-- The field the value is in] = "The Chicken Dance" [<-- The new value] WHERE ID = 3  [<--- The condition to find the right record to update]

I hope this helped.

Ghost50
Posts: 39
Posted 23:38 Mar 08, 2015 |

What is the table name for #11? My uncle and I tried doing it but to no avail!!!!

Ghost50
Posts: 39
Posted 22:22 Mar 09, 2015 |

Hey Venny can you send me the answers to numbers 1a to 8b for lab 7b please?

Ghost50
Posts: 39
Posted 22:25 Mar 09, 2015 |

Hey Venny can you send me the answers to numbers 1a to 8b for lab 7b please? via email Thanks. But only to my email ; vazquezjonathan55@yahoo.com

Ghost50
Posts: 39
Posted 22:50 Mar 09, 2015 |

I am NOT Cheating.I just need help!!!