sql tag

625 questions

3 answers
116 views
0

How do I set the primary key when I insert a record in SQL server?

I'd like to insert a record in SQLserver, but I'm worried about how to set the main key.I used to use max (main key) +1, but with this method, when multiple processes are inserted at the same time, Yo...

sql sql-server

2 years ago

1 answers
66 views
0

Learn how to view data retrieved from Web SQL using AngularJS

I am having a hard time displaying the data obtained from Web SQL using AngularJS.If you know the solution, could you please let me know?↓page1.html<ons-page id=page1> <div ng-controller=hoge...

monaca onsen-ui angularjs web-sql

2 years ago

1 answers
123 views
0

Test data generation using Rails Faker

I'm developing it at Ruby on Rails.I use Fakergem to put test data in DB(mysql).https://github.com/stympy/faker I was able to put in most of the data, but there are some things that I can't do with th...

ruby-on-rails mysql rubygems

2 years ago

1 answers
139 views
0

When registering an address on the table, the letter "-" becomes "?"

It's the same as the topic.When saving your address: The letter '-' should be '?'My MySQL database character code is SJIS.JDBC extracts the address data from Table A and stores it in Table B.But when ...

java mysql encoding

2 years ago

1 answers
45 views
0

I want to use Rails migration to determine if there is a primary key.

I'd like to create a migration where PKs that only exist in production can be created in a different environment.https://api.rubyonrails.org/classes/ActiveRecord/Migration.htmlThis feels like PK-relat...

ruby-on-rails mysql

2 years ago

1 answers
45 views
0

I want to resolve ERROR 1045(28000) in mysql

I am learning mysql from dotinstall, but I have stopped with the following error:I want to clear the error below and connect to mydb01, but I don't know how to do that.I gave mydb01 permission to a us...

mysql

2 years ago

1 answers
49 views
0

Regarding the replacement of the .da file, mac

I'm making a simple bulletin board with dot installation.http://dotinstall.com/lessons/bbs_php_v2/24503It's like writing data to a .dat file during a video.I can't open the .dat file itself with a mac...

php mysql

2 years ago

1 answers
57 views
0

How do I modify the SQL syntax to have the same word count as 1 in the post?

As shown in the code below, the total of multiple strings such as delicious and delicious in the body column of the DB table can be displayed on the Blade, but if there are multiple words such as deli...

php mysql laravel

2 years ago

1 answers
61 views
0

Can connect to AWS aurora via psql, but cannot insert

I would like to install only the postgresql client on Amazon Linux and connect to Aurora for use.Aurora is postgresql. psql-host-database-U usernameYou can also connect and select from the .However, w...

aws postgresql

2 years ago

1 answers
58 views
0

Understanding How to Write the On Intra-Clause Primary Key During Self-Coupling

Nice to meet you.I have just learned SQL.I started studying using an overseas practice site, but when I was solving the questions in the link below, I came up with a question.https://pgexercises.com/q...

sql postgresql

2 years ago

- 17 -

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