Category "mysql"

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

How to increase the PHP upload limits [duplicate]

When i try to upload database it comes an error saying: You probably tried to upload too large file. Please refer to documentation for w

MYSQL query between two timestamps

I have the following entry in my DB table eventName(varchar 100) -> myEvent date(timestamp) -> 2013-03-26 09:00:00 and I am trying to use the following

(Incorrect integer value: '' for column 'IdSkjell' at row 1)

Hey everyone i have searched for this but i dindt find the right answer just the topic. So i cant find out what the problem is in my code. (Incorrect integer v

PDOException SQLSTATE[HY000] [2002] No such file or directory

I believe that I've successfully deployed my (very basic) site to fortrabbit, but as soon as I connect to SSH to run some commands (such as php artisan migrate

Set SQLAlchemy PickleType Column Size

I am trying to save a python list to an SQL table in a PickleType column which is defined in the class object as text = Column(PickleType). When I try to commit

Django 3.2+: implementing case-sensitive string comparisons within MySQL tables

Django documentation (3.2 to 4.0) states: In MySQL, a database table’s collation determines whether string comparisons (such as the expression and substr

MySQL error: Illegal mix of collations for operation 'UNION'

I am Boxonix! I am currently making a comment section for my website, and I'm tiny a bit in trouble! This "Illegal mix of collations for operation 'UNION'" pops

Dependency error while installing mysql workbench on ubuntu 12.04

I am trying to install mysql workbench. I am getting below error. It seems that it looks for mysql in some default directory. I have all the required things ins

Select option from dropdown menu with PHP and mySql

I tried to create a simple select dropdown menu from MySQL database. However, it does not work on my code. Here is my code: <?php

Node Mysql is breaking node app entirely

For some reason, my node app (specifically the node module) is getting a "Too many connections" error that I can't figure out what is actually causing it, but r