Category "mysql"

how can i make my database er diagram to code?

I've made this ER diagram for my college project but i have to use forward engineering to see SQL code. MySQL version is 8.0.27 when i try it, it come up with e

How to access an external database source in a TYPO3 10 module?

Within a TYPO3 10 extension I would like to access an external MySQL-database that contains a table with two fileds like "name" and "firstName". For this I adde

mysql with date function query running slow

I found something weird while executing query today and i want to know how this happens. Below is my query: select sum(price) as total from table_a where test

MySQL Run SQL Script Error says "'ascii' codec can't decode byte 0xe2 in position 2386: ordinal not in range(128)"

My setup: late 2018 MacBook Air macOS Big Sur 11.5.2 MySQL 8.0.26 Community Edition I am trying to run an SQL file I downloaded by doing File > Run SQL Scrip

Let Join C++ MYSQL library

I'm trying to access "category" table with LEFT JOIN. I need to retrieve the field "name" in this table. This is my code: void Product::read(MYSQL *connection)

SQLAlchemy: JOIN between different databases AND using different files in a module

Stack I am using: Python 3.10.x FastAPI 0.75.x SQLAlchemy 1.4.3x Summary I am building a unifying FastAPI project for several legacy databases (stored back-end

Is InnoDB index constructed in cache or disk?

I'm trying to understand InnoDB indices, but have some confusion. Are InnoDB indices (Clustered and Secondary) constructed only in cache or constructed in disk

ERROR: ALGORITHM=INSTANT is not supported for this operation. Try ALGORITHM=COPY/INPLACE

I have used mysqldump to create a table that is 12GB from MySQL 5.7 to MySQL 8.0.29. I want to add a column using ALTER TABLE documents ADD COLUMN meta_data jso

Show only available time slots in select field

I am working on a booking system where users can book certain services online. I am stuck on finding and displaying available time slots within a specific day.

How can I avoid warnings when importing numbers by replacing comma's with a dot in a MySQL table?

I have a table in Mysql that looks like: CREATE TABLE `overig`.`test`( `ID` INT(10) AUTO_INCREMENT, `Order_ID` DECIMAL(10) NOT NULL, `Price_total` DECIMAL(12,2)

dbeaver mysql connection refused in ubuntu 20.04

I am not able to connect to mysql from dbeaver in ubuntu 20.04, I am adding the error screenshot. mysql is ruuning on machine on the below ports mysqld 5846

How to rename a partitions table with child tables

I am trying to rename parent table in partitions. I created 3 child tables on year wise manner. I can alter the name of parent table but I don't know how to alt

SQL: How to generate a unique value for a Primary Key

as the title states. I do have the following table: CREATE TABLE exampleTable( ID int NOT NULL, Text varchar(255), PRIMARY KEY (ID) ); By inserti

MYSQL and Python: Add salt after the first two characters of the password

I am working in MYSQL and Python. I have a table that stores users login information and want to make this secure. How do I add the salt after the first two cha

SQL Error [1064] [42000]: You have an error in your SQL syntax while running query

While I am trying to select a table on a MySQL data base, I am getting the following error: SQL Error [1064] [42000]: You have an error in your SQL syntax; chec

How to Change TablePress row length for admin page

I am using a TablePress of wordpress library and try to display 100 rows per page in admin account , Not user page. How can i do that ?

Does MySQL clusters support coordinator node?

I'm creating a new app and this time using MySQL instead of cassandra because it's much harder to learn and setup. I learned about MySQL clusters and chose to u

Ansible playbook to install and configure MySQL on Ubuntu

I am trying to set up MySQL reasonably secured, on Ubuntu 22.04, using Ansible. This is my playbook (from a post by Lorin Hochstein) See Ansible idempotent MySQ

How to loop sql table data inside a html table

I have a table for all orders made by users and I would like to send them their order summary in email. However I have managed to create a table showing the cu

Read information of ID causing error from Exception

In C# My Sql Entity Framework 6 Insert is return exception Cannot add or update a child row: a foreign key constraint fails (portaldb.masterselectionhistory, C