Durchsuchen nach
Kategorie: Datenbanken

Datenbanken wie MySQL und MongoDB kommen hier vor.

Python MySQL create a database and a table

Python MySQL create a database and a table

This is a Python script in order to create first the database and then a table with different values in one step. It is useful, then you don’t need to do it in two steps. What is the requirement for the script Installation of Python Windows and Mac For this script, you need to install Python if you are on Windows and Mac. Go to the official web page of Python.org and download your package and installed like another program….

Weiterlesen Weiterlesen

DBeaver for my MySQL databases

DBeaver for my MySQL databases

I used in the past the MySQL Workbench as a stand-alone program in my Fedora desktop. But after a while the distribution did not support the Workbench directly. It could only install it via snap. But in snap you have the problem, that this service produces a lot of log entries into a file in /var/log/messages* so you had to delete this big files after a while. The other solution was to use the MySQL workbench as a plugin in…

Weiterlesen Weiterlesen

Linux (Fedora 41) Bash Script to do a backup for MongoDB

Linux (Fedora 41) Bash Script to do a backup for MongoDB

What is MongoDB? MongoDB is a document-oriented NoSQL database that stores data in flexible, JSON-like documents, allowing for easy storage and retrieval of structured, semi-structured, and unstructured data. Unlike traditional relational databases that use tables and rows, MongoDB uses collections and documents, making it more adaptable to changing data structures. It was designed to handle large volumes of data and is known for its scalability, flexibility, and ease of use. MongoDB is open-source and has a wide range of deployment options, including cloud-based services like…

Weiterlesen Weiterlesen

MySQL – Reset the root password

MySQL – Reset the root password

If you have forgotten your root password (it was in my case) then you can do the followings steps: I use here a Linux, Fedora 41. If you are using other distributions or Windows / macOS, please search for this operating systems. And if your system shows an error message, contact your favourite AI or a platform like StackOverflow. I did it today for the first day on my system because I did not know the root password. That’s all.

MySQL und Python
Zählen, wie viele Einträge es gibt

MySQL und Python
Zählen, wie viele Einträge es gibt

Was ist MySQL? MySQL ist wie ein gut organisiertes, digitales Bücherregal für Informationen. Stell dir vor, jede Schublade in diesem Regal ist eine Tabelle, in der du bestimmte Arten von Daten speicherst, zum Beispiel alle deine Kontakte oder alle deine Blogartikel. Anders als bei der flexiblen Schubladenkommode MongoDB, hat jede dieser Tabellen feste Spalten für bestimmte Informationen, wie Name, E-Mail oder Artikelüberschrift. So sind alle „Zettel“ (Datensätze) in einer Tabelle gleich aufgebaut. MySQL hilft dir, diese Informationen ordentlich zu speichern,…

Weiterlesen Weiterlesen