Category "mysql"

Get unique values of a field and prints its length

Table Name: Worker, Fields : worker_id | first_name | last_name | department I have a table name worker and i wanted to write an SQL query that fetches the uni

Return Default value if no row found

I'm building query to search multiple rows from database like SELECT * FROM table1 WHERE col1 = '012311' OR col1 = '0123631' OR col1 = '091233'

java.sql.SQLSyntaxErrorException: Unknown column 'id' in 'where clause'

excuse me, this is the first time I have asked a question on this platform. I am generating a code in Java to be able to make a query in a database, but when I

Why use GTIDs in MySQL replication?

When it comes to database replication, what is the use of global transaction identifiers? Why do we need it to prevent concurrency across the servers? How is th

How do I create a mysql table using a variable name in Python?

I've tried to use the article Python MySQLdb execute table variable as an example, but so far no joy. I'm trying to create a table whose name is a concatenation

Cannot uninstall mysql-server-8.0

after installing mariadb with mysql already installed, i had issues and mysql wasent working so i tried to uninstall mysql and the package broke. after frustrat

Cannot uninstall mysql-server-8.0

after installing mariadb with mysql already installed, i had issues and mysql wasent working so i tried to uninstall mysql and the package broke. after frustrat

How to improve my tables and queries for Big Data applications?

I created an API on Symfony which produces more than 1 million entries by day into one of the MySql tables. This table structure is defined this way: After s

Сan't automatically connect to RDS via the script on EC2?

Im use terraform to create infrastr. in AWS. I'm using script on ec2 userdata, that connects to rds.But this script doesn`t work. #! /bin/bash yum update -y yu

How to display MySQL table using php and edit it in a web browser

i am using a while loop to display all the data in my MYSQL table. the problem is that its not showing the newest entry. after adding a record it does not show

AWS Aurora MySQL serverless: how to connect from MySQL Workbench

I was trying to use AWS Aurora Serverless for MySQL in my project, but I am impossible to connect to it, though I have the endpoint, username, password. What I

ServiceStack.OrmLite: Can custom naming of index be done in code?

(I'm running ServiceStack OrmLite 5.1.1) I happen to have a few objects that has a long name, and creating the table as it is setup now creates a table with a l

Error calling Python module function in MySQL Workbench

I'm kind of at my wits end here, and so far have had no feedback from the MySQL Workbench bug reporting site, so I thought I'd throw this question/problem out t

Python mysql-connector hangs indefinitely when connecting to remote mysql via SSH

I am Testing out connection to mysql server with python. I need to ssh into the server and establish a mysql connection. The following code works: from sshtunne

MySQL Full Text Period

I have a table of product names, and full text works great up until using a period, e.g. searching for a 3.7 battery.. i try select .. where match(name) agains

http://localhost:80 is not working on running Apache server through UniServer ZeroXIII

I am unable to configure a PHP/MySQL/Apache environment on my local machine using UniServer ZeroXIII. In my Uniserver ZeroXIII control panel the Apache and MyS

How to use wireshark to capture mysql query sql clearly

Because we develop using remote Mysql server , so cannot check query sql easily, if use local server you can tail - f general_log_file to see which sql are exec

How to create a new table in a MySQL DB from a pandas dataframe

I recently transitioned from using SQLite for most of my data storage and management needs to MySQL. I think I've finally gotten the correct libraries installed

I am getting 'System.Web.UI.WebControls.TextBox' into sql table instead of getting actual data entered in text boxes

Can someone please help me figure out why I am getting 'System.Web.UI.WebControls.TextBox' in MySQL database instead of actual values being entered in the text

Error : Cannot use identity column key generation with <union-subclass> ( TABLE_PER_CLASS )

I am using Hibernate to save entities where all entities are inherited from a base abstract entity. For all concrete Entities there are database tables respecti