sql tag

625 questions

1 answers
41 views
0

ccakephp2.9 複合 Behavior of saveAll when setting compound unique key

The table structure is as follows:CREATE TABLE `products`(`uid`int(11) NOT NULL,`item_code`varchar(255) NOT NULL,`stock`int(11) NOT NULL,`modified`datetime NOT NULL,`created`datetime NOT NULL,UNIQUE K...

mysql cakephp

1 years ago

2 answers
46 views
0

Adding data to the database in a php file?It will be marked.

If you add data to the database like this, when you display the table in mysql?It will be marked.$sql=INSERT INTO tbladdress (name, prefid, address, tel) VALUES (Serenagomez, 21, Tokyo \, 04-XXXX-9...

php mysql

1 years ago

1 answers
38 views
0

I want to group and list them in MYSQL.

I have a preliminary MYSQL question, but I would like to group them in title when there is a table like the one below and list them in order of new date.Could you tell me the SELECT statement at this ...

mysql sql

1 years ago

1 answers
94 views
0

Error around foreign key constraint when post method is performed in flash

When I tried to implement the POST method while creating the API in flash, I encountered the following error, but I am having trouble solving it.Error Contentssqlalchemy.exc.IntegrityError: (_mysql_ex...

mysql api flask

1 years ago

1 answers
99 views
0

How does VBA connect to MySQL installed in Bitnami Redmine?

I installed Redmine from Bitnami.I want to use Redmine data in Excel, so I want to use VBA to connect to MySQL to get data, but I don't know how to connect.I am thinking of connecting with MySQL ODBC ...

mysql vba bitnami

1 years ago

1 answers
37 views
0

I want to do attendance aggregation in MySQL

What do you want to doI want to get attendance, absences, lateness, and lateness (one absent out of three) from MySQL.I'd like to count the number of absences for being late (three times and one time)...

mysql

1 years ago

2 answers
29 views
0

How to use parameters when using raw SQL in Rails

I wrote the following sql using raw sql in Rails. [Like table]idaction_user_idtarget_user_idsql@user=ActiveRecord::Base.connection.select('select target_user_id, count(id) from Like where action_user_...

ruby-on-rails sql

1 years ago

1 answers
28 views
0

Creating SQL for Table Consolidation and Grouping

I'm a beginner in SQL.I have a question about number 13 on the SQL practice site below.I'm quite busy creating SQL for table consolidation and grouping, so Please tell me how to approach it.As shown b...

sql

1 years ago

1 answers
44 views
0

Unable to connect to DB server with psycopg2

Please let me know.The psycopg2 returns an error.Source code is #-*-coding:utf-8-*- import psycopg2if__name__==__main__: connector=psycopg2.connect(host=127.0.0.1, database=pdb, user=pgusr, port=532 ,...

python postgresql

1 years ago

1 answers
38 views
0

What to install with MySQL MAMP and what to boot from the terminal?

What is the difference between installing with MySQL MAMP and booting at the terminal?

mysql

1 years ago

- 35 -

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