Questions tagged [mysql]

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.

0
votes
0answers
7 views

How to Calculate Employment Experience with Special Case

I've been having a difficult time figuring out the correct way to calculate the years of experience so, any help is really appreciated! let's say someone has multiple employments as follow: startdate ...
0
votes
0answers
7 views

IO file not found in mscorlib.dll

I am working on some old project in c# (visual 2015) and I am getting the following error without any additional info : Exception thrown: 'System.IO.FileNotFoundException' in mscorlib.dll can ...
0
votes
1answer
18 views

Delete html files from path

I'm trying to create a classified site from scratch. I was thinking for each ad that is published to create an html file. If I delete an ad from the database the html still remains. There is a way to ...
0
votes
0answers
7 views

Cannot select where ip=inet_pton($ip)

I have a unique column in database which is named ip IP addresses are stored in this column as BINARY(16) (with no collation) after converting them using the PHP function $store_ip = inet_pton($ip);...
0
votes
0answers
3 views

Symfony doctrine:mapping:import doesn't import the reflective associations tables

I have a mysql database, where I have a few tables. Two of them are reflective association table, the association table R-asso reference two lines of a table A. The association table contains ...
0
votes
0answers
4 views

Measure value of fact table is wrong in Tableau

I had created a fact table and when i deploy the cube and visualise the data in Tableau, aggregate value is getting populated. Below is my fact table(where id1=1) with header changed for readable ...
0
votes
0answers
11 views

Example filter hook to update item with related field

I have 3 collections: 'customers', 'resellers', and 'orders'. Customers are related to resellers by a many to one relationship. Resellers are related to customers by a one-to-many relationship. Orders ...
0
votes
0answers
8 views

How can I copy JSON data from column “X” and insert into DOUBLE type column “Y”?

I am taking population data from the info column that has datatype of JSON and need to copy the population size into the population column of type double. I am able to select the JSON data, but I am ...
0
votes
0answers
15 views

Laravel Eloquent filter in a where in

I have a system filter that is working fine right now but I want to be even more percise with my filters but I'm having some troubles on how I should do it : I'm getting some equipements with ...
0
votes
0answers
17 views

how to make many columns unique in same table

ALTER TABLE `registered` CHANGE `Email_ID` UNIQUE KEY ( Email_ID) ) ; #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right ...
0
votes
0answers
17 views

PDO Insert multiple rows into MySQL a table

I am trying to insert multiple lines in a single query based on this example: [a link][1]: http://thisinterestsme.com/pdo-prepared-multi-inserts/ But the values are not inserted. $pdo = new PDO(...
0
votes
1answer
9 views

MySQL CREATE VIEW targeting variable table name (columns names)

I want to define a lot of views but the model of the DB is changing so there are some ideas/questions that came to my mind: Is there any way in MySQL 8 to create view that after FROM has not ...
-1
votes
1answer
15 views

How to join multiple tables together in a query

I am fairly new to MySQL and am having a problem getting data to pull into a table from multiple tables (if that makes sense!) I can get the data out in rows, but not columns - where am I going wrong? ...
0
votes
0answers
19 views

Php Multi query to table form

I am using PhP and Mysql. I am new on this and i want to query my 3 tables into a html table. <?php $conn = mysqli_connect('localhost', 'root','') or die("Error ".mysqli_error($conn));?> ...
-3
votes
0answers
11 views

How i can develop Search bar in my ebay Store Jquery

i want to add advance search bar in my ebay store Category drop downs please check image attached for reference. any solution or advice for this screenshot let me brief again as i see this is ...
0
votes
0answers
9 views

How use legacy password encryption on mysql server 5.5 win10 32bit

I want to connect MySQL 5.5 with a Visual Studio 2017 application, because it doesn't support the newer MySQL 8.0, just 5.5... It throws this inner MySQL exception: authentication to host '...
-2
votes
0answers
9 views

Problem with loading data in database on godaddy server

Did he have a similar problem? At xampp everything works normally, but when I add a site to godaddy hosting, it does not show me any error, but nothing is added to the database. Please help I do not ...
0
votes
1answer
14 views

Exclude one column from group by in a join

I have an aggregated query: SELECT SERIAL, pos_id, MIN(fecha) FROM pvs WHERE pos_id = 50 GROUP BY SERIAL, pos_id ORDER BY MIN(fecha) DESC; and it works quite well to get the information I need, ...
0
votes
3answers
20 views

PHP in MYSQL db execute statement really slow

I'm building up a php website for a company that displays information of a database in MYSQL, but sometimes it takes about 20 seconds to load that information, and It just happens randomly. When ...
0
votes
1answer
13 views

How to redirect users to different pages based on session data in PHP? [duplicate]

I'm currently trying to redirect a current user type to it's specific site using sessions, whilst also creating a session to check if they are logged in. The users are all in the same table and have ...
0
votes
0answers
8 views

Querying in multilevel JSON in MariaDB/MySQL for specific value

I'm working with a MariaDB table that has a JSON value stored as follows: {"nextValue":4,"1":{"text":"Item1","textDisplay":"","value":1,"isActive":0},"2":{"text":"Item2","textDisplay":"","value":2,"...
0
votes
0answers
13 views

mySQL LOAD DATA LOCAL INFILE comma seperated

I'm trying to use LOAD DATA INFILE to insert a csv file into a mySQL table. All the columns in the db table are text fields. The data i'm inserting looks like this: Store,Sales London,"500,000" New ...
0
votes
0answers
18 views

Drop down parameter is not getting updated

I have a drop down with three options(report 1, report 2, report 3), and on selecting one of them nothing gets update as I try to view my report. SELECT ProjInfo.ProjName, ServerInfo.ServName, ...
-1
votes
1answer
16 views

MySQL select all, having one column DISTINCT whilst also returning other corresponding columns

I have the following table: +-------------+---------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +-------------+-------------...
-1
votes
0answers
17 views

POST method via Android.Volley won't update db and VolleyError just returns “8.onErrorResponse:”

I'm trying to update a MySQL db from my app using Volley. The POST method I'm using to retrieve data works fine but I can't for the life of me get the db to update. The VolleyError just simply gives 8....
-1
votes
0answers
6 views

#1227 - Access denied; you need (at least one of) the SUPER privilege(s)

I get this error using GoDaddy hosting: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation How can I fix this error? CREATE ALGORITHM=UNDEFINED DEFINER=...
0
votes
1answer
18 views

MySQL relation without using foreign key references

I have question about making relation between two tables in mysql. I create table with column which is foreign key, but I dont use foreign key references keyword. I connect tables in code(php/asp.net)....
0
votes
0answers
12 views

Selenium python script working but its not click or entering any value firefox

script working completly but its not entering any data. here my code : from selenium import webdriver from selenium.webdriver.support.ui import Select import datetime from login_credentials import * ...
-1
votes
0answers
4 views

Having trouble loggin into phpmyadmin [duplicate]

New install of phpmyadmin, mysql, apache on a redhat server and unable to login to phpmyadmin. We have uninstalled and reinstalled everything except redhat7, changed the config to reflect a password ...
0
votes
1answer
10 views

How to fix the arabic encoding problem in the data transfer from ms-access to mysql?

I tried to transfer arabic data from MS-Access to MySQL and display it on php page using datatables API. My code is exactly this: <meta http-equiv="Content-Language" content="ar-lb"> <meta ...
0
votes
0answers
25 views

inner join very slow, how to optimize?

I want to find the intersection of multiple queries on the time attribute. I tried this inner joining all of them but it takes an extreme amount of time, and never finishes. SELECT pdx....
0
votes
1answer
13 views

Troubles installing MySQL 8.0 on Ubuntu 18.04

I have a freshly installed Ubuntu 18.04 server. I want to install MySQL 8.0 on it so I issued the following commands that I found on the web wget -c https://dev.mysql.com/get/mysql-apt-config_0.8.10-...
0
votes
1answer
21 views

How to compare if the time between two dates is between two other dates?

I want to compare if the time between $begin and $end is between starttime and endtime. My table has the following layout: id - name - starttime(in datetime) - endtime (in datetime) Example entry ...
0
votes
0answers
17 views

How can I modify code in Adobe ColdFusion Report builder to show only the last four digits of SSN?

I have a report that shows the first four digits of SSN. However, I need to revise a report to show the last four. Nothing I have tried seems to give me the correct result. I either get an error in ...
0
votes
0answers
18 views

Upgrading MySQL 5.5 to 8.0, getting different results for query, need help understanding why

I'm in the process of testing a MySQL upgrade for our application from 5.5 to 8.0. I've encountered a few queries that return slightly different results and have been able to make it somewhat generic ...
0
votes
2answers
15 views

Get Total Value From Second Table and Display it in Table

I have one HTML/PHP Table in which I am displaying value from one of my MySQL database table called tbl_project. It have example fields like id, name and quantity. Its displaying fine using below ...
0
votes
1answer
24 views

MySQL/VB.NET(Winform) - How to use correctly @var?

I am developing a sequence in MySQL & VB.NET in which, when deleting a record, the number that identifies it, is deleted and put a sequence of 1 to 'n', the sequence is as follows. this is the ...
0
votes
4answers
38 views

How to get SQL SELECT to only show columns that triggered results in WHERE clause

Is there an "efficient" (in a single statement) way to get MySQL to only display columns that triggered results in the WHERE clause when multiple conditions are used? I know this can be done by UNION ...
0
votes
0answers
8 views

Column type issue when transferring bulk data between MySQL to Hive through Sqoop

I'm trying send data from my MySQL thought Sqoop to Hive database. After run, this execution stops with a issue in the column type: 19/03/25 14:26:37 INFO mapreduce.ImportJobBase: Publishing Hive/...
0
votes
0answers
28 views

How to compile Java application project into an executable .jar file?

Long read for context ahead, so please bear with me. I'm doing a small college project on Java, where we need to create a functioning Java application that connects to a mySQL database and does a ...
0
votes
1answer
33 views

Upload CSV file to mysql from external URL

For example I have an url from google sheets that exports a sheet to a CSV file: https://docs.google.com/spreadsheets/d/{key}/gviz/tq?tqx=out:csv&sheet={sheet_name} I want some sort of mechanism ...
0
votes
0answers
25 views

Selecting Date from database column filtered by month and year

I have a database column, sales_date which stores the date a particular sales took place. The data is stored using PHP date(). how do i select data from rows using date and time as filters? i have ...
-5
votes
1answer
24 views

How to create a table in MySQL

I’m having a hard time trying to create this table for school. set A TABLE WITH 100 ROWS, Each Row HAS 2 COLUMNS, COLUMN 1 IS AN IDENTITY COLUMN, COLUMN 2 IS A RANDOM LETTER (THIS COLUMN IS 6 ...
-1
votes
1answer
25 views

mysql creating rows to column

I want to convert mysql rows to column, i tried but didnt get the required output. Thankyou In Advance. my table query is First Table CREATE TABLE `variant_to_group` ( `variant_to_group_ID` int(11)...
0
votes
2answers
20 views

MySQL Query across 40,000 rows v/s one time load and for loop

I have a table which has 40,000 rows. From code side around at same exact second about 20,000 users will need to run a query to find their related row. What is better approach here ? Loading all 40,...
1
vote
1answer
21 views

Remove MySql database table on remote server from C# application

If I can create MySql database table on remote server from C# desktop application string createTableQuery = string.Format(table, tableName); and var cmd = new MySql.Data.MySqlClient.MySqlCommand(...
0
votes
0answers
15 views

I cant figure out how to get these querys in one query where I get max relation and min relation?

SELECT C.Name AS Country, SUM(T.Population) / C.Population AS Relation FROM Country C LEFT OUTER JOIN City T ON C.Code =T.CountryCode WHERE C.Region ='Nordic Countries' ...
1
vote
2answers
21 views

When Delete button hit, image needs to be deleted from table, error message showing instead

I have a gallery where I want the user to be able to update the image title and delete the image if they wish. My update the title code works as expected, and I assumed the delete code wouldn't be far ...
0
votes
2answers
15 views

MySql - how to find records that have 2 specific values ​in a field, and no more

I have a "rel_type" table, with 3 fields: id, id_customer, id_type, I must uniquely get the id_customer that have only values ​​9 and 11 as id_type. So if I have recods that have these two values ​​...
-1
votes
1answer
28 views

How to check if data is already in MySQL DB with PHP?

I'm trying to check if the user's data is not already in use before creating the account on my website. What I tried (code below) was make a query to each data that has to be unique (email and phone) ...

http://mssss.yulina-kosm.ru