This is sample query to delete record from multiple tables.
Specify all joined tables to get the list but can specify records in which tables to be deleted.
DELETE t1, t2 FROM t1 INNER JOIN t2 INNER JOIN t3 WHERE t1.id=t2.id AND t2.id=t3.id;
OR
DELETE FROM t1, t2 USING t1 INNER JOIN t2 INNER JOIN t3 WHERE t1.id=t2.id AND t2.id=t3.id;
Reference
https://dev.mysql.com/doc/refman/8.0/en/delete.html (refer section – Multi-Table Deletes)
Got this error while importing csv to table in MySQL database using sequel pro.
This error normally because of extra space in field name that mysql cannot accept.
But sometimes you just can’t find where is the extra space.
One way to solve is add additional column, when import, just ignore the last field and you can import it as usual.
To build a foolproof and super easy to maintain system must be a goal for a system development.
To get to that, it has to have
Asana is a proficient tool to manage tasks in a small team.
Below is the suggested workflow to be followed
I’ve listed out some related to PDF read and search resources down here for my future reference.
Read DOC file
Transaction feature suitable to be used in 2 conditions.
How to use
run TRANSACTION or BEGIN command
then run other statement as usual
then you have option to ROLLBACK; or to COMMIT;
SQL to check a value exist in one table but not in another.
SELECT t1.name
FROM table1 t1
LEFT JOIN table2 t2 ON t2.name = t1.name
WHERE t2.name IS NULLor this (not tested)
SELECT *
FROM B
WHERE NOT EXISTS (SELECT 1
FROM A
WHERE A.ID = B.ID)Basic git flow
from remote “master”, create a branch “develop”.
pull branch “develop”
branch out branch “feature” or “bug” from local “develop”
commit changes to branch”feature”
push branch”feature” to remote branch”feature”
request merge to remote branch “develop”
after merged, pull branch “develop” to local
Billplz is a malaysian’s payment gateway. It’s free to register, easy to setup and affordable.
If you are using postman to test, add the API Key as username in Authorization tab. Choose “Basic Auth” in Type dropdown. Then enter the URL and params as usual