sql tag

625 questions

1 answers
45 views
0

About postgresql :::bpchar に

Hello, let me ask you a question.I am re-pasting the index of a table.table_name_login_idx btree(login) WHERE sex='m':bpcharWhat does this :bpchar mean?Sex is character(1).Please give me guidance.

postgresql

1 years ago

1 answers
73 views
0

DIFFERENT DATABASE TABLE COUPLING METHOD USING PDO

I don't know how to combine tables of different databases in the same server using PDO class, so I would appreciate it if you could give me some advice.The development language is PHP and the database...

php mysql pdo

1 years ago

1 answers
35 views
0

Under Update MySQL

If you have the following data:If the parent id is the same and the amount is NULL, you can rewrite it to something that is not NULL.What should I do?I look forward to hearing from you.From this state...

mysql

1 years ago

1 answers
42 views
0

To run mysql 5.6 on a Docker centos:centos6 image

I would like to have my new Rails project run on DockerToolbox.The Rails version is 4.0.0.#...set up abbreviated Docker Toolbox...$ git clone path /to /repository.git project$ cd project# Install gem$...

ruby-on-rails mysql docker

1 years ago

1 answers
42 views
0

a method of calculating the power of a scale

What I want to do in the end is I want to make a table of normal distribution cumulative functionsIn order to do this, Error function must be calculated.There's a factorial calculation in it, but it's...

mysql

1 years ago

1 answers
88 views
0

After accessing a URL without a query parameter, I want to automatically skip it to the URL with the query parameter attached.

■ What you want to do (overview): After accessing a URL without a query parameter, I want to automatically skip it to the URL with the query parameter attached.■ What you want to do (details): 1. Curr...

php mysql apache .htaccess

1 years ago

1 answers
35 views
0

The destroy of the data with the foreign key is not successful, and even if you add the dependent option, you will get an error.

When I delete a post model record, I want to delete a comment model record associated with it, but I get the following error.Currently, if there is no comment, it can be deleted normally.If anyone und...

ruby-on-rails mysql

1 years ago

1 answers
44 views
0

Cake is stuck in query setup.(I want to display the latest date of the month.)

Hello, I'm a beginner at cake.I have a question because I am stuck with the query settings.Here's what you want to do:Displays the most recent date of the month.I am writing a custom query as follows:...

php mysql cakephp

1 years ago

1 answers
102 views
0

Unable to Remotely Connect to MySQL

Unable to connect to MySQL remotely.We have two AWS lightsail instances (Ubuntu 14.04.5) and are trying to connect from one to the other.Both versions of MySQL are 5.6.35.The last thing I want to do i...

mysql ubuntu network unix

1 years ago

1 answers
44 views
0

How do I store date data in DB after aggregating it in SQL (with SQL in this part)?

RubyonRails implements the process of aggregating (by time) articles.Currently, I would like to run SQL such as the following, save the aggregated results to DB, and display them on the web screen.SQL...

ruby-on-rails ruby mysql sql

1 years ago

- 32 -

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