Category: mysql

Previously, I have used LinqPad a lot to run a few handy queries to @steemsql server. The @steemsql is a MSSQL server. However, I am more comfortable in MySQL …

Let’s suppose we have a table containing two columns ID and sex, and our task is to swap the values of sex i.e. from ‘f’ to ‘m’ and from …

Although there are many available mortgage calculators out there, the principle of a simple mortgage calculator is really simple, which is based on the following math formula. where, the …

The MySQL table has a command Show Table Status which prints a table summary, but it contains lots of information about all tables in the current database (to change …

If you have lots of rows to insert into a MySQL table, you might experience it taking ages to complete. For example, I have around 100K rows to insert …