Recent questions tagged MySQL

0 votes

640 views

1 answer

mysql - Which is faster — INSTR or LIKE?

If your goal is to test if a string exists in a MySQL column (of type 'varchar', 'text', 'blob', etc) ... ) > 0 vs columnname LIKE '%mystring%' See Question&Answers more detail:os...

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

0 votes

487 views

1 answer

mysql - Difference between these two joining table approaches?

Consider we have two tables, Users and Posts. user_id is the foreign key in Posts table and is primary key in ... posts as post using user_id; See Question&Answers more detail:os...

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

0 votes

518 views

1 answer

mysql - What characters have to be escaped to prevent (My)SQL injections?

I'm using MySQL API's function mysql_real_escape_string() Based on the documentation, it escapes the following ... to escape those characters? See Question&Answers more detail:os...

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

0 votes

723 views

1 answer

mysql - LOAD DATA LOCAL INFILE forbidden in... PHP

I am trying to use LOAD DATA INFILE to insert some records into a table. Unfortunately, it's not working. Here ... found was an open PHP bug: See Question&Answers more detail:os...

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

0 votes

588 views

1 answer

mysql - SQL unique varchar case sensitivity question

I'm trying to populate a SQL table with a list of words. The table itself it pretty simple: CREATE TABLE WORDS ... on WORD to be case sensitive? See Question&Answers more detail:os...

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

0 votes

4.0k views

2 answers

mysql - How do I repair an InnoDB table?

We (apparently) had poorly executed of our Solaris MySQL database engine last night. At least some of the ... the database server to crash. See Question&Answers more detail:os...

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

0 votes

450 views

1 answer

mysql - Implementing a hierarchical data structure in a database

I know there are two approaches: adjacency list and nested tree. It's said that adjacency list can become ... more simplistic design. Thanks. See Question&Answers more detail:os...

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

0 votes

426 views

1 answer

mysql - Get results that fall within marker radiuses from database

Update 16th November 2012 I would like to raise this question again, offering with a new bounty for a ... /longitude within a bounding circle See Question&Answers more detail:os...

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

0 votes

748 views

1 answer

mysql - How to optimize COUNT(*) performance on InnoDB by using index

I have a largish but narrow InnoDB table with ~9m records. Doing count(*) or count(id) on the table is ... COUNT(*) performance on InnoDB? See Question&Answers more detail:os...

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

0 votes

769 views

1 answer

mysql - Error Code: 1062. Duplicate entry '1' for key 'PRIMARY'

I have a problem on this error message, when i try this: INSERT INTO `PROGETTO`.`UFFICIO-INFORMAZIONI` (`ID`, `viale` ... it', 'Ortisei', 'BZ'); See Question&Answers more detail:os...

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

0 votes

520 views

1 answer

mysql - Replace Into Query Syntax

I want to be able to update a table of the same schema using a "replace into" statement. In the end, I need ... 45,000 rows in under a minute. See Question&Answers more detail:os...

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

0 votes

575 views

1 answer

mysql - INSERT ... ON DUPLICATE KEY UPDATE with WHERE?

I'm doing a INSERT ... ON DUPLICATE KEY UPDATE but I need the update part to be conditional, only doing ... needs to work over a replication. See Question&Answers more detail:os...

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

0 votes

535 views

1 answer

mysql select sum group by date

Quick question, I have the following table +-------------+---------------------+ | total | o_date ... .2 Apr-> 29.84 Any clues about it. Thanks See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Is it possible to reference one column as multiple foreign keys?

I have few tables, and I want to reference one column from PDF table to multiple other tables. for example if ... it is possible to create it? See Question&Answers more detail:os...

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

0 votes

815 views

1 answer

mysql - Where to change the value of lower_case_table_names=2 on windows xampp

I am using windows 7 and xampp i am trying to export my database and while in the process the table names are ... this value, in which file? See Question&Answers more detail:os...

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

0 votes

494 views

1 answer

mysql - Easiest way for PHP email verification link

I already have an advanced user login/register system on my website (colemansystems.psm2.co.uk). However, I would like ... >"; } Is this secure? See Question&Answers more detail:os...

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

0 votes

826 views

1 answer

mysql - Using index, using temporary, using filesort - how to fix this?

I'm working on a event tracking system which uses a handful of lookup tables as well as the primary logging table ... it can get using ORDER BY? See Question&Answers more detail:os...

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

0 votes

467 views

1 answer

mysql - Select from one table where not in another

I'm trying to find the rows that are in one table but not another, both tables are in different ... partmaster.id & product_details.part_num See Question&Answers more detail:os...

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

0 votes

511 views

1 answer

mysql - Using group by on two fields and count in SQL

I have a table in my mysql db that has two columns: group and subgroup. See below. group, subGroup grp-A, sub- ... result. How can I fix this? See Question&Answers more detail:os...

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

0 votes

573 views

1 answer

mysql - What is the best solution for database connection pooling in python?

I have developed some custom DAO-like classes to meet some very specialized requirements for my project that ... more idiomatic/better solution. See Question&Answers more detail:os...

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

0 votes

505 views

1 answer

mysql - Count table rows

What is the MySQL command to retrieve the count of records in a table? See Question&Answers more detail:os...

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

0 votes

800 views

1 answer

mysql - Error Dropping Database (Can't rmdir '.test', errno: 17)

Basically, I was taught on how to create a root password using the "mysqladmin -u root -p password" command, ... drop the file with no errors? See Question&Answers more detail:os...

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

0 votes

428 views

1 answer

mysql - What is the best way to store media files on a database?

I want to store a large number of sound files in a database, but I don't know if it is a good practice. ... ) Note: The database will be MySQL. See Question&Answers more detail:os...

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

0 votes

551 views

1 answer

mysql - How to set root password to null

How can I change the password for root user of MySQL to null -- meaning no password or '' -- from the MySQL command line client? See Question&Answers more detail:os...

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

0 votes

569 views

1 answer

mysql - '0000-00-00 00:00:00' can not be represented as java.sql.Timestamp error

I have a database table containing dates (`date` timestamp NOT NULL DEFAULT '0000-00-00 00:00:00'). ... without changing the table structure? See Question&Answers more detail:os...

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

0 votes

621 views

1 answer

mysql - How to alter a column and change the default value?

I got the following error while trying to alter a column's data type and setting a new default value: ALTER TABLE ... DEFAULT '{}'' at line 1 See Question&Answers more detail:os...

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

0 votes

624 views

1 answer

mysql - Error: Tablespace for table xxx exists. Please DISCARD the tablespace before IMPORT

I am fairly new to MySQL and I am getting a pretty interesting error on which I cannot find any help via ... but I am just hypothesizing here. See Question&Answers more detail:os...

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

0 votes

804 views

1 answer

mysql - How to fix double-encoded UTF8 characters (in an utf-8 table)

A previous LOAD DATA INFILE was run under the assumption that the CSV file is latin1-encoded. During this ... How to correct these strings? See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags