Recent questions tagged MySQL

0 votes

562 views

1 answer

mysql jdbc driver does not support delimiters in triggers with multiple statements

i've got some code that is triggering a syntax error because of some misplaced semicolons. if this was running on ... IF; END; | delimiter ; See Question&Answers more detail:os...

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

0 votes

725 views

1 answer

mysql - PHPMyAdmin alert box - missing value in the form - all usual fields are filled out?

For some reason while using PHPMyAdmin and attempting to save a table, even though I've entered all of ... would be greatly appreciated! See Question&Answers more detail:os...

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

0 votes

809 views

1 answer

mysql - Laravel 5.3: Syntax error or access violation: 1463 Non-grouping field 'distance' is used in HAVING clause

This error came up after moving the whole source to the 5.3 version, and I'm scratching my head for over ... MySQL workbench. What's going on? See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

mysql - Room Booking Query

I have a problem in writing the sql to get the availables rooms from the tables. My tables structures are ... a checkin and checkout date. See Question&Answers more detail:os...

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

0 votes

579 views

1 answer

mysql - php pdo search column array

table name - animationmaster column - animationdate ,type= varchar column - animationno ,type= varchar data in each ... json_encode($info); ?> See Question&Answers more detail:os...

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

0 votes

499 views

1 answer

mysql - Error while using INSERT INTO table ON DUPLICATE KEY, using a for loop array

I am working on updating a mysql database using pyspark framework, and running on AWS Glue services. I have ... to use native python libraries. See Question&Answers more detail:os...

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

0 votes

743 views

1 answer

mysql - Get column name dynamically by Specific row value

I am struck at writing a query. Here I want to show the column name based on some specific value For Instance, ... the name from any one of them See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

mysql - Dynamic column alias based on column value

I want to name the column alias based on the column value in mysql. Is that possible? Something like ... evrything_else' end case from XTable See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - java.sql.SQLException: Illegal operation on empty result set. when authenticating

What I'm trying to do is: Accept username(uname) and password(passw) as an input from the user. Using ... , what's the alternative method? See Question&Answers more detail:os...

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

0 votes

567 views

1 answer

mysql - Efficiently escaping quotes in C before passing to mysql_query

In a nutshell I typically build a MySQL query within C using sprintf i.e. sprintf(sqlcmd,"update foo set dog="lab" ... (Crazy 5" Dog) ? Thanks! See Question&Answers more detail:os...

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

0 votes

616 views

1 answer

mysql - Multiple Column Foreign Key: Set single column to Null "ON DELETE" instead of all

General: Given a foreign key over several columns, some of them might be NULL. By default (MATCH SIMPLE) MySQL/ ... ON DELETE SET NULL ); See Question&Answers more detail:os...

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

0 votes

646 views

1 answer

mysql - PHP PDO how to run a multiple query request?

Hello I'm trying to execute this SQL request in PHP with PDOStatement: CREATE TEMPORARY TABLE r1 SELECT CONCAT(MONTH( ... /table></div>"; } See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

mysql - Choosing from multiple candidate keys

I may lack the mathematical background to find the right answer for myself. I have tables set up like so ( ... the setup to avoid that? See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

mysql - SQL : find rows and sort according to number of matching columns?

Let's imagine that we are having "cars" table with such a simple structure... car_id INT color ENUM('black',' ... is clear for you. Thank you. See Question&Answers more detail:os...

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

0 votes

609 views

1 answer

mysql - Multiple columns in MATCH AGAINST

I'm trying to get results from this query SELECT ID FROM table1 WHERE MATCH(column1, column2) AGAINST ('text') ... ve seen people are doing it. See Question&Answers more detail:os...

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

0 votes

825 views

1 answer

mysql - Auto-increment - automatic reset for each year

MySQL/InnoDB In my case my receipts should be counted on yearly basis; 1/2015, 2/2015 ... 556/2015 ... is standard PK auto incremented field. See Question&Answers more detail:os...

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

0 votes

672 views

1 answer

mysql - Group-wise Maximum of a Certain Column

I've got the table: SELECT * FROM shop; +---------+--------+------ | article | dealer | ... correct, I got the wrong dealers for some articles. See Question&Answers more detail:os...

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

0 votes

777 views

1 answer

mysql - Android JDBC connection results in ctahttp exception

Im currently trying to establish a connection from my Android app to a MySQL server running on my raspberry pi. I ... can help me out here. See Question&Answers more detail:os...

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

0 votes

719 views

1 answer

mysql - Preventing SQL Injection in C

I am writing a C application that takes some user input and does a few database queries. I am well aware of the ... way of doing this in C? See Question&Answers more detail:os...

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

0 votes

588 views

1 answer

mysql - need two limits?

Given a table containing awards earned over several years by members of an organization that consists of multiple ... showing up just once? See Question&Answers more detail:os...

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

0 votes

556 views

1 answer

mysql - Database - handling of unique constraint violation

I have a user creation screen that takes various user details along with first name and mobile number. I have ... approach among the above two? See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

mysql - Supports transactions, row-level locking, and foreign keys

For some reason I cannot create this table: CREATE TABLE user_role ( user_id VARCHAR(20) NOT NULL, role_id ... and foreign keys Any ideas? See Question&Answers more detail:os...

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

0 votes

621 views

1 answer

mysql - Order row selection by multiple columns

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

0 votes

614 views

1 answer

mysql - emulated prepared statements vs real prepared statements

What's exactly the difference between the two kinds of prepared statements ? I think real prepared statements require ... us against it ? See Question&Answers more detail:os...

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

0 votes

636 views

1 answer

mysql - Multiple database and transactions

If i use two database, i have to start to transaction? Is this correct, or this code is wrong? If i make a ... ..) or rollback(); commit(); See Question&Answers more detail:os...

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

0 votes

726 views

1 answer

mysql - Command Line PHP mysql_connect() Error

I am running a php page form the command line to update a mysql db once a php exec command has completed. ... the command line? Many thanks. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - java.sql.SQLException: Column Index out of range, 0 < 1

I want to display all the images from database. I have written code but that is displaying error java.sql. ... e.printStackTrace(); } } See Question&Answers more detail:os...

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

0 votes

907 views

1 answer

mysql - Rails: How to split write/read query across master/slave database

My website has a very heavy read traffic. A lot heavier than write traffic. To improve the performance of my ... using any gems in rails? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags