sql tag

625 questions

3 answers
68 views
0

Gem install pg fails.yum install postgresql-devel also does not resolve.

gem install pg displays the following error:I'm running EC2 and my operating system is Amazon Linux.$gem install pg-v'0.20.0'Building native extensions. This could take a while...ERROR:Error installin...

ruby-on-rails ruby postgresql amazon-ec2 amazon-linux

1 years ago

1 answers
37 views
0

Comments are reflected in all posts.

I have implemented the comment function of the posted version, but all posts reflect the comments.As I looked into various things and rewritten the code, I couldn't collect the code, so I came up with...

ruby-on-rails ruby mysql

1 years ago

1 answers
43 views
0

Call to a member function bindParam() on string

The cause of this error is unknown.I am sorry to trouble you, but I would appreciate it if you could let me know.Thank you for your cooperation.Fatal error:Uncaught Error:Call to a member function bin...

php mysql

1 years ago

1 answers
38 views
0

I only want to delete the column if the total field is 0 in MySQL.

There are multiple columns in the table, and you want to leave only one or more columns in the table.Also, I would like to change the name of the column, but I am struggling because I don't know the c...

mysql sql

1 years ago

1 answers
40 views
0

When I log in to localhost with xampp, the following screen appears.

What is the cause of this?By the way, the files saved in htdocs are displayed successfully in your browser.

php mysql

1 years ago

1 answers
30 views
0

Is the DB always connected to the same destination?

The SQL destination host name is SELECT@@SERVERNAME It seems that you can get it in Aren't all the servers connected the same?

sql

1 years ago

1 answers
34 views
0

The logical sum of negatives in the WHERE clause?

Table definitions and contentsCREATE TABLEER (`id`int,`age`int);INSERT INTER (`id`,`age`)VALUES (1, 1), (2, 2), (3, 5), (4, 7), (5, 9);Results you want to extractdid is not 3 < or 」age is not 2 では rec...

mysql

1 years ago

1 answers
42 views
0

I want to change the number added by the conditions within SQL.

Currently, we are adding the total number of pvs.id to the product.price as shown below.Below is +1 for Product.price when pvs.id total is 10, +2 for Product.price when pvs.id total is 20, +3 for Prod...

php cakephp sql

1 years ago

1 answers
116 views
0

I want to resolve MySQL boot error: 1045 with XAMPP

Currently, I am trying to install XAMPP and launch MySQL by referring to the reference book PHP that I can understand easily.ERROR1045(28000): Access denied for user '2170145' '@'localhost' (using pas...

mysql xampp

1 years ago

3 answers
85 views
0

I want to take only the top row out of multiple tables, and I want a specific column to be a total value.

There are two tables: TABLE1　myid　nameTABLE 2　id myid　countSuppose you have one TABLE1 record and three associated TABLE2s.TABLE1　myid=1 name = TaroTABLE 2　id = 1 myid=1　count = 2　id = 2 myid=1　count ...

sql database

1 years ago

- 26 -

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