Recent questions tagged MySQL

0 votes

1.7k views

1 answer

mysql - PHP Fatal error: Uncaught PDOException: could not find driver

I have been trying to connect to MySQL from PHP using PDO. However, I get this error message: PHP Fatal ... I missing something in my code? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - What is the simplest way to format a timestamp from SQL in PHP?

What is the simplest, fastest way to complete the PHP code below such that the output is in a user- ... 'my_timestamp']); echo $formatted_date; See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - How do you change the SQL isolation level from Python using MySQLdb?

The documentation I've run across researching this indicates that the way to do it for other databases is to use ... with this in the past? See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Sql timestamp to Java date?

I have a database which is going to have UMT timestamps in standard sql format. How can I pull that data and ... this I am open to suggestions. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql query to get birthdays for next 10 days

i am making a query to get birthdays for next 10 days . i was able to make a query for today but even after ... me out with a query for 10 days See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - How to have a Shell script continue after reboot?

I have a Shell script that needs to run in a loop, and perform a series of commands, and when it's ... in advance for your helpful insight! See Question&Answers more detail:os...

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

0 votes

990 views

1 answer

mysql - auto_increment usage in composite key

I am having a table with the composite key emp_tbl( companyId int not null, empId int not null auto_increment, ... possible to do it? Thanks See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Rails validate uniqueness fails on concurrent inputs

I have a Ticket model with basic uniqueness validation on a string attribute ticket_number validates :ticket_number, ... that from happening ? See Question&Answers more detail:os...

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

0 votes

995 views

1 answer

mysql - Date difference between two records in same table

I have a table (job_logs) with the following records: id, job_id, user_id, status, created_at, job_type. Each time a ... ). How can I do that? See Question&Answers more detail:os...

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

0 votes

1.4k views

1 answer

mysql - #1366 - Incorrect integer value: 'NULL' for column 'cid' at row 1

I have installed MyBB local using XAMPP and it goes smoothly. But when I do it on the server it give me ... this to work? Thanks in advance. 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 query returns inaccurate value for FLOAT fields

I am guessing this has came up before, but I couldn't find the answer to my question. Here is a little ... me in the right direction? Thanks! See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Select if exist else insert?

IF EXISTS (select * from users where username = 'something') THEN select id from users where username = 'something'; ... ('something'); END IF; See Question&Answers more detail:os...

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

0 votes

973 views

1 answer

mysql - How to select Column value as Column name with conditions in SQL table

I'm new to SQL. I have a table 'Customers' and it looks like this. I would like to select 'Gender' AS ... show what I need. Please help me. See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - How to do Indexing of database tables in phpMyAdmin

I want to boost up my database speed each time when new query hit to database table. Can anybody help me out ... phpMyAdmin & how to do it?? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - How to create trigger to insert data to a database on another server

I have 2 mysql databases on different hosts, want trigger after insert data to one database it inserted ... =6 DEFAULT CHARSET=utf8 See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Python: Convert tuple to comma separated String

import MySQLdb db = MySQLdb.connect("localhost","root","password","database") cursor = db.cursor() cursor. ... is an example 1320088L,1320089L See Question&Answers more detail:os...

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

0 votes

876 views

1 answer

mysql - Database design: objects with different attributes

I'm designing a product database where products can have very different attributes depending on their type, but ... not fully convinced... See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - LOAD XML LOCAL INFILE with Inconsistent Column Names

MySQL has a nice statement: LOAD XML LOCAL INFILE For example, if you have this table: CREATE TABLE person ( ... but couldn't find an answer. See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Chaining JSON_EXTRACT with CAST or STR_TO_DATE fails

I'm trying to extract a datetime from a JSONFIELD "data" in MySQL. If I do a simple JSON_EXTRACT however, ... any help in resolving this! See Question&Answers more detail:os...

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

0 votes

961 views

1 answer

mysql - primary indexes Vs secondary indexes: performance differences

I've got a little question: what is the difference in performance between the primary and secondary indexes? what ... performance? Thanks a lot See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - how to do a split on a sql table column

I have a table that stores some comma separated strings. Is there a way to write a sql to return me ... obtained by splitting across commas. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - php sql join together multiple tables from different databases

I have 3 databases, and now I need to join several tables from each one of them into a singel query. How ... which database aswell in the query? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - How to get inserted value for trigger

I am trying to create a trigger in mysql that will insert in to another table when an insert on a table ... original insert to use here? Thanks See Question&Answers more detail:os...

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

0 votes

1.2k views

1 answer

mysql - Select column names whose entries are not null

I would like to have a list of those columns of a table that have at least one non-NULL data entries in ... those columns with non-NULL entries? See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - How to get records which contain alphaNumeric characters + white-spaces

How to get records which contain alphaNumeric characters + white-spaces. OR At-list single numeric character in name. ... . i.e abcdefg hij See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - Join table with MAX value from another

select * from order ------------------- |orderID|productID| --------------- ... the largest corresponding cost_price value in product_supplier? See Question&Answers more detail:os...

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

0 votes

1.3k views

1 answer

mysql - Php/ODBC encoding problem

I use ODBC to connect to SQL Server from PHP. In PHP I read some string (nvarchar column) data from SQL ... , but it loses correct characters). See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - MS Access Multi-Join Query

Can anyone find what is wrong with this MS Access Query? When I try to execute it i receive an error ... .MemberID = August.fk_Members_ID )GETIT See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags