MySQL is a free, open source Relational Database Management System (RDBMS) that uses Structured Query Language (SQL). DO NOT USE this tag for other DBs such as SQL Server, SQLite etc. These are different DBs which all use SQL to manage the data.

learn more…| top users | synonyms (7)|mysql jobs

0
votes
0answers
2 views

Catch _mysql_exceptions.IntegrityError in python

I am trying to catch this exception, but i don't know how since am a beginner in python.The excpetion i get from DB shows that there's a duplicate entry :File "C:\Users\Huzy_Kamz\PycharmProjects\...
0
votes
0answers
5 views

mysql MEDIUMTEXT performance

i want to save very long text like base64(image) encoded string into mysql table.in this case, is it slow to execute query(select, insert, update, delete)?select * from A where index=xtable A...
0
votes
2answers
25 views

How to ignore a parameter in a prepared mysqli query in PHP?

I have a prepared mysqli query like this:$query=$database->prepare("SELECT * FROM items WHERE inStock > ? AND size < ? AND name LIKE ?"); $query->bind_param('iis', $inStock,...
0
votes
1answer
15 views

mysql join rows with from only 1 id

I am attempting to query two tables to create a monthly employee time report. When I join the tables using INNER JOIN (emp_nr is the same in both tables) then I get the following. Please excuse me if ...
1
vote
1answer
17 views

How to convert a column from varchar to decimal in MySQL, knowing that the values are separated with commas

I tried the following MySQL requests to convert a column from varchar to decimal type, but I got Errors.ALTER TABLE `cmd-services` CHANGE `Qte Sortie` `Qte Sortie` CAST(REPLACE(`Qte Sortie`, ',', '.'...
1
vote
1answer
20 views

How to convert NodeJs response to nested json response

I am using Nodejs(ExpressJS) and my-SQL to create a rest API. I want my response like nested json object which will easy to read on my frontend . I tried with for loop , but it does not gave me proper ...
-1
votes
1answer
14 views

Mysql get count with php prepared

Hi friend i never worked with prepared.I have problem i want get count rows in my table.What is a wrong ?<?phprequire_once "config.php";$conn=new mysqli($servername, $username, $password, $...
0
votes
0answers
15 views

Fill SQL database by information from dynamic created HTML table [duplicate]

I'll try to explain my problem. I have files: index.php (there is HTML code), js (main.js, jquery.js), database.php. When I press button "addbutton" todolist creates (it has many div's, checkbox, ...
-1
votes
0answers
15 views

Inserting range parameter to many rows MySQL

I am creating a stored procedure in MySQL and have this problem. I receive a range parameter (startDate and endDate) from an application. However I must insert to a table with this structure:...
0
votes
0answers
15 views

Trying to skip duplicate values in Where for Laravel

I want to display all the teams for a year only once in Laravel. I can't get the distinct() to work because i'm not using a select(). How do I skip repeating values in where() or how do I include a ...
0
votes
0answers
8 views

When is it best to create a meta table?

Recently I find myself creating meta tables for most of my main tables.For example, my user table contains a password, email, and ID, as well as some timestamps. But things like where the user is ...
-1
votes
0answers
7 views

MySQL warning when adding image in blob column

I'm trying to add some image in my column(blob) and I'm getting this error linting is disabled for this query because it exceeds the maximum length.How to fix this and why im getting this error
0
votes
1answer
14 views

Equivalent of MSSQL's STUFF and XML PATH in MYSQL

I have an mssql database that I want to convert/migrate to mysql. I am getting the error message below.Error Number: 1064You have an error in your SQL syntax; check the manual that corresponds ...
-1
votes
0answers
12 views

Periodically Json Api import to MySql

I should like to periodically import data from an API Json into a MySql database, but I do not know where to start. I read hundreds of tutorials, but I did not succeed. Can someone explain to me, in ...
-2
votes
2answers
32 views

Angular 4 POST to php my sql not working

I Am trying to make a simple login check , using angular 4 , php my sql .Now i am able to send the details to the php , but i am not able to receive the status after it , i have no idea why.Simply, ...

153050per page
angop.ao, elkhabar.com, noa.al, afghanpaper.com, bbc.com, time.com, cdc.gov, nih.gov, xnxx.com, github.com,