Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works
Photo

SQL help - Delete transaction


  • Please log in to reply

#1
zell_ffhut

zell_ffhut

    Member

  • Member
  • PipPip
  • 34 posts
Hello

Im trying to make a transaction that deletes an actor from a movies database, and also deletes any records that refer to that actor in other tables.

Im not really sure where to start though. Could anyone give me a few pointers to get started?

Thanks :whistling:
  • 0

Advertisements


#2
gust0208

gust0208

    Member

  • Member
  • PipPipPip
  • 311 posts
I have always found the W3schools tutorials to be helpful and they have a great basic outline of SQL and the syntax, a link is below. Pay special attention to the JOIN and UNION commands to help you find all the appropriate fields across different tables, then use the DELETE commands to delete those entries.

In order to help you more with the SQL statement to do this, we need to know a bit more about how your database is set up for the different tables. Are you using unique primary keys in the tables? If not, how are your tables referencing each other?

http://www.w3schools...sql/default.asp

Cheers,
Tom

Hello

Im trying to make a transaction that deletes an actor from a movies database, and also deletes any records that refer to that actor in other tables.

Im not really sure where to start though. Could anyone give me a few pointers to get started?

Thanks :whistling:


  • 0






Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP