Recent questions tagged MySQL

0 votes

640 views

1 answer

mysql - UPDATE if exists else INSERT in SQL

I'm trying to implement a SQL query to "UPDATE if exists else INSERT" My table(Allowance) is as below: ... " Can somebody please help?? See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

mysql - Select ALL fields that contains only UPPERCASE letters

How do you select a field that contains only uppercase character in mysql or a field that doesn't contain any lower case character? See Question&Answers more detail:os...

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

0 votes

484 views

1 answer

mysql - make text column as unique key

i want to make a table in MySQL server with mediumtext column as UNIQUE KEY CREATE TABLE `parts` ( `id` int ... make text column as UNIQUE KEY See Question&Answers more detail:os...

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

0 votes

667 views

1 answer

mysql - grant file on just one database

I want to allow LOAD DATA command for the john mysql user. So I logged into mysql terminal as root and ... mysql user to just johndatabase. See Question&Answers more detail:os...

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

0 votes

501 views

1 answer

mysql - When is Class.forName needed when connecting to a database via JDBC in a web app?

According to this tutorial, calling Class.forName isn't needed anymore with JDBC 4.0+ drivers. I successfully ... I'd really appreciate it. See Question&Answers more detail:os...

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

0 votes

577 views

1 answer

mysql - SQL - Select rows from two different tables

Having this table Table "Items" itemID itemTitle itemContent and this Table "MyList" userID itemID deleted how can ... get that result? Thanks See Question&Answers more detail:os...

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

0 votes

615 views

1 answer

mysql - MariaDb SQL Injection

I am trying to exploit (legally) a MariaDb database with an SQLi vulnerability. I have identified the vulnerability ... illegal stuff going on. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Sort upcoming birthdays based on current date

I have the following table of people and their birthdays: name birthday -------------------- ... every suggestion will be extremely appreciated. See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

mysql - Multiple database connection in Rails

I'm using active_delegate for multiple connection in Rails. Here I'm using mysql as master_database for some ... Anyone has any solution?? See Question&Answers more detail:os...

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

0 votes

700 views

1 answer

mysql - "Premature end of data" error with PHP

I've just started using WAMP for a PHP project and I get the next errors related with this line of code: ... ( ) ..aseDatos.php:5 See Question&Answers more detail:os...

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

0 votes

628 views

1 answer

mysql - Parsing extremely large XML files in php

I need to parse XML files of 40GB in size, and then normalize, and insert to a MySQL database. How much of ... would you go about doing this? See Question&Answers more detail:os...

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

0 votes

709 views

1 answer

mysql - Illegal mix of collations for operation 'like' while searching with Ignited-Datatables

I have successfully implemented Ignited-Datatables. However, while searching with database when typing "non-latin" ... for solving this? See Question&Answers more detail:os...

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

0 votes

555 views

1 answer

mysql - Perl Connection Pooling

Right now we have a large perl application that is using raw DBI to connect to MySQL and execute SQL statements. ... /docs/2.1/mod/mod_dbd.html See Question&Answers more detail:os...

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

0 votes

525 views

1 answer

mysql - Android : Is JDBC supported in Android devices?

I am doing an Android application using JDBC to send data to database without using any web services. I ... Android versions will support JDBC? See Question&Answers more detail:os...

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

0 votes

500 views

1 answer

mysql - Comparing with NULL values

CREATE TABLE `mycompare` ( `name` varchar(100) default NULL, `fname` varchar(100) default NULL, `mname` varchar ... First, second or last name. See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

mysql - Trailing whitespace in varchar needs to be considered in comparison

I am using a table with a varchar column. I did not realize that trailing whitespace is not considered in ... want to destroy the table. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

mysql - Python Pandas - Using to_sql to write large data frames in chunks

I'm using Pandas' to_sql function to write to MySQL, which is timing out due to large frame size ( ... frame, 'retail_pendingcustomers', 20000) See Question&Answers more detail:os...

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

0 votes

870 views

1 answer

mysql - MediumBlob in Laravel database schema

How can I create a Mediumblob within the Laravel schema builder ? In the docs it says : $table->binary('data ... i create a Mediumblob column ? See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

mysql - Calculating total data size of BLOB column in a table

I have a table with large amounts of BLOB data in a column. I am writing a utility to dump the data to ... all the blob fields in the table. See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

mysql - Add Delete Button to PHP results table

I have outputted the results of a MySQL table to an HTML table. In the last column, I want to add a delete ... t figure out what that is :( See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

mysql - SQL Select only rows where exact multiple relationships exist

This is closely related to this question, but adds another requirement. Given a parent table 'parent' ... property 5 and 1? See Question&Answers more detail:os...

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

0 votes

593 views

1 answer

mysql - Problem with LIMIT & IN/ALL/ANY/SOME subquery

I have this query: SELECT count(cp.CxID) as intSmokers FROM CustPrimarySmoking cp JOIN Customer c ON cp.CxID = c ... way of doing this? Thanks See Question&Answers more detail:os...

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

0 votes

658 views

1 answer

mysql - Successful SQL Injection despite PHP Magic Quotes

I have always read that Magic Quotes do not stop SQL Injections at all but I am not able to understand why ... the Magic Quote insertions here? See Question&Answers more detail:os...

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

0 votes

564 views

1 answer

mysql - Remove special characters from a database field

I have a database with several thousand records, and I need to strip down one of the fields to ensure that ... field in the whole database? See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

mysql - Django Multiple Databases Fallback to Master if Slave is down

I have master - slave replication setup for MySQL db backend for Django. Currently I am reading and writing for ... would be of help here ? See Question&Answers more detail:os...

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

0 votes

899 views

1 answer

mysql - mysqldump unknown option no beep

I'm running MySQL 5.5 on Windows, attempting a mysqldump: "C:WebServerMySQL Server 5.5inmysqldump.exe" -u user ... sure what is causing this? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - "Unknown column in 'field list'", but column does exist

DROP TABLE IF EXISTS `transactions`; CREATE TABLE `transactions` ( `id` int(11) unsigned NOT NULL AUTO_INCREMENT, ... list' Anyone an idea? See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

mysql - Alter table if exists or create if doesn't

I need to run an installer which can also be an updater. The installer needs to be able to end up having a certain ... do I do it? Thanks :-) See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags