News Articles mysql

How to create database MySQL with Docker

I’ll to show how to create an local database MySQL with Docker, in yours Windows. It is necessary has the last version Docker intalladed in your machine. 1st step: Dowload the MySQL image Let’s download the latest MySQL image to the Docker hub, type the following command below: docker pull mysql/mysql-server 2st step: Execute the […]

Fill in missing Date ranges using MySQL

I’m always trying different programming exercises in order to learn and grow as a Developer. One of my favorite learning exercises is… Continue reading on Level Up Coding » Source: Level Up Coding

Determine the First and Last Day of a Month with MySQL

Working with date values is part of every developer’s job. It seems like we are always looking for or filtering some data by date or a… Continue reading on Level Up Coding » Source: Level Up Coding

Easiest way to setup MySQL/MariaDB with TLS/SSL in 10 minutes- v10.5 – Any OS – Ubuntu Focal | Developer Tharun

MySQL/MariaDB setup In this tutorial we will look at how to setup MariaDB/MySQL including SSL/TLS. This will enable the clients connecting with the MySQL server. We will add repository, install mariadb-server, generate certs, place them in the right folder, edit the configurations and test it. Link to fetch the respective repository Link to the MariaDB […]

How to Reset MySQL root password in Ubuntu

Passwords are hard to remember, so if you have forgotten the MySQL root password, luckily, there is a way to change it. This post has been written for you, and by the end of this post, you will have successfully changed the password of MySQL. This blog demonstrates how to reset the root password for […]

Database character sets and collations explained – why utf8 is not UTF-8

Table Of Contents Character sets and collations explained Charater sets: The tale of □�💩 Why utf8 in MySQL is not UTF-8 Collations: How to sort things What about performance? Conclusion The relationship between character sets and collations always seemed pretty vague to me, let alone the possible impact on performance. So if you are like […]

TIL: MySQL timestamp column can't go beyond '2038-01-19 03:14:07'

MySQL ‘timestamp’ type column cannot store value beyond ‘2038-01-19 03:14:07’ UTC, i.e., Int32 limit (2147483647). What do you think about Postgres timestamp column. Can they? Source: DEV Community

What are the top 9 SQL Queries for freshers?

In general, query is a request for something. But in the world of programming query means retrieving data from the database with commands that are preset. i.e. SELECT, INSERET, SUM, WHERE etc. Furthermore, if you wish to explore more about the SQL, DBMS you can visit the page below. SQL Queries are asked directly in […]

MySQL- RDBMS

Relational Database(MySQL) RDBMS stands for Relational Database Management System. Relational databases define the relation between different data tables. This relation can be created based on one common data table’s column that is the same in both data tables and the data column must be a unique data field. MySQL is a free and fast Relational […]

Hyper QuickStart to MySQL

Be straight, just do it. MySQL MySQL is a SQL Database. To connect to a MySQL Database you need: The server adress A username A password A database Admin the MySQL To enter the admin console you have 2 options. mysql As root, use mysql: mysql As user: mysql -u=my_username -p -p means a password […]

Export Query Results to CSV with MySQL Workbench

CSV files are used for everything. Since CSV’s are so common and are a friendly exchange format, everyone understands CSV’s. This is great… Continue reading on Level Up Coding » Source: Level Up Coding

MySQL Cheat sheet

Creating tables 📑 CREATE TABLE BookHistory ( Auther VARCHAR(129), title VARCHAR(129), btype VARCHAR(129), year CHAR(4) ); To drop table column ALTER TABLE tableName DROP column-Name; ex. ALTER TABLE BookHistory DROP Auther; How to delete Data from a MySQL table ? // Delete Statement is used to delete data, DELETE FROM table_name WHERE column_name = VALUE […]

CodeIgniter 4 Query Builder set() function with update()

CodeIgniter 4 Query Builder class has a update() function used to process UPDATE Data Manipulation Language (DML) commands. Using update()… Continue reading on Level Up Coding » Source: Level Up Coding

Fun times with MySQL upgrade

Like all service upgrades, MySQL is no different. Bump the service version, build the docker image, try to “make up“ the project and hope for the best. I’ve decided to dedicate this blog to four things that turned this “it is going to be an easy project” to “8 months in hell while upgrading MySQL […]

How to integrate an external page builder to my custom built PHP-MySQL Website?

I am building a community based forum website-application in LAMP stack, where each community member will get his/her own profile page. Now I want to use some external page builder which can be integrated with my website so we can easily build these profile pages. Please suggest anything related. Source: React – Stack Overflow

Horizontal menu with 3 multilevel

In the database I have three tables for registering categories. The first table records the main categories. The second table records the secondary categories which are children of the main ones. The third table records the sub-categories that are children of the secondary ones. <?php /////////////////////////FIRST CATEGORY///////////////////////////////// $sql_categoria = "SELECT category_id,category_name,category_url,metatit,metadesc,metakey,status FROM coupons_category WHERE status=’A’ […]

Application web: message sending

I am developing a web application where several clients can send messages to each other, it would be like instant messaging. To illustrate the situation, let’s imagine a classroom where students are on a web page and can send messages to their teacher who is on another web page displaying all the messages. The teacher […]

Sitemap | Terms | Privacy | Cookies | Advertising

Senior Software Developer

Creator of @LzoMedia I am a backend software developer based in London who likes beautiful code and has an adherence to standards & love's open-source.