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
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 ?
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
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
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
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
I am getting this error while I am trying to send a put request to update a row of a product table in mysql using nodejs. Here's my code: exports.updateProduct=
I need help figuring out what's wrong. I want to install phpmyadmin on a server to import a wordpress DB but when I install it I have a problem with php-twig I
This is relational diagram of database I created: I need to insert total price in Orders.Total_Price column by multiplying the Pizza.Pizza_Price value with Ord
I have stored about 7 million biological protein sequences in text field of MySQL table (using InnoDB storage engine and latin1_swedish_ci collation). Sequence
I am trying to retrieve these values from mysql table using this statement in my node.js SELECT product.name, product.image, product.description, prod
So im making a web based game similar to Torn City, where there could potentially be millions of users. My issue is regarding user inventories. I started out cr
how we can check if a column exists on Table in MySQL without using Stored Procedure. MySQL v3.23 which won't support writing Store Procedure.
I'm trying to set a MySQL Database in my pc for development. Of course I've tried to change the OS None of this options made it work. Although when I hit the
I get the error Doctrine\DBAL\Schema\SchemaException : There is no column with name 'price' on table 'class_rooms'. while running migration to rename the price
I want to export some data from the DB. Basically what I want to say is this: 1- Select mbr_name from the members table 2- Choose the ones that exist at the cou
Is it possible to prevent changesets without a label from being deployed? We want to deploy our changesets based on feature/ticket using liquibase labels. Howev
I need to process a queue and MySQL for update is the goal for that. Everything is working fine, except the fact for update is locking joined tables too. I have
I need to calculate weekends of time range using MySQL. This is what I have so far(about calculate working days but i want to calculate weekends): select (f
i want to ask you how to select FOREIGN KEY (from "doa_id in "doas" table) when user create a new data (to the "notes table) in a form. This is my code : NoteCo