Recent questions tagged MYSQL

0 votes

733 views

1 answer

mysql - PHP/SQL Insert Error when using Named Placeholders

I have the following PHP PDO statement: $STH = $this->_db->prepare("INSERT INTO UserDetails (FirstName, LastName, ... silly mistake have I made? See Question&Answers more detail:os...

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

0 votes

692 views

1 answer

mysql - Parse SELECT clause of SQL queries into a PHP array

This is more for analyzing a query in PHP BEFORE it's sent to the server. Very complicated why im doing this, ... example). Thanks for any help! See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

mysql - Coverting Hex to Image in PHP?

I am developing mobile app which talks with server via PHP Webservice. This is my first time using PHP. I ... Any help is much appreciated. See Question&Answers more detail:os...

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

0 votes

1.5k views

1 answer

mysql - INNER JOIN Results from Select Statement using Doctrine QueryBuilder

Can you use Doctrine QueryBuilder to INNER JOIN a temporary table from a full SELECT statement that includes a GROUP BY ... '(' is not defined. See Question&Answers more detail:os...

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

0 votes

746 views

1 answer

mysql - PHP add up two time variables

In my PHP application I want to calculate the sum of two time variables. I am looking for something like this ... :00; $time = $time1+$time2; See Question&Answers more detail:os...

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

0 votes

965 views

1 answer

mysql - PDOException “could not find driver” in php

I have installed Lampp on my linux system, and I am learning symfony2, while trying to create the schema with ... i can remove this issue ? See Question&Answers more detail:os...

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

0 votes

731 views

1 answer

mysql - When a new row in database is added, an external command line program must be invoked

Is it possible for MySQL database to invoke an external exe file when a new row is added to one of the ... some batch jobs outside the database. See Question&Answers more detail:os...

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

0 votes

792 views

1 answer

mysql - cron jobs or PHP scheduler

I am using MYSQL as my database and PHP as my programming language.I wanted to run a cron job which would ... method? can anybody enlighten me? See Question&Answers more detail:os...

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

0 votes

1.1k views

1 answer

mysql - PHP Fatal error: Call to undefined function mysqli_stmt_get_result()

I keep getting the error PHP Fatal error: Call to undefined function mysqli_stmt_get_result(). I am using PHP ... json_encode($respond); ?> See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

mysql - Get number of rows matched by UPDATE query with PHP mysqli

The older mysql extension has the CLIENT_FOUND_ROWS connection flag, but I couldn't find any equivalent for mysqli. I ... But that seems hacky. See Question&Answers more detail:os...

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

0 votes

678 views

1 answer

mysql - How to use prepared statement for select query in Java?

I had tried several times using prepared statements but it returns SQL exception. here is my code: public ArrayList ... of code is appreciated. See Question&Answers more detail:os...

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

0 votes

939 views

1 answer

mysql - How can "set timestamp" be a slow query?

My slow query log is full of entries like the following: # Query_time: 1.016361 Lock_time: 0.000000 Rows_sent: 0 ... ideas of how to fix this? See Question&Answers more detail:os...

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

0 votes

833 views

1 answer

mysql - Updating table in trigger after update on the same table

How can I update table's column in a trigger after update on the same table? Here's the trigger: CREATE TRIGGER ... I can get this to work? See Question&Answers more detail:os...

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

0 votes

598 views

1 answer

mysql - Join two tables (with a 1-M relationship) where the second table needs to be 'flattened' into one row

Given the following tables: Student +----+-------+ | id | Name | +----+----- ... enrollment_id, enrollment.student_id, and enrollment.course_id. See Question&Answers more detail:os...

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

0 votes

701 views

1 answer

mysql workbench, replace column from file

I have a 1,000,000 row .csv file that I uploaded into a table using mySQL Workbench, but I forgot to makes ... Version is 5.6.20 Screenshot: See Question&Answers more detail:os...

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

0 votes

607 views

1 answer

mysql - Order within group by?

In my system, I have clients. Clients have programs. I want to display a list of clients, showing their most ... joining the same table twice. See Question&Answers more detail:os...

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

0 votes

850 views

1 answer

mysql - How to transform vertical data into horizontal data with SQL?

I have a table "Item" with a number of related items, like so: ID Rel_ID Name RelRank --- ------ ---- ... column, which does appear in my data] See Question&Answers more detail:os...

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

0 votes

753 views

1 answer

mysql - Automatic conversion of SQL query to ElasticSearch Query

I have a service which currently stores data in Oracle DB. I am working on a project where I need to ... to search through even ElasticSearch. See Question&Answers more detail:os...

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

0 votes

1.0k views

1 answer

mysql - get a recursive parent list

Using MySQL, I want to return a list of parents, from a table that has a field structure like this. ID,PARENTID ... " Returns "9149,9148,9146,0" See Question&Answers more detail:os...

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

0 votes

553 views

1 answer

mysql - Does replace into have a where clause?

I'm writing an application and I'm using MySQL as DBMS, we are downloading property offers and there were ... answers in advance, Lajos árpád See Question&Answers more detail:os...

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

0 votes

596 views

1 answer

mysql - Formatting an SQL timestamp with PHP

I have a mySQL database with a timestamp field. It currently only has one entry while I'm testing, it is 2010-02 ... error when it can't synch. See Question&Answers more detail:os...

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

0 votes

610 views

1 answer

mysql "Where not in" using two columns

I have one temporary table that contains userID and taskID. It is called CompletedTasks. I have a second ... .taskID != CompletedTasks.taskID See Question&Answers more detail:os...

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

0 votes

717 views

1 answer

mysql - How to use mysqli_query() in PHP?

I'm coding in PHP. I have the following mySQL table: CREATE TABLE `students` ( `ID` int(10) NOT NULL ... ($link,"SHOW CREATE TABLE students"); See Question&Answers more detail:os...

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

0 votes

638 views

1 answer

mysql - How to speed up sql queries ? Indexes?

I have the following database structure : create table Accounting ( Channel, Account ) create table ChannelMapper ( ... query plan : Thanks, See Question&Answers more detail:os...

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

0 votes

785 views

1 answer

mysql - SQL date format convert? [dd.mm.yy to YYYY-MM-DD]

is there mySQL function to convert a date from format dd.mm.yy to YYYY-MM-DD? for example, 03.09.13 -> 2013-09-03. See Question&Answers more detail:os...

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

0 votes

642 views

1 answer

mysql - SQL_CALC_FOUND_ROWS / FOUND_ROWS() does not work in PHP

I use SQL_CALC_FOUND_ROWS in Mysql SELECT statement, to get the number of lines my SELECT would return without ... request was awfully unclear. See Question&Answers more detail:os...

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

0 votes

838 views

1 answer

mysql - PHP PDO with foreach and fetch

The following code: <?php try { $dbh = new PDO("mysql:host=$hostname;dbname=$dbname", $username, $password); ... sex-male Why does this happen? See Question&Answers more detail:os...

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

0 votes

588 views

1 answer

mysql - Database Design: Multiple tables vs a single table

I am making a website where there are different types of items such as blogs, posts, articles and so on. A user ... it helps, I am using MySql See Question&Answers more detail:os...

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

Categories

Just Browsing Browsing

Most popular tags