Recent questions tagged MySQL

0 votes

886 views

1 answer

mysql - Extract tuples with specified common values in another column in SQL

I have a dataset that look like: Col1 Col2 1 ABC 2 DEF 3 ABC 1 DEF Expected output: Col1 Col2 1 ABC ... Thanks for all the pointers in advance. See Question&Answers more detail:os...

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

0 votes

976 views

1 answer

mysql - Return Default value if no row found

I'm building query to search multiple rows from database like SELECT * FROM table1 WHERE col1 = '012311' OR col1 ... is found for that value? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - PHP: mysql_connect() won't work via command line

I have a script which calls mysql_connect() to connect to a MySQL DB. When I run the script in a browser, it ... so: php /path/to/script.php See Question&Answers more detail:os...

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

0 votes

1.7k views

1 answer

mysql - Permission denied when mounting Docker volume in OSX

I'm at my wit's end with this, so hopefully you folks can help me. In OSX 10.11.2 with docker-machine, ... mysql mysql 4096 Dec 24 00:37 mysql See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - LPAD with leading zero

I have table with invoice numbers. Guidelines say that numbers should have 6 or more digits. First of all tried to do ... 3 to 7 digits by now) See Question&Answers more detail:os...

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

0 votes

982 views

1 answer

mysql - How to set the default character-set?

I want to create a new db in mysql. I set utf8 as the default-character-set, but when I attempted to restart ... way to make mysql work again? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Case sensitive RLIKE

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

0 votes

1.1k views

1 answer

mysql - php search engine key words ranking

I am new to php and mysql. In my project I have to develop search engine for multiple keywords on multiple ... million and is growing rapidly. See Question&Answers more detail:os...

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

0 votes

854 views

1 answer

mysql - PHP and SQL Hashing Help: What am I doing wrong?

First off, I am fairly new to coding in general so the idea of hashing is slightly confusing. Essentially, I am ... 's saved for a later date. See Question&Answers more detail:os...

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

0 votes

881 views

1 answer

mysql - INNER or LEFT Joining Multiple Table Records Into A Single Row

Phone Table +----------------+-------------+ | Field | Type | +----------------+ ... row SQL left join with multiple rows into one row Thanks See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Sum of column in using mysqli and php

I am tring to get the sum of a column and the show it on my page using this code but it keeps ... Everything is fixed Thanks Everyone!!! See Question&Answers more detail:os...

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

0 votes

829 views

1 answer

mysql - Format SQL Table data as Text Table

I have a result from Oracle database as below: 1 Chi Phí L??ng FA_Phan_Bo_Chi_Phi_Luong 8 JOHN 8 2015 (BLOB) ... with the same width of column? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Encode and decode url message ID using php

I am trying to encode the message id of a php application and I cannot find a clear description on how to do so ... mostly is to clean the url). See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - PHP PDO SQL only returning one row of data instead of all rows

I am using PHP PDO extension to create a list of all items from a DB category table. The expected results are not ... [cat_image] => c83b.gif ) See Question&Answers more detail:os...

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

0 votes

987 views

1 answer

mysql - Insert picture into database using php

hello i have a form with many input ( name, last name, picture,age..) and i want to submit all this information into ... "; } else echo 'ko'; } See Question&Answers more detail:os...

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

0 votes

864 views

1 answer

mysql - Which query is the correct way?

Can somebody please tell me which is the better way, they both produce the same results but which is more ' ... count(p.PatientSurname) > 0 See Question&Answers more detail:os...

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

0 votes

991 views

1 answer

mysql - an efficient way to test if a table row exists

I'm trying to find the most efficient way to determine if a table row exists. I have in mind 3 options: ... are mysql, oracle and sql-server. See Question&Answers more detail:os...

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

0 votes

955 views

1 answer

mysql - Dynamically creating columns from row data using Select in Bigquery

Background I want to rename my case statement in sql select statement dynamically. Eg: SELECT (case when id= x.id then ... me ,if i am wrong. See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Type mismatch: cannot convert from java.util.Date to java.sql.Date

I am trying to get my code to work with the SimpleDateFormat class here in the code. Does anybody knows why? Have ... ; pst.setDate(2, endDate); See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Advice on Structuring a Comment System

I am a beginner at database design and I would like to create a comment system with the ability to reply to ... before I tackled that problem. See Question&Answers more detail:os...

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

0 votes

917 views

1 answer

mysql - Updating Woocommerce Orders Programmatically

I have an eCommerce site running Woocommerce on top of Wordpress, and the company running it has changed there ... side and updating the order? See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

mysql - Multiple UNION query doesn't work

The multiple UNION query: SELECT [Ordine numero] AS ordine, [data ordine] AS data, comm AS commessa FROM [archivio ... statement)? What to do? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - Conversion of Python DateTime string into integer milliseconds

I would like to convert a UTC TimeDate stamp string into an integer value of milliseconds (might need to be ... 653 milliseconds, not 652999. See Question&Answers more detail:os...

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

0 votes

977 views

1 answer

mysql between operator with dates

select '2011-02-29' BETWEEN '2011-02-01' AND '2011-03-03'? this is returning 1. I think between doesn't ... ) is retuning date. Why? Thanks Venu See Question&Answers more detail:os...

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

0 votes

960 views

1 answer

mysql - Flutter connecting to a database in server

I'm new to flutter and i really want to know, is there a way to connect to a database server (for ... mentioned problem (Flutter with database). See Question&Answers more detail:os...

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

0 votes

1.6k views

1 answer

mysql - PHP PDO Prepared statement bind NULL value

I'm trying to run a SQL query as a prepared statement - and I try to bind a NULL value. Well I've done ... 't get it. Thankful for any help. See Question&Answers more detail:os...

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

0 votes

960 views

1 answer

mysql - Python MySQLdb placeholders syntax

I'd like to use placeholders as seen in this example: cursor.execute (""" UPDATE animal SET name = %s ... syntax for doing something like this? See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - php: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

I have create register and login form using php. And i had took the source from google. So i have added all the ... $user = new User($db); ?> See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags