sql tag

625 questions


1 answers
43 views
0
Want to run the master nondisruptively when replicating with MySQL

https://dev.mysql.com/doc/refman/5.6/ja/replication-howto-masterstatus.htmlWe are proceeding with the replication by referring to the above URL, but it was written that you should type the following c...

2 years ago

2 answers
47 views
0
PHP undefined index error

I have created columns such as name and pw in the MySQL user table.Undefined index:name when running PHP belowI get the error, but I don't know the cause.The pw has been correctly determined.$ps=$db-&...

2 years ago

1 answers
39 views
0
I only want to count people below a specific number in SQL by month

I am a beginner in SQL.I'm sorry for the rudimentary question, but I'd appreciate it if you could let me know.I'd like to count only people with number 90 or less by month.Could you tell me the syntax...

sql
2 years ago

1 answers
110 views
0
I want to connect to postgresql from perl file and get results

I'm using the perl file pg (is it like including?) and doing pg::connectdb, but I'd like to check the return value of SQL.# begin.$conn=Pg::connectdb(host=$hostport=$portdbname=$dbname user=$user);$re...

2 years ago

2 answers
120 views
0
I want the Term display to be the default sjis

The Japanese data in DB (PostgreSQL) is sjis when connected to each server by ssh from TeraTerm, but you have to set set client_encoding to 'sjis' every time to display Japanese.I'd like to not set th...

2 years ago

2 answers
104 views
0
The order of records (id) in the table will be changed after bulk update in the Rails app's Activerecord.

We have made a new registration as follows.After that, I pressed the Edit button to change the product name from Product B to Hogehoge.2 Stainless Steel BF-078 10K 350A 3P 2,000 3,000 4,000 9,0002 Sta...


1 answers
41 views
0
I would like to get the bottom 5 items from the top in mysql.

It's just like the title says. select * from column order by created desc limit 5;If you do this, of course it will be displayed in descending order.54321appears in This is 12345I'd like to.If possibl...

2 years ago

1 answers
140 views
0
Ambiguous search LIKE statements do not hit

I used the postgreSQL LIKE statement in the ORM called gorm in the Go language, but somehow I can't get the data.The model is assumed to be: type Model structure { ID int Name string Phonetic string...

2 years ago

1 answers
108 views
0
Understanding How Good Features Work with mysql

We are currently making SNS and are trying to implement the functions of the Good Button.If you want to use mysal to implement good functionality in the databaseIt seems that a large amount of insert ...

2 years ago

1 answers
44 views
0
PHP does not create a successful login session

I am currently making a simple bulletin board with PHP.Therefore, when I press the edit button from the post list page, I would like to add a function that allows me to jump to the edit screen if I am...

2 years ago
« - 21 - »

© 2024 OneMinuteCode. All rights reserved.