MySQL supports a multi-table UPDATE
syntax, which would look approximately like this:
UPDATE Reservations r JOIN Train t ON (r.Train = t.TrainID) SET t.Capacity = t.Capacity + r.NoSeats WHERE r.ReservationID = ?;
You can update the Train
table and delete from the Reservations
table in the same transaction. As long as you do the update first and then do the delete second, it should work.
Related Posts:
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- Unknown column in ‘field list’ error on MySQL Update query
- Unknown column in ‘field list’ error on MySQL Update query
- MySQL – Operand should contain 1 column(s)
- MySQL “CREATE TABLE IF NOT EXISTS” -> Error 1050
- MySQL Error: : ‘Access denied for user ‘root’@’localhost’
- MySQL create table if not exists and insert record only if table was created
- How do I use properly CASE..WHEN in MySQL
- How can I do a FULL OUTER JOIN in MySQL?
- MySQL query String contains
- What’s the difference between VARCHAR and CHAR?
- Case statement in MySQL
- How to declare a variable in MySQL?
- MySQL Cannot Add Foreign Key Constraint
- How to split the name string in mysql?
- How do I import an SQL file using the command line in MySQL?
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- mysql Foreign key constraint is incorrectly formed error
- MySQL: Invalid use of group function
- How can I return pivot table output in MySQL?
- Compare dates in MySQL
- MySQL “WITH” clause
- MySQL Multiple Joins in one query?
- Error Code: 2013. Lost connection to MySQL server during query
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock’ (2)
- how to drop partition without dropping data in MySQL?
- MySQL combine two columns into one column
- Simple way to calculate median with MySQL
- Error 1046 No database Selected, how to resolve?
- MySQL Error 1264: out of range value for column
- Remove duplicate rows in MySQL
- How to SUM and SUBTRACT using SQL?
- Cast from VARCHAR to INT – MySQL
- SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
- How do you force mysql LIKE to be case sensitive?
- MySQL – UPDATE multiple rows with different values in one query
- How to create a MySQL hierarchical recursive query?
- ERROR 1148: The used command is not allowed with this MySQL version
- Insert into a MySQL table or update if exists
- How to round down to nearest integer in MySQL?
- MySQL starts with searching issue
- Query to convert from datetime to date mysql
- Is it possible to GROUP BY multiple columns using MySQL?
- MySQL error: key specification without a key length
- Best way to test if a row exists in a MySQL table
- Check if MySQL table exists without using “select from” syntax?
- MySQL equivalent of DECODE function in Oracle
- mysql update column with value from another table
- The used SELECT statements have a different number of columns
- How to delete from multiple tables in MySQL?
- MySQL: Can’t create table (errno: 150)
- How to copy a row and insert in same table with a autoincrement field in MySQL?
- Join vs. sub-query
- Alternative to except in MySQL
- Equivalent of explode() to work with strings in MySQL
- ROW_NUMBER() in MySQ
- MySQL OPTIMIZE all tables?
- MySQL INSERT INTO table VALUES.. vs INSERT INTO table SET
- MySQL – Get row number on select
- MySQL error: Unknown column in ‘where clause’
- How to truncate the text returned for a column in a MySQL query
- Using union and order by clause in mysql
- MySQL LIKE IN()?
- What is the difference between “INNER JOIN” and “OUTER JOIN”?
- Case in Select Statement
- INSERT statement conflicted with the FOREIGN KEY constraint – SQL Server
- SQL SELECT WHERE field contains words
- How do I limit the number of rows returned by an Oracle query after ordering?
- ORA-00918: column ambiguously defined in SELECT *
- How to parse XML data in SQL server table
- ERROR 1452: Cannot add or update a child row: a foreign key constraint fails
- Bulk load data conversion error (type mismatch or invalid character for the specified codepage) for row 1, column 4 (Year)
- SQL selecting rows by most recent date with two unique columns
- SQL “select where not in subquery” returns no results
- ListAGG in SQLSERVER
- Oracle: If Table Exists
- How to calculate age (in years) based on Date of Birth and getDate()
- How to create id with AUTO_INCREMENT on Oracle?
- Update query using Subquery in Sql Server
- register_post_status – show_in_admin_all_list & show_in_admin_status_list does not affect query
- How to execute mulitple statement SQL queries using $wpdb->query?
- Return number of items in a table with post id
- How do I find which articles are missing a featured image in The WordPress database?
- Debugging WordPress
- Importing Geo data into wordpress database
- Pull data and display as rows and columns
- Speeding SQL queries for a large database?
- I need a SQL command to delete specific authors and all posts connected with them
- SQL query to set posts in bulk based on the post content
- How can i restore only Blogs from a SQL backup file?
- DB_HOST – is LOCALHOST speedy than domain name? [closed]
- Sql query does not work well
- How to change post published date to today date with SQL
- Do I need to sanitize $_POST[‘keyword’] before send to ‘s’ parameter?
- Display a number value from mysql query in WP
- how to SELECT meta values that are not null?
- How to show result of sql query in a page?
- Conditional statement within WP SQL query
- Sql query returns empty. But not
- Delete posts with word count less than x number of words