+ 2

how can we code in code background without a real table to test whether the code is correct or NOT ?

30th Aug 2016, 5:31 PM
Aref Davari
Aref Davari - avatar
2 Respostas
+ 2
If you want to check if the Syntax is correct you need a tool to do that for example: https://www.piliapp.com/mysql-syntax-check/ You can simulate queries by using a TRANSACTION, check the result and then ROLLBACK so it does not save. You can check how a script would function by using DESCRIBE in front of the query.
31st Aug 2016, 12:49 AM
Nathan “Grimston” Pipes
Nathan “Grimston” Pipes - avatar
0
We can use #tables which will store the data temporarily. they will be deleted from the database once the ongoing session is closed. they are also called as temp tables
1st Jan 2017, 11:54 AM
Pradeep Gupta
Pradeep Gupta - avatar