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...
9 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...
9 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 ...
9 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...
9 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...
9 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 ...
9 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('...
9 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...
9 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.
9 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...
9 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...
9 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 ...
9 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...
9 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 ...
9 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...
9 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_...
9 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...
9 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...
9 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 ...
9 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...
9 months ago