Category "mysql"

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

getting error while trying to make put request to mysql in nodejs

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=

phpmyadmin : Depends: php-twig (>= 2.9) but 2.6.2-2 is to be installed. WHAT?

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

Update column "total price" in orders table using other columns (pizza_price*pizza_amount) in different tables?

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

How to index a text field or make it searchable in MySQL?

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

SQL statement not giving me desired output when i do not have a certain column

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

MySQL/PHP - Web Based Game -User specific inventory table or 1 giant table? Another option?

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 can we check if a column exists on Table in MySQL without using Stored Procedure

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 get this message in MYSQL in Windows: Target host is configured as Windows, but seems to be a different OS. Please review the connection settings

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