Recent questions tagged MySQL

0 votes

824 views

1 answer

mysql - #1273 - Unknown collation: 'utf8mb4_unicode_ci' cPanel

I have a WordPress database on my local machine that I want to transfer to a hosted phpMyAdmin on cPanel. However, ... won't work. Please help! See Question&Answers more detail:os...

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

0 votes

560 views

1 answer

mysql - Simple PHP SQL login troubleshooting

I am trying to create a very basic PHP login by retrieving a registered username/password from a database. ... would be greatly appreciated. See Question&Answers more detail:os...

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

0 votes

531 views

1 answer

mysql - php file upload, how to restrict file upload type

I have the following code to check if (resume and reference letter uploaded match desired type (pdf OR doc OR docx ... is wrong with it? Thanks, See Question&Answers more detail:os...

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

0 votes

514 views

1 answer

mysql - Creating functions in phpMyAdmin - Error: access denied you need the super privilege for this operation

I imported a MySQL database. All the tables where successfully imported but not the functions. The only way I ... phpMyAdmin or with the server? See Question&Answers more detail:os...

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

0 votes

575 views

1 answer

mysql - Select all months within given date span, including the ones with 0 values

I'm trying to write a MySQL query to get an average value per month, for all months between to given dates. My ... Can it be done within MySQL? See Question&Answers more detail:os...

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

0 votes

512 views

1 answer

mysql stored procedure that calls itself recursively

I have the following table: id | parent_id | quantity ------------------------- 1 | null | ... a working statement in a couple of seconds. See Question&Answers more detail:os...

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

0 votes

951 views

1 answer

mysql - How to use unsigned int / long types with Entity Framework?

Class properties with the long data type are properly mapped when adding a new migration (code-first), but ... use mysql's unsigned bigint? See Question&Answers more detail:os...

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

0 votes

928 views

1 answer

mysql - Php : Convert a blob into an image file

Is this possible with php and a mysql database to Convert a blob into an image file? See Question&Answers more detail:os...

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

0 votes

521 views

1 answer

mysql - Connecting android with MS SQL SERVER 2008

Is there a way that we can connect an Android application to a central database server (e.g. MSSQLServer 2008)? ... done from the Android app? See Question&Answers more detail:os...

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

0 votes

468 views

1 answer

mysql - How to fuzzy match email or telephone by Elasticsearch?

I want to make fuzzy match for email or telephone by Elasticsearch. For example: match all emails end with @gmail.com or match ... } } } } } } } See Question&Answers more detail:os...

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

0 votes

434 views

1 answer

mysql - Higher cardinality column first in an index when involving a range?

CREATE TABLE `files` ( `did` int(10) unsigned NOT NULL DEFAULT '0', `filename` varbinary(200) NOT NULL, ` ... two indexes is better? And why? See Question&Answers more detail:os...

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

0 votes

519 views

1 answer

mysql like performance boost

is there anyway to speed up mysql like operator performance if wild card is involved? eg. like '%test%' See Question&Answers more detail:os...

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

0 votes

447 views

1 answer

mysql - php code to test pdo is available?

I want to use PDO but I'm not sure whether my hosting has set it up properly. How can I test, in PHP, whether it is setup and working for MySQL? See Question&Answers more detail:os...

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

0 votes

532 views

1 answer

mysql - importing a CSV into phpmyadmin

I have a CSV that looks like this, candidate_id,show_on_site,first_name,surname,gender,DOB,showdob,Location,height,eyes, ... , D, E etc. See Question&Answers more detail:os...

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

0 votes

541 views

1 answer

mysql - How to echo out table rows from the db (php)

i want to echo out everything from a particular query. If echo $res I only get one of the strings. If I change the 2nd ... </td><tr></form> "; } See Question&Answers more detail:os...

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

0 votes

698 views

1 answer

mysql - How can I decrypt a password hash in PHP?

I need to decrypt a password. The password is encrypted with password_hash function. $password = 'examplepassword'; ... method? Or what else? See Question&Answers more detail:os...

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

0 votes

635 views

1 answer

mysql - Bug? #1146 - Table 'xxx.xxxxx' doesn't exist

I am using windows XP. I am creating a table in phpMyAdmin using its built-in create table feature, my database ... What might be the problem? See Question&Answers more detail:os...

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

0 votes

620 views

1 answer

mysql - Checking a table for time overlap?

I have a MySQL table with the following fields: name starttime endtime starttime and endtime are MySQL TIME fields ... PHP to execute this. See Question&Answers more detail:os...

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

0 votes

490 views

1 answer

mysql - How get all values in a column using PHP?

I've been searching for this everywhere, but still can't find a solution: How do I get all the values from ... store those values in an array. See Question&Answers more detail:os...

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

0 votes

530 views

1 answer

mysql - SQLite and custom order by

I have a table with categories: ID Category "1","Baking" "3","Family" "4","Entertaining" "5","Children" "6", ... don't have an "order by" field. See Question&Answers more detail:os...

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

0 votes

561 views

1 answer

mysql root password forgotten

I did not use PHP MySQL for quite a while and now I need to use it again. But the problem is I forget ... there.what to do? Thanks in advance. See Question&Answers more detail:os...

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

0 votes

604 views

1 answer

mysql - SQL Query to get column values that correspond with MAX value of another column?

Ok, this is my query: SELECT video_category, video_url, video_date, video_title, short_description, MAX(video_id) ... BY video_category ASC See Question&Answers more detail:os...

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

0 votes

442 views

1 answer

mysql - Checking multiple columns for one value

I have a table that has columns like this for example: id,col1,col2,col3,col4 Now, I want to check if ANY of ... easier way to do what I want? See Question&Answers more detail:os...

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

0 votes

477 views

1 answer

mysql - Using ORDER BY and GROUP BY together

My table looks like this (and I'm using MySQL): m_id | v_id | timestamp ---------------------- ... then ORDER the results. Any ideas? Thank you. See Question&Answers more detail:os...

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

0 votes

729 views

1 answer

mysql - Calculating distance between zip codes in PHP

I grabbed a database of the zip codes and their langitudes/latitudes, etc from this This page. It has got ... code in PHP will be appreciated See Question&Answers more detail:os...

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

0 votes

438 views

1 answer

mysql - How do I UPDATE a row in a table or INSERT it if it doesn't exist?

I have the following table of counters: CREATE TABLE cache ( key text PRIMARY KEY, generation int ); I would ... like a very basic operation. See Question&Answers more detail:os...

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

0 votes

369 views

1 answer

mysql - How to start spring-boot app without depending on Database?

I am using "Spring-boot + Hibernate4 + mysql" for my application. As part of which I ... temp: use_jdbc_metadata_defaults: false See Question&Answers more detail:os...

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

0 votes

832 views

1 answer

mysql - LEFT JOIN only first row

I read many threads about getting only the first row of a left join, but, for some reason, this does not work for ... 1 ) WHERE f.id = '13815' See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags