Recent questions tagged MySQL

0 votes

775 views

1 answer

mysql - SQL query that returns all dates not used in a table

So lets say I have some records that look like: 2011-01-01 Cat 2011-01-02 Dog 2011-01-04 Horse 2011- ... possible to select the absence of data. See Question&Answers more detail:os...

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

0 votes

821 views

1 answer

mysql - How to count all NULL values in a table?

Just wondering, is there any quick way to count all the NULL values (from all columns) in a MySQL table? Thanks for any idea! See Question&Answers more detail:os...

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

0 votes

779 views

1 answer

mysql - Cannot run Mocha.js in synchronous mode

I am testing stored procedures with mocha running in a nodejs instance. I have this test skeleton: var chai ... becomes a nightmare to maintain. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - LOAD_FILE returns NULL

I am trying to insert an image into my MySQL server. I have done some research and it looks like the best way ... it's not returning a value. See Question&Answers more detail:os...

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

0 votes

877 views

1 answer

mysql - How to use bind_result() instead of get_result() in php

I'm working on a project for uni and have been using the following code on a testing server to get all ... Any help would be much appreciated See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - insert into table select max(column_name)+1

I have this mysql table built like this: CREATE TABLE `posts` ( `post_id` INT(10) NOT NULL AUTO_INCREMENT, ` ... gen_id and add 1 to it. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Recipe Database, search by ingredient

I have the following 3 tables in my database, and am having some trouble querying them for the results I ... help would be much appreciated! 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 convert a String to Hex and vice-versa?

As you know , in MySQL we have HEX & UNHEX, for example when I write like this : select hex("Ali"); the convert ... them ??? Thanks a lot ... See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

mysql - Why is AES_DECRYPT returning null?

I've found similar questions, but no clear answer for this question. I have this table: CREATE DATABASE testDB DEFAULT ... 'thekey'), 'thekey'); See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Failed to load libmysql.dll file using Ruby on Rails 3

I am making one application using RoR with mysql.I followed the below steps for making app with mysql. 1-rails new ... and win-xp in my system. See Question&Answers more detail:os...

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

0 votes

836 views

1 answer

mysql - Calculates difference between two dates in PHP

HI, i have a couple of posts in my MySql database server, one of the info content in each post is the date ... made, so thanks for any help. See Question&Answers more detail:os...

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

0 votes

900 views

1 answer

mysql - Getting Mysql2::Error (SSL connection error: ASN: bad other signature confirmation) on Heroku App with AWS RDS

Mysql2::Error (SSL connection error: ASN: bad other signature confirmation): I am making an administration site. ... solve this problem? Thanks! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - How to fix query group with only_full_group_by

I have a basic key-value table, that has some data in it for each user. With the updated mysql it has the sql_mode ... (es) do I need to add? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

mysql - SQL Get Other Rows From Aggregate Function

I have an aggregate function that does a group by (col A). It selects the maximum value from a set of columns(col B), ... 1, B => 125, C => dae See Question&Answers more detail:os...

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

0 votes

718 views

1 answer

mysql - Working with composite primary key in django project with legacy database

I have a legacy database, where some table contains composite primary key. The model I get by running manage.py inspectdb ... ---+-------+ See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - SELECT CASE WHEN THEN (SELECT)

I am trying to select a different set of results for a product depending on a product type. So if my product ... sure where I am going wrong See Question&Answers more detail:os...

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

0 votes

761 views

1 answer

mysql - SQL UPDATE with LIKE

I was trying to update approx 20,000 records in a table by using statements like this one, however, I got ... I update records by using LIKE? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - LOAD DATA LOCAL INFILE does not work from php 5.5 using PDO

I've recently moved web servers, and the new web server has a different version of PHP. New Server: PHP 5.5.3- ... does PHP 5.5 want from me? See Question&Answers more detail:os...

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

0 votes

908 views

1 answer

mysql - How do I maintain PHP sessions across multiple domains on the same server?

I am looking for a way to maintain PHP sessions across multiple domains on the same server. I am going to ... use MySQL based sessions. Thanks! See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - How do you insert a PHP constant into a SQL query?

I have a PHP file with my database configuration settings defined as constants, for example: <?php define( ... SELECT users FROM DB_TABLE_1"; See Question&Answers more detail:os...

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

0 votes

912 views

1 answer

mysql - Using Cursor in a Loop of a stored procedure

So as to use cursors dynamically using MySQL is it possible to declare a cursor in a loop of a stored procedure ... at line 12 Thanks In advance See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Slow query on information_schema.tables

I run a set of self-developed applications on a typical shared hosting service offering. I moved from a static ... system would take so long? See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

mysql - improper killing of mysqld - now not starting

I stopped mysqld by killing the process id, and then deleted mysqld.sock file also. Now, mysqld is not ... var/run/mysqld/mysqld.pid ended See Question&Answers more detail:os...

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

0 votes

6.8k views

1 answer

mysql - PHP/Apache Error:406 Not Acceptable

So I received this error today, I've narrowed it down to this issue: My site is my musician page here. It ... sends them back to the home page. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Why QMYSQL driver not loaded in QT5.2?

My program is write with QT5.2 and use mysql. I heared that QT5.2 contains MYSQL driver already. However, ... mysql server-5.6-64bit. See Question&Answers more detail:os...

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

0 votes

758 views

1 answer

mysql - What's the best way to use LEFT OUTER JOIN to check for non-existence of related rows

Using MySQL 5.x I want to efficiently select all rows from table X where there is no related row in ... responses. Fixed grammatical error. See Question&Answers more detail:os...

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

0 votes

894 views

1 answer

mysql - SQL: How to keep rows order with DISTINCT?

The following SQL query: SELECT messages.id, messages.created_at, comments.created_at FROM messages LEFT JOIN comments ON ... keep the order ? See Question&Answers more detail:os...

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

0 votes

920 views

1 answer

mysql - Easy way of generating a slug name column from the name column?

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

Categories

Just Browsing Browsing

Most popular tags