• Coding

    Useful MySQL Queries for a Beginner like me: SELECT

    I am at the moment learning a lot about MySQL by reading the book, Learning MySQL and I thought providing a list of queries could help beginners like myself. Different ways to select databases, tables, rows and columns in MySQL Do note, I will be updating the list occasionally. So if this list seems incomplete, you may either wait, provide suggestions per email or simply comment down below.   Just basics here; listing out your databases  –> SHOW DATABASES(DB); To focus on a specific database –> USE {DB_NAME} To list all the tables in that specific database –> SHOW TABLES; Display the “column headers” of a table and their properties e.g. default value, type…

  • Lexpression Web Application
    Coding

    Lexpression Web application | Day (can’t remember) : Deployment

    Lexpression Web App  simplifying language learning… 11:17:20 AM finally can sleep Apologies for not documenting the development process daily, however, if you follow my Youtube channel, you should have seen the coding videos. So yea, the website /web application is deployed and it looks good, like functionally good.Not sure about the basic design. The web app is created using React, pure JS, PHP and MYSQL. PHP and MYSQL were quite problematic for me, especially using classes, traits and encapsulating data that should not accessible to the world. But I did it. The code could be improved, actually, will be improved but later. My main goal is to automate thee database…

Enjoy this blog? Please spread the word :)

error: Content is protected !!