How to create a column name with space in SQL Server

MySQL
I want to create a column name in a table with space. In MySQL I just created this using the back ticks. But in SQL Server it was show an error. Is th...
11 months ago

Does Citus support creating shards using mysql_fdw?

MySQL
The Citus documentation for the master_get_table_metadata function states: part_storage_type: Type of storage used for the table. May be ‘t’ (stan...
11 months ago

How can I do a self-join based on a related column?

MySQL
I have this table: // mytable +----+---------+---------+ | id | related | color | +----+---------+---------+ | 1 | NULL | red | | 2 | 1 ...
11 months ago

How to group continuous ranges using MySQL

MySQL
I have a table that contains categories, dates and rates. Each category can have different rates for different dates, one category can have only one r...
11 months ago

connecting to a docker-compose mysql container denies access but docker running same image does not

MySQL
I am having some issues connecting to the mysql docker container that I have launched with docker-compose. This is a long post (sorry!). Here is my d...
11 months ago

Insert into table cannot be done PHP/mySQL

MySQL
I want to insert values into a database table but for some reason it cannot be done.I checked the code millions of times but it is impossible to find ...
11 months ago

MySQL not returning null column joined value

MySQL
I have these 4 tables: My expected result: this my current query (helped from here) select a.No_Registrasi, a.Nama_CTKI, b.Nama_Negara, CONCAT('...
11 months ago

Combine two Mysql SUM select query to one query

MySQL
I have below two query's SUM the values Query1:* SELECT SUM(price) FROM TABLE1 WHERE acc_id = '555' Query2: SELECT SUM(price) FROM TABLE...
11 months ago

What is the MAX number if I store int(255) in MySQL?

MySQL
I use int(255) in mysql as my id. Is this long enough? If I got about 1,000,000 records....Thank you.
11 months ago

LIKE... AND NOT... sql

MySQL
I am creating a query in which i am selecting data from multiple tables, however, i do not want to select the entry that my users are currently viewin...
11 months ago

Automated database restore from *.sql files

MySQL
I am trying to write a python script with which to restore our database. We store all our tables (individually) in the repository. Since typing "sourc...
11 months ago

GROUP BY in a Multiple SELECT

MySQL
Say I have four tables with the same format: Registered | Score ---------------------- 0 | 10 1 | 5 1 | 7 0 ...
11 months ago

Error when update the tables with PHP

MySQL
this is the problem `You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to us...
11 months ago

Finding Query that Triggered a Trigger

MySQL
Is it possible with a trigger to get the query or primary id of the query that triggered it? Currently we roughly have: Delete from Table1 where id ...
11 months ago

Can not get second table value in inner join in CakePHP

MySQL
I am working in CakePHP framework. I want to join two tables. So I have written query like below. $details=$this->Deal->find('all',array('joins...
11 months ago

What is the difference between "utf8_unicode_ci" and "utf8_unicode_520_ci"

MySQL
I recently upgraded my WAMPServer, and now in phpMyAdmin, I see both collations utf8_unicode_ci and utf8_unicode_520_ci. I normally use "utf8_unicode_...
11 months ago

mysql most popular page in 5 minute intervals

MySQL
I have a MySQL table "page" that contains fields "page_name" and "page_timestamp". The table stores page and times requests that were made on a websit...
11 months ago

Edit MySQL Row PHP

MySQL
I'm trying to edit and update a row using PHP. Here is the code: index.php <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "h...
11 months ago

pyspark mysql jdbc load An error occurred while calling o23.load No suitable driver

MySQL
I use docker image sequenceiq/spark on my Mac to study these spark examples, during the study process, I upgrade the spark inside that image to 1.6.1 ...
11 months ago

Why call session not working? (codeigniter 3)

MySQL
my config is like this : $config['sess_driver'] = 'database'; // select database driver $config['sess_save_path'] = 'ci_sessions'; // name of the m...
11 months ago