I tired to googling this issues every time I need to create some test instance with MySQL (MariaDB) on Linux ))
CREATE DATABASE dbname;
GRANT ALL PRIVILEGES ON dbname.* TO 'user'@'localhost' IDENTIFIED BY 'password';
That is all!
I need help 🙂
What we have:
1. The table A with next columns:
2. The table B with next columns:
What I need to get:
For any asset ID I need next information:
Right now I have three different sql query for this result. I tried to create some view. It didn’t work for me.
Who can help me? 🙂
P.S. Don’t ask me about VARCHAR ))