Recent questions tagged MySQL

0 votes

2.3k views

1 answer

mysql - Django - installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3

I've trawled the forums but cannot find an answer or even any documentation on this. Trying to re-create a ... have got stuck at this point. See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - Detecting locked tables (locked by LOCK TABLE)

Is there a way to detect locked tables in MySQL? I mean tables locked by the LOCK TABLE table WRITE/ ... current locks from get_lock instead.) See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

mysql - Remote connect to clearDB heroku database

How can i perform a remote connect to ClearDB MySQL database on heroku using for example MySQL Query Browser. ... port, login and password? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - Python: MySQLdb and "Library not loaded: libmysqlclient.16.dylib"

The setup... Trying to set up a clean Mac os X 10.6 install to develop python/django and I didn't ... Ruby not too many with Python tho. See Question&Answers more detail:os...

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

0 votes

2.3k views

1 answer

mysql - How accurately should I store latitude and longitude?

I was reading this question here: What datatype to use when storing latitude and longitude data in SQL databases? And it ... .xx = .6 miles etc? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

mysql - Getting data for histogram plot

Is there a way to specify bin sizes in MySQL? Right now, I am trying the following SQL query: select total, ... procedure would be fine as well. See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

mysql - mysqld_safe Directory '/var/run/mysqld' for UNIX socket file don't exists

While starting mysql server 5.7.17 using mysqld_safe, following error occcours. 2017-02-10T17:05:44.870970Z mysqld_safe ... How to fix it ? See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

mysql - Invalid default value for 'create_date' timestamp field

I have the following sql create statement mysql> CREATE TABLE IF NOT EXISTS `erp`.`je_menus` ( -> `id` INT ... ' What is the error here? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Show constraints on tables command

I have tables that I've tried setting PK FK relationships on but I want to verify this. How can I ... tables are practices and cred_insurances. See Question&Answers more detail:os...

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

0 votes

2.4k views

1 answer

mysql - How to escape single-quote (apostrophe) in string using php

I have a SQL query like this:- $stmt = $pdo->prepare( "SELECT * FROM `products_keywords` WHERE `product_type` ... my query. Thanks in advance. See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

mysql - php password_verify() hash and pass won't match

I store my passwords in my database hashed with password_hash(), and I am trying to verify the passwords on ... advice would be very helpful. See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

mysql - sql join tables where 1 column has comma

how can I get all usernames when I search "new1" .For eg: I should get A and B as userids 1,2 in tblC ... userids FROM substr(tblC.userids,',')) See Question&Answers more detail:os...

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

0 votes

17.3k views

1 answer

mysql - php warning mysql_fetch_assoc

I am trying to access some information from mysql, but am getting the warning: mysql_fetch_assoc(): supplied argument ... ); return $result; } See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - ColdFusion Parameterizing a Query

I have a query that I run to populate a CFChart that I am trying to parametrize: <cfquery name="total" ... anyone shed some light on this? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - How to bind SQL variables in PHP?

I want to bind variables instead of just building SQL strings. Anyway to do this in Php? Either MySQL or PostgreSQL answers would help. Thanks See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

mysql - Greatest value of multiple columns with column name?

I have explored many questions and answers regarding how to return the greatest values from multiple columns along with ... value? Any ideas? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - How do I construct a cross database query in PHP?

In our last episode (How I constructed a cross database query in MySQL) I learned how to construct a cross database ... ) doesn't work for me. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - How to select one row randomly taking into account a weight?

I have a table which looks like that: id: primary key content: varchar weight: int What I want to do is ... queries it's not a problem. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Table is 'read only'

When I want to execute an update query on my table I got an error saying: 1036 - Table data is read only. ... there anything I can do with that? See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - SQL SELECT to get the first N positive integers

I need to get a result set containing the first N positive integers. Is it possible to use only standard SQL ... MySQL way to achieve this? See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

mysql - Foreign key to one of many tables?

The usual way of setting a foreign key constraint is to choose which table the foreign key will point to. ... both MySQL and PostgreSQL. Thanks See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Return a default value if single row is not found

I have the following select statement to grab the next scheduled item for a stream. If there is no matching ... return a default value instead? See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Remove duplicate rows leaving oldest row Only?

I have a table of data and there are many duplicate entries from user submissions. I want to delete all duplicates ... unique IDs for each row. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Second SELECT query if first SELECT returns 0 rows

I am trying to speed up a PHP script and I am currently pushing some PHP logic in the Mysql domain of the thing. ... proxies WHERE A='C' END IF See Question&Answers more detail:os...

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

0 votes

1.9k views

1 answer

mysql - How to get multiple records against one record based on relation?

I have two tables Organisation and Employee having one to many relation i.e one organisation can have multiple employees. ... , Emp2, Emp3..... See Question&Answers more detail:os...

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

0 votes

1.8k views

1 answer

mysql - How to lock a single row

I have a user table with field lastusedecnumber. I need to access and increment lastusedecnumber. During that ... table type is MyISAM. See Question&Answers more detail:os...

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

0 votes

2.0k views

1 answer

mysql - Count number of unique values

If I have three columns: orderNumber, name, email and I would like to count how many unique emails are in the ... me the numbers I am expecting. See Question&Answers more detail:os...

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

0 votes

2.1k views

1 answer

mysql - Use Composite Primary Key as Foreign Key

How can I use a composite primary key as a foreign key? It looks like my attempt does not work. ... pk_filesName PRIMARY KEY (files_name) ) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags