Database  >>  mySql

mysql insert into multiple tables using coldfusion

Language : English Quality : Average Has Audio : true Source : Google Videos Media : Flash
Inserting data into more than one table using transactions and coldfusion

Tags: Coldfusion, MySql, Web Development, Screencast, Programming, Database,     [SUGGEST  A  TAG]

Resources referenced in this screencast
  • Coldfusion MX
  • MySQL - The world's most popular open source database

  • Created : 2006-12-14   Duration : 11:58

    Articles Realted to this Topic

    [SUGGEST  A  ARTICLE]
    Updating multiple tables
    The examples in this section all describe how to modify a single database table. However, you might have a database that uses multiple tables to represent information
    SQL Multiple inserts
    Always forget this one at first but to do multiple inserts into a tabel you can use the following:
    SQL to Select a random row from a database table
    There are lots of ways to select a random record or row from a database table. Here are some example SQL statements that don't require additional application logic, but each database server requires different SQL syntax.
    Getting the ID field after an Insert
    About every 2 months or so someone asks about reliably returning the primary key record from an insert query. The problem they are trying to solve usually has to do with additional inserts into related tables. For example, if you are adding a new user and you want to set group permissions as well - but group permissions require inserting into another table. One way to do it is to do an insert, then do a second query that pulls back the "max(id)" and uses another qualifier - like an email address..