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
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
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
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 documentation (3.2 to 4.0) states: In MySQL, a database table’s collation determines whether string comparisons (such as the expression and substr
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
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
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
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
I try to connect MySQL database with Java using connector 8.0.11. Everything seems to be OK, but I get this exception: Exception in thread "main" java.sql.SQL
I am trying to implemnt CDC piline with Debezium mysql connecter and kafkal But Source connecter not able to pusblish event for insert and update operation in t
Is there a way to check if multiple values exist in the same in clause, without rewriting the same IN clause? Example Employee Table: +----+--------------+--
I want to query the list of CITY names from the table STATION(id, city, longitude, latitude) which have vowels as both their first and last characters. The resu
I am executing this query with core cron by custom Wordpress plugin: // MAKE SQL CALL $SQL = "SELECT ".$wpdb->prefix."postmeta.post_id FROM ".$wpdb->
i wanted to insert all available ookla servers into my data base for the speed test purpose for my android application. But i am not getting any way to find out
I have this query: SELECT * FROM (SELECT a.id AS id, a.user_id AS user_id, aa.power * a.amount AS total_power, a.group_number A
I am upgrading my django project from django1.5 to django1.11.10. while upgrading when I run ./manange.py migrate I am getting django.db.migrations.exceptions.N
I tried to create a table this way: create table attendance ( userId char(10) primary key not null, name varchar(35) not null, date_attenda
From my syslog: mysql[1663]: ERROR 1577 (HY000) at line 1: Cannot proceed because system tables used by Event Scheduler were found damaged at server start I
I am developing a PhoneGap application that gets some information from MySQL Database. I am struggling when I try to open a HTML page that contains two select i