mysql Tag Posts Index

Rediscovering Joy in Code: Why I’m Loving PHP and MySQL Again!!

There’s something incredibly satisfying about firing up a Raspberry Pi, opening a blank PHP file, and just… building. In a world obsessed with fancy frameworks and

I Just Learned How to Sort Following List by Reputation With HiveSQL—Feels Silly but Exciting!

There's this awesome tools by @arcange called HiveSQL and if you haven't supported the proposal check out the proposal to keep HIVESQL price "Free" to

Website Update: 6 September 2024

Development of my web app is going nicely. I ended up rebuilding the database using a standard naming convention. This saw me have to rewrite the code to match the

Site Update - 30/8/24

The difference between what I had done since my last post verses what I've achieved in the past 3 days is night and day. I decided to use Bootstrap for the time

温故而知新：使用mysqldump备份WordPress MySQL数据库

最近打算升级一台服务器，上边部署有一个wordpress站点，升级跨度挺大，而且站点上的wp程序又好久没有更新，怕升级后wp与系统不兼容，所以在这之前需要备份一下站点。 (图源 ：pixabay) 站点有两部分主要数据，分别是站点上的程序文件（*.php一堆）、图片等，以及站点的MySQL数据库。

SQL desde la terminal [esp] [eng]

VERSIÓN EN ESPAÑOL English Version Source En uno de mis últimos posts comentaba que como herramienta en la práctica de las consultas a una base de datos tenemos

MongoDB的数据结构和字段 / 网络研习社#82

MongoDB非常灵活，不需要像MySQL一样创建数据库、表、设计表结构。它只需要向指定的数据库集合插入即可（数据库不存在也没关系，可以随时自动创建）。 MongoDB可以有多个数据库，一个数据库可以有多个集合（表），一个集合可以有多个文档（表记录）。可以有相同的表结构，也可以不同。 MongoDB的数据结构类似上图中的JSON样式

MongoDB的安装与运行 / 网络研习社#79

自研究区块链以来，就没再碰数据库了！博客就用Hive，代码就用github, 一般都够用，就不去折腾MySQL、MongoDB这些了。

[PL/EN] Nginx+PHP+Mysql on Windows Powered by Linux with windows side files? Nginx na Windowsie hostowany przez linuxa z plikami po stronie windowsa?

[ENGLISH] - Język polski poniżej CTRL + F [POLSKI] Hi! This time we will go with a more twisted topic, especially for people who have not done this yet. At least

Syncronice y comparta ficheros en la nube con Seafile

Seafile es una solución de sincronización y uso compartido de archivos, diseñada para brindar alta confiabilidad, rendimiento y productividad. Con Seafile puedes

¿Cómo mostrar variables del sistema en MySQL?

La sentencia SHOW VARIABLES muestra el valor de las variable del sistema/servidor en MySQL, no se necesita permisos especiales para ejecutar esta sentencia solo

Updating the Database

Forgive me Father: For I have sinned! So I was using MySQL to search for a post that I had written so I could link back to it... and it didn't pop up. Something

Curso Básico de SQL: "Aprende a crear, leer, actualizar y eliminar en MySQL en solo 10 minutos"⚡️ - Episodio 3

¡Hola Comunidad de Geek Zone! Hi Geek Zone Community! Les saluda su amigo Michael Peters y te invito a que aprendas conmigo los fundamentos básicos de SQL, Así que

Curso Básico de SQL: La clave para evitar errores en bases de datos: cómo colocar correctamente los tipos de datos en SQL ⚡️ - Episodio 2 [ESP]

¡Hola Comunidad de Geek Zone! 💻 Hi Geek Zone Community! 🍽 Les saluda su amigo Michael Peters y te invito a que aprendas conmigo los fundamentos básicos de SQL,

Structured Query Language(Basics 1)

Hello, there it's me once again (obviously), but I've come bearing gifts of knowledge. This time around I'm here with the Structured Query Language AKA SQL. It is

[ESP][ENG] I made this CRUD of people in jsp, servlet (java) based on MVC 👨‍💻💻

I think the best practice to develop more knowledge about the backend is to perform the famous CRUD, which consists of methods that allow you: Add, modify and delete

Anyone fluent in MySQL?

MySQL Integration I am browsing the Unreal Engine Marketplace and found this free plugin. If someone knew how to use it they might create some interesting visuals.

Fatal Error Unable to create lock file: Bad file descriptor (9)

503 error on user websites caused by CageFS Check the logs tail /var/log/apache2/stderr.log Fri Apr 29 12:32:02 2022 (95855): Fatal Error Unable to create lock file:

Remove custom reseller branding when transferring cPanel accounts

Scenario: cPanel user X was under a reseller account that applied custom branding, so now when user X wants to migrate its cPanel account to another hosting and

No request delivery notification has been received from LSAPI application, possible dead lock.

On a small VPS runing CyberPanel and NextCloud the NextCloud pages were loading forever. When checking the cyberpanel error log the following error stood out: No