All Questions

Filter by
Sorted by
Tagged with
0 votes
0 answers
16 views

I want to simplify my sum query using loop function

I have a query to summerize my data based on month between year 2021 - next years (depend on the real date) i used simple query like this to summerize the amount monthly SUM(IF(pt.description like '%O-...
0 votes
0 answers
24 views

Is there any need of log table

I am developing an application that has database of mysql having orders and orderdetails table. order table having column orderStatus. My question is whether it is necessary to create another order ...
0 votes
0 answers
99 views

Problem with connect mysql databases of remote

I'm getting error with connect remote mysql database. Firstly; 1-) I use windows 10 machine and my remote server also windows 10 machine. 2-) My database at locale at remote windows machine with root. ...
  • 1
1 vote
1 answer
3k views

Mysql Workbench 8 doesn't detect the my.ini file for my MySql 5.7 server. How can I point it to the correct file? [duplicate]

I upgraded MySql workbench to version 8. I'm running MySql Server 5.7. When I open the options file in workbench it says it cannot locate a file for MySql 8 and that it will create one in the path C:\...
  • 181
0 votes
1 answer
43 views

Handling the foreign keys in data entry

I have two tables (Order and equipment) and they should be linked together by the order No. the SQL script is as the following: -- ----------------------------------------------------- -- Table `rr`.`...
1 vote
2 answers
1k views

Creating a table with CHECK constraints in MySql workbench

I created a table ORDER using Mysql Workbench as follows: CREATE TABLE IF NOT EXISTS `rr`.`ORDER` ( `Order No.` INT UNSIGNED NOT NULL COMMENT 'The order of the inspected equipment', `Order_Type` ...
0 votes
1 answer
2k views

Unknown column in field list

Please help i dont know what i'm doing wrong. CREATE DEFINER=`root`@`localhost` PROCEDURE `setState`(IN `statename` VARCHAR(100), IN `countryID` INT(11)) MODIFIES SQL DATA BEGIN SET @...
0 votes
1 answer
511 views

calling mysql procedure return empty result

when i call procedure it gives me empty result call hussian('prstate','table_1','column1,column2,column3',1) it run but gives empty result, please help me... DELIMITER // CREATE PROCEDURE ...
-2 votes
1 answer
22 views

Can't manage to work with comparing days

In a table with persons and their birthdays, the ones whose birthday is in less than 7 days need to be displayed. I found some answers on the Internet but they all are at least 5 years ago with ...
  • 101
0 votes
1 answer
32 views

Everything is ok and x is not disappearing

Since some time ago, I've started with MySQL so I don't know Workbench very well. That little red x next to the number of the line that indicates an error does not disappear, even though everything ...
  • 71
0 votes
1 answer
1k views

Endless Query Loop In Mysql

I will delete millions records from a table in mysql dbms, but i don't want to delete all records at one time not to force database server cpu. That's why i want to use my query many times. My whille ...
  • 47
5 votes
2 answers
41k views

INSERT gives Error Code: 1366. Incorrect string value: '\xF0\x9F\x98\x80' for column

I am facing issues with my table structure : My_Table_Name1 CREATE TABLE `My_Table_Name1` ( `twitter_id_str` varchar(255) COLLATE utf8mb4_unicode_ci DEFAULT NULL, `twitter_screen_name` varchar(...
1 vote
1 answer
11k views

'SSL is required but the server doesn't support it (2026)' error while making an SSL MySQL connection

I'm trying to make an SSL supported connection using MySQL Workbench 6.3.9. My OS is Windows 10 x64 and I have installed MySQL Server 5.7 x64 with OpenSSL-1.0.2L (Win64 version). I made a non-SSL ...
  • 111
0 votes
1 answer
99 views

Not able to login to MySQL server through MySQL workbench [closed]

I have installed MySQL 5.7 server on Linux machine and am able to login to the database within the server, but not able to connect to it from Workbench. I have disabled Iptables. Port 3306 is ...
  • 9
3 votes
1 answer
11k views

How to recover a lost password in MySQL 5.7.11? (for Windows)

I am running MySQL 5.7.11 on Windows 10 I am unable to login to root through the command line client since I lost my password. How do I change/reset the old password? Please help, and thanks in ...
2 votes
1 answer
2k views

ERROR 2003 (HY000): Can't connect to MySQL server on 'xxx.xxx.xx.xx' (10060)

I'm trying to connect my local MySQL workbench to a 2nd generation MySQL instance on Google SQL platform using the following command on my windows laptop. mysql --host=130.xxx.xx.xx --port=3306 --...
  • 2,591
1 vote
3 answers
8k views

How to select mutiple values with like clause

SELECT * from table WHERE column LIKE "AAA%" OR column LIKE "BBB%" OR column LIKE "CCC%" I have more than 10 values to select, so it is not appropriate to write like the above example. Is ...
  • 11