| 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
|
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.. |