I have a left join query that shows values from the primary table (tblmarkers) and all the fields from another table (tblmarkers) TblLocations) where Milan is the record. There is no record for each ID of tblMarkers in TblLocations
$ query = "SELECT` tblmarkers`. *,` TblLocation`. *, `TblLocation` .```````` `Tblmarkers' with 'Marker ID' LEFT JOIN` tblLocation` at `TblMarkers` .ID` =` TBLOolation``````` where `TBL markers` id = $ id"; I am comfortable to use the update to update the tblmarkers field but how do I update or insert a record in TBLocation if the record still does not exist.
Also, how can I record a record to prevent any other person from updating at the same time?
Can I also use Update Tumblr Marker * or do I need to update every field statement? Unfortunately you may have to apply some assumptions to your external script in a in SQL.
If statement, but I'm not sure that you can turn on different commands depending on its result.
Lock In case of locking, you have 2 options for MyISAM tables, you only
Lock table users can lock the entire table; For InnoDB tables, there is no clear 'lock' for single rows, although you can use the transaction to gain exclusive rights during the operation.
Update Some may be a hint of short stories, but I think that you must list each field in your query. Alternatively, you can always read the entire line, delete it, and insert the shorthead again via the INSERT query. It all depends on how many fields you have.
No comments:
Post a Comment