Pdo on duplicate key update

Beginning with MySQL 8. Using the row alias new , the statement shown previously using VALUES to access the new column values can be written in the form shown here:. If, in addition, you use the column aliases m , n , and p , you can omit the row alias in the assignment clause and write the same statement like this:. When using column aliases in this fashion, you must still use a row alias following the VALUES clause, even if you do not make direct use of it in the assignment clause.

You can also use row and column aliases with a SET clause, as mentioned previously. The row alias must not be the same as the name of the table. Column aliases must be unique with regard to the row alias to which they apply that is, no column aliases referring to columns of the same row may be the same. References to columns from queries on a single table, which may be a derived table.

One side effect is that you must qualify references to nonunique column names. To work around this restriction, rewrite the UNION as a derived table so that its rows can be treated as a single-table result set. For example, this statement produces an error:. Such statements produce a warning in the error log when using statement-based mode and are written to the binary log using the row-based format when using MIXED mode.

Data Definition Statements. LIKE Statement. Silent Column Specification Changes. Secondary Indexes and Generated Columns. Data Manipulation Statements. The Subquery as Scalar Operand. Comparisons Using Subqueries. Rewriting Subqueries as Joins. Restrictions on Subqueries. I would have preferred if it were possible to overload the rowCount function from PDOStatement, but I don't think it's possible or I don't know how to do it.

I don't know if we have alike case to others or this is just a problem in our coding. In local, the rowCount is not giving the correct number of rows but it is working fine when uploaded to our hosting site.. The fetchColumn is working fine in local but not anymore when uploaded.

I don't know what is really going on with that but I think rowCount is the best and the others are optional to use. Yet another workaround to return the row count inside only ONE select see limitations below!

Disadvantages: - it doesn't return row fields reliable if more than one row found. You might need a space between the comma-separated fields in the SET clause- I can't remember if it's valid to omit the space.

Add a comment. Active Oldest Votes. Michael Berkowski Michael Berkowski k 42 42 gold badges silver badges bronze badges. Michael, thank you so much for your help. The code's all working now. SamT SamT 9, 2 2 gold badges 29 29 silver badges 38 38 bronze badges. The form is a Monday - Friday 8am - pm table in 30m intervals for faculty to input their office hours. I'm open to other ideas on database design but that's a whole other subject. Sign up or log in Sign up using Google.

Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown.