Recent questions tagged mySQL

0 votes

937 views

1 answer

mysql - mysqldump: Got errno 32 on write

I used this script for years on my VPS. And it's still working. DBLIST=`mysql -uroot -pROOT_PASSWORD -ANe" ... mysqldump: Got errno 32 on write See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

406 views

1 answer

mysql - Using ElasticSeach as primary source for part of my DB

I have seen many similar question to this topic (including this one, which talks about how ElasticSearch ... would appreciate any advice. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

616 views

1 answer

mysql - GROUP BY for continuous rows in SQL

Given the following table: ID State Date 12 1 2009-07-16 10:00 45 2 2009-07-16 13:00 67 2 2009-07-16 14: ... I didn't find a solution so far... See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

594 views

1 answer

mysql - setting mamp ports to 80 and 3306

I have both apache and mySQL running with the default MAMP ports (8888 and 8889 respectively) and everything ... potential problems be? Thanks See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

560 views

1 answer

mysql - SQL - Give me 3 hits for each type only

I have some kind of impossible request :). I have a table where one of the columns is named type. I ... string2 2 CCCC string2 4 DDDD string2 See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

672 views

1 answer

mysql - Get the generated uuid after insert php

i have a table field type varchar(36) and i want to generate it dynamically by mysql so i used this ... immediately after inserting the record ? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

635 views

1 answer

mysql - SQL - Create view from multiple tables

I have three tables: POP(country, year, pop) FOOD(country, year, food) INCOME(country, year, income) I am ... the above code will not work. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

652 views

1 answer

mysql - natural key vs surrogate key an innodb foreign key

A question: I have 2 tables: Product id INT name VARCHAR(64) something TEXT else INT entirely BOOL and ... keys? What is your opinion? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.3k views

1 answer

mysql - Storing base64 encoded data as BLOB or TEXT datatype

We have a MySQL InnoDB table holding ~10 columns of small base64 encoded javascript files and png (<2KB size) ... debate for this specific case? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

604 views

1 answer

mysql - Creating view across different databases

If I have database D1 and database D2, and table T1 under database D1 and table T2 under database D2, is ... databases are on the same machine. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

920 views

1 answer

mysql - Delete statement in a same table

I need to query a delete statement for the same table based on column conditions from the same table for a ... be highly appreciated. Thanks. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

721 views

1 answer

mysql - mysqlimport: Error: 1045, Access denied

Does anyone know why I get this error when running mysqlimport? mysqlimport -u someone -pwhatever --columns=a,b,c,d,e ... set (0.00 sec) mysql> See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

754 views

1 answer

mysql - How to select sum -or- 0 if no records exist?

I need to write a query that returns the sum of all values that meet a certain criteria, but the query ... someone explain if this is possible? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

713 views

1 answer

mysql - Php addslashes sql injection still valid?

I know "parameterised queries" is the holy grail. This is not the topic. There is an old post, that seems to be the ... I use -- or # it works. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

546 views

1 answer

mysql - Cohort analysis in SQL

Looking to do some cohort analysis on a userbase. We have 2 tables "users" and "sessions", where users and sessions ... 2013-01-17 08:00:00') See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

680 views

1 answer

mysql - How do I delete duplicate rows and keep the first row?

I made a mistake and I have unwanted duplicates. I have a table with 4 key fields. A1, k1, k2, k3. A1 ... delete the rest of each duplicate set. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

749 views

1 answer

mysql - Unable to generate difference from liquibase gradle plugin

I'm trying to implement liquibase in an existing SpringBoot project with MYSQL database. I want to be ... com/liquibase/liquibase-gradle-plugin See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

588 views

1 answer

mysql - Access Denied when opening phpMyAdmin

What could be the problem of my mysql database server in WAMP. I can't open it. The error says: MySQL said: ... s not the conflict. Please Help. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.1k views

1 answer

mysql - How to avoid jobs DB table locks issue when using Laravel queues?

I'm using Laravel 5.1. The queues are used for data fetching/syncing between several systems. I use the ... algorithm in any other way. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

645 views

1 answer

mysql - SELECT vs UPDATE performance with index

If I SELECT IDs then UPDATE using those IDs, then the UPDATE query is faster than if I would UPDATE using the ... : the a column is indexed. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

1.2k views

1 answer

mysql - How to round a time to the nearest 15 minute segment

How can I round times in MySQL to the nearest 15 minutes (e.g. 0,15,30,45)? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

918 views

1 answer

mysql - mysql2.so: libmysqlclient_r.so.15: cannot open shared object file: No such file or directory

I am trying to run a Rails two app with Ubuntu 10.04 server, sphinx, myql2 version 0.2.7 and percona server 5.5 ... :47 mysql How can I fix it? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

588 views

1 answer

mysql - cURL and PHP displaying "1"

I have a PHP script with which I want to read servers from database and connect to them with cURL. Servers ... $mysql_id1); ?> Please help me See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

821 views

1 answer

mysql - Installing mysql2 gem for Ruby on Rails with Mac OSX 10.6

I am having a problem installing the mysql2 gem. This comes up when I do gem install mysql2: Marks-MacBook- ... sources listed in your Gemfile. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

813 views

1 answer

mysql conditional insert - if not exists insert

Is there a query that will just check for the record and if it doesn't exists insert? I don't want to ... ', id=12345) INSERT INTO table_name See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

837 views

1 answer

mysql - JOIN and GROUP_CONCAT with three tables

I have three tables: users: sports: user_sports: id | name id | name id_user | id_sport | pref ---+------- ... to do a nested query? Any ideas? See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

720 views

1 answer

mysql - Connect to MariaDB from Java application in NetBeans on Linux (Mageia)

I am trying to connect to a database in Mariadb through a simple java application but the connection is told to ... Please help me through this. See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

0 votes

542 views

1 answer

mysql - select from one table, count from another where id's linked

heres my code: $sql = mysql_query("select c.name, c.address, c.postcode, c.dob, c.mobile, c.email, count(select * from ... /td> </tr> <?php } ?> See Question&Answers more detail:os...

asked Oct 24, 2021 in Technique[技术] by 深蓝 (71.8m points)

Categories

Just Browsing Browsing

Most popular tags