sql tag

625 questions

1 answers
134 views
0

garbled characters in PHP+MySQL are not fixed

BackgroundWe have decided to transfer the original system from one server to another.Exportmysqldump-u root-p DBNAME --default-character-set=binary>~/DBNAME.sql importI imported it using phpMyAdmin...

php mysql garbled-characters

2 years ago

1 answers
42 views
0

mysql Summarize multiple select statements

Would it be possible to combine the following two select statements into one?select name, img, price from items where id=:requestselect item_title from categories where id=:requestPlease let me know i...

mysql

2 years ago

1 answers
96 views
0

I want to put multiple unique constraints on a single column in Gorm

I'd like to place multiple unique constraints on a single column in Gorm.typeObject structure{ Z string `gorm: unique_index:unique_a;unique_index:unique_b` A string `gorm: unique_index:unique_a` B str...

mysql go gorm

2 years ago

1 answers
40 views
0

Understanding PL/SQL Cursors

When I try to join and insert SQL using the cursor, I get an error saying, To avoid duplicate column names, I need another name in the cursor's SELECT list.Why is that?Is there something wrong with th...

sql

2 years ago

1 answers
82 views
0

I want to update with Node+MySQL using a placeholder.

I would like to get the MySQL table information as below and sort the process by pressing button.However, if there are two placeholders, such as updatesql, I don't know how to specify them on the node...

javascript html mysql node.js

2 years ago

1 answers
52 views
0

CPU utilization periodically drops to 0%

I'm having trouble with the timing of the site's very poor response.The frequency is several times per minute.It's only been three days since it was released, so there's very little access.The top com...

ruby-on-rails ruby mysql aws

2 years ago

1 answers
54 views
0

To detect eyes instead of using the group by clause in php/mysqli

Sorry for the rudimentary question.(Content) | (Date) A|September 29, 2015B | September 29, 2015C | September 28, 2015 and the database, and I'd like to index the output by date.What is the best pract...

php mysql

2 years ago

1 answers
74 views
0

Search for exact matches to JSON in MySQL

MySQL 5.7 and later contain the following table JSON:CREATE TABLE `p`( `id`int(11) NOT NULL AUTO_INCREMENT, `parameter`json NOT NULL, PRIMARY KEY (`id`)ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=l...

mysql sql json

2 years ago

1 answers
41 views
0

MySQL can connect with localhost, but 127.0.0.1 can't connect

mysql-uroot-pIf so, it becomes root@localhost and you can connect, butmysql-uroot-p-h 127.0.0.1Access denied for user 'root'@'127.0.0.1' (using password:YES)Unable to connect next to What I want to do...

mysql

2 years ago

1 answers
47 views
0

I want to use the hstore type in postgresql.

EnvironmentCentOS Release 6.8I installed it with contrib...yum, but the folder contrib is not created in pgsql.When you type the psql command, psql (8.4.xx, server 9.1.xx) appears.Is the postgresql ve...

sql postgresql

2 years ago

- 34 -

Popular Tags

python x 4647

android x 1593

java x 1494

javascript x 1427

c x 927

c++ x 878

ruby-on-rails x 696

php x 692

python3 x 685

html x 656