Less than or equal to using mysql in codeigniter does not work

I have a simple query that looks like this: $backlogs=$_POST['backlogs'];$this->db->select('*');if(!empt...

From [MySQLdiscussion group] 2024-03-22 08:57:14 0  1  333

Rails created_at index unused index

I have a model called CacheSync and mysql shows it has an index: mysql>showindexesfromcache_syncs;+--------...

From [MySQLdiscussion group] 2024-03-21 23:40:41 0  1  360

MYSQL encountered syntax error 1064 (42000) when creating a new table

I'm new to MYSQL and working with many to many tables and when I try to create the table I get the following e...

From [MySQLdiscussion group] 2024-03-21 22:32:39 0  1  502

How to convert a string containing date to mysql timestamp format?

I'm working in a python environment. I have a date string like this - 26Apr202217:23:17GMT I want to insert th...

From [MySQLdiscussion group] 2024-03-21 21:09:02 0  1  482

Small latency issue after insert/update using proxySQL and MySQL Cluster

We are using MySQL Cluster with proxySQL and have the following setup: Server 1 is the main server hosting the...

From [MySQLdiscussion group] 2024-03-21 21:11:42 0  1  355

Is it possible to grant metadata permissions exclusively in MySQL?

TLDR; Goal: Is it possible to grant a certain "audit" user access to only the MySQL metadata (at lea...

From [MySQLdiscussion group] 2024-03-21 20:02:42 0  1  416

Unable to autoincrement SQLAlchemy in MySQL

I'm using MySQL8.0 and SQLAlchemy. My id column is not increasing and I don't understand why. SQLAlchemy model...

From [MySQLdiscussion group] 2024-03-21 19:08:36 0  1  341

Create backups of MySQL databases and servers

I understand MySQL database backup, but how to backup the entire MySql configuration and database? I'm buildin...

From [MySQLdiscussion group] 2024-03-20 11:11:09 0  1  387

Insert modified value of one field into new field in SQL

My problem is that I know nothing about SQL queries but need to do something that I think shouldn't be difficu...

From [MySQLdiscussion group] 2024-03-20 10:17:38 0  2  417

When trying to search a SQL database via C# based on any entered search criteria, I get an error that the input string is not in the correct format

I'm trying to search my database using a stored procedure through my program. The goal is to search using any ...

From [MySQLdiscussion group] 2024-03-20 00:15:39 0  1  462

How to get the correct sum of two columns using case when

I'm developing a program that will track the units sold by a salesperson, which can be either a full deal (1) ...

From [MySQLdiscussion group] 2024-03-19 23:49:06 0  1  453

Passwords in MYSQL are not encrypted

I'm currently trying to use bcrypt to encrypt/hash my seed passwords and store them in MYSQL, but it keeps giv...

From [MySQLdiscussion group] 2024-03-19 21:43:49 0  2  494

How to share database schema in DockerCompose files?

I'm learning Docker. I'm building an image from a Dockerfile in a counter application. And I use mysql as data...

From [MySQLdiscussion group] 2024-03-19 21:28:55 0  1  296

Encountered java.lang.ClassNotFoundException: com.mysql.cj.jdbc.Driver error, the mysql connector has been added to the reference library

publicclassConnect{publicstaticResultSetselect(Stringquery)throwsException{Stringurl="jdbc:mysql://lo...

From [MySQLdiscussion group] 2024-03-19 20:39:21 0  1  444

Prevent spaces, null values, and invalid dates in MySQL: What can I do?

用户表CREATETABLE`USERS`(`ID`char(255)COLLATEutf8_unicode_ciNOTNULL,`NAME`char(255)COLLATEutf8_unicode_ciNOTNULL,...

From [MySQLdiscussion group] 2024-03-19 20:38:50 0  1  333