Recent questions tagged MySQL

0 votes

1.1k views

1 answer

mysql - BIGINT UNSIGNED VALUE IS out of range My SQL

I'm getting the following error #1690 - BIGINT UNSIGNED value is out of range in '(legends.spawns.quantity - ... to get around this error? See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

mysql - error 1265. Data truncated for column when trying to load data from txt file

I have table in mysql table table looks like create table Pickup ( PickupID int not null, ClientID int not null, ... I am using MySQL 5.2 See Question&Answers more detail:os...

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

0 votes

675 views

1 answer

mysql - insert autoincrement into second column

I am looking to do a query like so: id | int | autoincrement something | varchar | 255 insert into `table` set ... row. How can I do this? See Question&Answers more detail:os...

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

0 votes

732 views

1 answer

mysql - Get most recent row with group by and Laravel

Even though there are multiple questions like this I can't get my query to return the row with the most recent date ... 'DESC') ->paginate(10); See Question&Answers more detail:os...

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

0 votes

685 views

1 answer

mysql - Fixing encodings

I have ended up with messed up character encodings in one of our mysql columns. Typically I have √? instead ... (comparable with existing data). See Question&Answers more detail:os...

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

0 votes

662 views

1 answer

mysql change date format

I have a date field (tinytext) holding date information in format of "dd-mm-yy" e.g 07-01-90. Using a mysql query ... ('date','%Y,%m,%d')"); See Question&Answers more detail:os...

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

0 votes

576 views

1 answer

mysql - Looping Through SQL Results in PHP - Not getting Entire Array

I'm probably missing something easy, but I seem to be blocked here... I have a MySQL database with two ... . Any assistance is much appreciated. See Question&Answers more detail:os...

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

0 votes

755 views

1 answer

mysql - rake db:create - collation issues

kratos-iii:railsproj zachinglis$ rake db:create (in /Users/zachinglis/Sites/rails/railsproj) Couldn't create database ... really doubt thats it. See Question&Answers more detail:os...

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

0 votes

711 views

1 answer

mysql - Printing out a table horizontal instead of vertical using PHP

Problem: I have a table that prints out vertical but I would like it to print horizontal instead. Anyone ... Current output: Desired output: See Question&Answers more detail:os...

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

0 votes

517 views

1 answer

mysql - Select specific rows and columns from an SQL database

Is it possible to retrieve specific columns of specific rows in an SQL query? Let's say I'm selecting from ... 42 rather all its 1000 columns? See Question&Answers more detail:os...

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

0 votes

740 views

1 answer

mysql - how to get the total row count with mysqli

i am trying to understand mysqli extension and did google but got very few info on this except php.net which was ... on how to achieve my goal. See Question&Answers more detail:os...

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

0 votes

921 views

1 answer

mysql - PHP: Dynamic Drop down with optgroup

I am developing a drop down menu that uses HTML optgroups for group names that employees are a part of. Here ... /optgroup> <?php endforeach; } See Question&Answers more detail:os...

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

0 votes

875 views

1 answer

mysql - "query end" step very long at random times

I'm benchmarking a web application, and I have a problem that occurs on about 1% of my queries, mostly ... I improve the performances ? Thanks See Question&Answers more detail:os...

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

0 votes

880 views

1 answer

mysql - How to use 'having' with paginate on relationship's column in laravel 5

I need to grab the vehicles whose relation 'dealer' is having distance < 200 Vehicle::join('dealers', 'vehicles. ... = $vehicle->paginate(15); See Question&Answers more detail:os...

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

0 votes

689 views

1 answer

mysql - JPA's Map<KEY, VALUE> query by JPQL failed

I am storing a Map in JPA , which stores a keyword translation in each language . such as one object stores Locale ... 4.2.3 , MySQL dialect See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

mysql - SQL: search/replace but only the first time a value appears in record

I have html content in the post_content column. I want to search and replace A with B but only the first time A ... (post_content, 'A', 'B'); See Question&Answers more detail:os...

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

0 votes

474 views

1 answer

mysql - Python MySQLdb update query fails

Okay. I've built here a mysql query browser, like navicat. Using MySQLdb to perform queries. Here's the ... ideas what could be happening? See Question&Answers more detail:os...

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

0 votes

599 views

1 answer

mysql - How to "undeclare" volumes in docker image?

I am writing a Dockerfile for setting up an image for testing a web application. I am basing it on the ... system like everything else? Thanks! See Question&Answers more detail:os...

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

0 votes

614 views

1 answer

mysql - SQL Select only rows where multiple relationships exist

Given a parent table 'parent' ╔═══════════╦══════════╗ ║ PARENT_ID ║ NAME ║ ╠═══════════╬══════════╣ ║ 1 ║ bob ... multiple relationships exist See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - SUM(DISTINCT) Based on Other Columns

I currently have a table that looks something like this: +------+-------+------------+------- ... SUM one rate for each name? Thanks in advance! See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Escaping the colon character ':' in JPA queries

I'm trying to run a native query through JPA that uses a ':' character. The particular instance is using a MySQL user ... do this, or am I SOL? See Question&Answers more detail:os...

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

0 votes

582 views

1 answer

mysql - how to pass a null value to a foreign key field?

I have 2 tables: university: university_id(p.k) | university_name and user: uid | name | university_id(f ... user table for university_id field. See Question&Answers more detail:os...

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

0 votes

659 views

1 answer

mysql - PHP Binding a Wildcard

Hope Somebody will help me about how I bind a parameter in mysqli when a multiple character wildcard needs to be ... this problem? Thank you. See Question&Answers more detail:os...

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

0 votes

676 views

1 answer

mysql - Check the language of string based on glyphs in PHP

I have a MySQL database with book titles in both English and Arabic and I'm using a PHP class that can ... <h3>$item_title</h3>"; } See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Split delimited string value into rows

Some external data vendor wants to give me a data field - pipe delimited string value, which I find quite difficult to ... b") Tuple(1, "c") See Question&Answers more detail:os...

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

0 votes

632 views

1 answer

mysql - Auto Increment Composite Key InnoDB

I want to create a MyISAM like behavior for an InnoDB MySQL table. I want to have a composite primary key: PRIMARY KEY(id1, ... --------------+ See Question&Answers more detail:os...

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

0 votes

707 views

1 answer

mysql - What is the root error behind "Failed to establish a database connection. Check connection string, username and password."

Looking through google and stackoverflow, I found a number of questions asking about "Failed to establish a ... password have been verified. See Question&Answers more detail:os...

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

0 votes

603 views

1 answer

mysql - PHP PDO Insert Using Loop

I am having trouble using PDO to insert multiple records into a database. I can successfully add a single record, but ... $e->getMessage(); } } See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags