NO lock in mysql [duplicate]

Question

I am building a desktop application with back-end in MySQL. Does Mysql Support No Lock or some thing equivalent to this as in sql?

Select * from Tablename (NoLock);

Suppose I am fetching data from multiple tables using join, Then do i Need to implement this code while selecting rows from each and every table?

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM 'Table1' 
 iNNERjOIN TABLE2 ON TABLE2.FK=TABLE1.PK ;
COMMIT ;

Answer 1

try this

SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED ;
SELECT * FROM Tablename ;
COMMIT ;