All Questions
218 questions
0
votes
0
answers
70
views
Double update problem all my row data column disappear
I have table in phpmyadmin, I update its row value from a word to a different word. My code line is :
UPDATE database213
SET category = COALESCE((
SELECT GROUP_CONCAT(Category_Name)
FROM ...
0
votes
1
answer
79
views
Get Rid Of FULL Scan Inner Query Mysql DB
I'm running an SQL query on MYSQL, I was expecting to access the record in one attempt.
Because the inner query gets only 1 row, this record can be accessed on a Primary key index user_id of the ...
- 10.2k
1
vote
1
answer
182
views
Create my database in python but i can't find it
I create my database with python
import mysql.connector
mydb = mysql.connector.connect(
host="localhost",
user="root",
password="126332"
)
mycursor = mydb....
0
votes
2
answers
54
views
Database entry removed on browser refresh, Ajax PHP jQuery
I have a form that updates columns in a database table on submit of a form via ajax. Everything works great, the database table columns get the information however once the browser is refreshed the ...
- 21
0
votes
0
answers
89
views
How to show data inside select option in jquery from mysql using laravel [duplicate]
How to show data inside select option from MySQL?
I try to created it, but doesn't work
My Controller
public function getItemCategory(Request $request)
{
$itemcategory = DB::table('...
- 97
0
votes
1
answer
184
views
Grouping same data from db in html using ajax jquery
Given below in the picture is the desired output I want. I've 3 tables, student, projects and a junction table where corresponding student ids are present against each project id.
I'm unable to group ...
- 116
4
votes
1
answer
92
views
Populating divs with MySQL data, matching row to a numbered ID
I am trying to use a database of books to display relevant data on a page by matching an id of a clickable div with a sort of serial number for each book in the database. my table is thus:
+-----------...
- 77
0
votes
1
answer
430
views
Mysql Full outer join two subqueries
I know mysql does not support full outer join, and doing this you have to basically left join/right join and do union. I have two tables one contains all possible keys with labels for them for the ...
- 27
0
votes
2
answers
51
views
QUERY DATABASE: How can I get multiple data from 2 tables with an id that does not exist in a table
Hello i've got the following two tables:
TABLE: computers
| id | pc | user_id |
|:---|:---- -|:----|
| 1 | M-1 | 25 |
| 2 | P-1 | 15 |
| 3 | C-2 | 36 |
| 4 | A-5 | 0 |
| ...
- 3
0
votes
0
answers
101
views
How to save drag moves into database
happy new year!!!
<!DOCTYPE html>
<html>
<head>
<style>
html,
body {
margin: 0;
}
table {
border-collapse: collapse;...
user14506551
0
votes
0
answers
78
views
MySQL after update trigger doesn't work correctly when a new order stored
I created a trigger for copying rows from Woocommerce tables into a destination table with the name "serialized_data".
it works correctly after insert time/event mode when new order stores, ...
0
votes
0
answers
63
views
How to add the values from the image into the Mysql database table
I am working on code to tag images. I have the code to display the coordinates of the tag position on the image and it displays it on a small output screen. What is need is I want to get these values ...
- 101
1
vote
1
answer
2k
views
How to export a .txt file from a column of a table in MySQL database?
I want to export the phone numbers in .txt format line by line. Table name is customers and the column name is customer_contact_numbers from the database saiautocare I am using the Laravel framework, ...
- 45
0
votes
0
answers
32
views
How to add data from jquery generated rows to a database?
I'm just starting to learn PHP and my academic teacher gave my group a task to create a fully functional site that stores data about some fictitious scientific publications. My task from now is to ...
- 11
0
votes
2
answers
448
views
Import Error: You have an error in your SQL syntax;
I'm having issues with my jquery code. I'm new to jquery so I'm not really sure where the problem lies.
-- phpMiniAdmin dump 1.9.150917
-- Datetime: 2019-10-31 23:14:13
-- Host:
--/*!40030 SET NAMES ...
