Questions tagged [mysql-workbench]

MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.

0
votes
1answer
17 views

Ineffective regexp in MySQL 8

I have this query which should exclude some characters (thos inside the square brackets and starts with ^). So my query is: select col from tbl where col regexp '[^<\\\]*=[^<\\\]*(;|$)'; I ...
0
votes
0answers
7 views

Why is this user able to execute update queries more than the limit I set using WITH MAX_UPDATES_PER_HOUR 5?

I am the root user and, through the workbench GUI, I have created a user called kop with all privileges except for GRANT OPTION and altered this user to execute update queries 5 times in an hour. I ...
1
vote
0answers
19 views

How to update the version of the MySQL engine in ClearDB?

By default, heroku only works with the postgreSQL database. However, there is a ClearDB plugin that allows you to use a MySQL database. The problem is that this plugin uses the old version of the ...
0
votes
0answers
18 views

Cant reset MySQL root password window 10

I tried to use this solution by use this console command mysqld --init-file=C:\mysql-init.txt and it start the mysqld.exe and i can connect to the database with the new password. But after start, it ...
0
votes
0answers
6 views

Cannot restore SPs, triggers, views created by the same user but from different host [duplicate]

I have MySQL DB running on shared hosting. I have a direct access via phpMyAdmin on hosting site itself (db_user1: my_user@localhost). And I have remote access via MySQL Workbench (db_user2: my_user@...
0
votes
2answers
35 views

mysql - How to limit certain records in a SELECT query

Okay, so I have a relation of students who enrolled in multiple subjects. Most of the students were enrolled in only one year, either 2015 or 2016, but I have one that is enrolled in subjects from ...
-1
votes
0answers
21 views

Cannot connect workbench to mysql server

I am stuck with 2 days , cannot figure out what's happening . Need your favour, From the commandline i am able to create a database and when i write command show databases; it's show's me all the ...
0
votes
0answers
16 views

Mysql - Insert Millions of rows in chunk

We need to insert 2 million rows in a table and what we are thinking to insert rows in a batch of 10000 rows each time, so that Mysql query won't excedded its size. We are planning to insert 10000 ...
0
votes
0answers
13 views

Mysql - Fast way to insert Millions of rows using Store Procedure [duplicate]

We are in a business use case in which we need to insert Millions of rows based on coming inputs in one go under actual business tables. I have an idea that we can use for loop over the input list ...
0
votes
1answer
22 views

MySQL query to concatenate data from multiple columns

I need to retrieve data from the database.I have created a table vendor that includes vendor_name, vendor_code, etc,. I wish to get the result in the exact way as given here vendo Ali Murtaza have ...
0
votes
1answer
29 views

Can't create table in database

I have my code to make a room booking database, but whenever i reference one part for a foreign key in a table, an error comes out and i still cant solve the problem DROP TABLE IF EXISTS ROOM; DROP ...
-5
votes
1answer
28 views

i am having issues with loading csv file to mysql

Basically I want to load csv file to two mysql tables with only particular fields in one table and some other fields in another table these are the table definitions - https://imgur.com/c7Scdkm and ...
0
votes
1answer
22 views

How to replace two sub-strings in one field and insert the result in another field in MySQL

I have a field oldCol that contains string separated by , (comma). I just discovered that this is inconvenient as the ,can exist in URLs. So I want to replace it with a character that can never appear ...
0
votes
1answer
17 views

Cannot Delete General Log File for MySQL - Shows Still Open In Workbench

I am attempting to delete the General Log File for MySQL, but I get the message 'The action can't be completed because the file is open in MySQL Workbench.' I don't see the log file open, and I ...
0
votes
3answers
20 views

MYSQL query to find strings that are like a concatenated string

I have a sales database that contains all of our sales and credits by invoice number. I need to find all invoices that do not have a credit issued against them. Luckily, our credit memos are the ...
1
vote
2answers
32 views

How can I select all tables with a certain amount of foreign keys in them?

How can I select all tables from a database which have for example one foreign key in it? Can I as well get all tables in my database in ascending order in regard of the number of foreign key? Thanks! ...
0
votes
1answer
35 views

MySQL instance won't connect (AWS)

I am trying to connect to an AWS RDB (MySQL) via the MySQL Workbench and cannot establish a connection. The database is URL, name, and password are correctly configured and actually worked a few days ...
0
votes
0answers
16 views

Is there a differecnce between usign 'col. not regexp' and 'not col regexp'

Is there a difference between using: select * from test where not mycol regexp myregexp And select * from test where mycol not regexp myregexp
0
votes
1answer
26 views

Convert MySQL table from one vertical column to multi horizontal columns

I want to convert that table id | main_id | image 1 | 10 | 52343.jpg 2 | 10 | 52344.jpg 3 | 10 | 52345.jpg 4 | 11 | 52346.jpg 5 | 11 ...
1
vote
1answer
18 views

How to find my database ConnectionString in mysql Workbench

I'm setting up a setting.properties in my project where i can access my mySQL workbench database from my project and grab some datas. Where do i find my connection String in the program?
0
votes
1answer
30 views

cumulative function in query wont group by

I am trying to reset the cumulative count for every kind of insurance_status. right now my code brings back a cumulative count but does not start over when the insurance_status changes. how can I set ...
0
votes
0answers
26 views

Can't use JSON data type in MySQL 8+

I have MySQL workbench 8.0 and the MySQL version is version, 8.0.16 on Ubuntu 18.04. I obtained the MySQL version using this command from the MySQL workbench: SHOW VARIABLES LIKE "%version%"; I ...
-1
votes
0answers
27 views

'users' & 'authorities' relationship failed with jpa nnontation

i would like to make a authentication jdbc with spring security and have made two entities user authorities, my problem is that when jpa create tables in mysql database there is no relationship made, ...
0
votes
2answers
24 views

Create trigger before insert

I want to create a trigger in Mysql. Before Insert and before Update , to only insert the values if the ID is present in another table. Here is my trigger (before insert) which does not work: ...
1
vote
2answers
27 views

removing the foreign key from the tables [duplicate]

I am trying to learn working with SQL and I am coding in mysql workbench and I can't understand why the code in below doesn't work. It says it has a syntax error but I don't know where. ALTER TABLE ...
0
votes
1answer
39 views

NU1202: MySql.Data.Entity isn't compatible with monoandroid81

I am trying to start my first Xamarin project and I got some issue while trying to install the MySqlEntity NuGet package. Severity Code Description Project File Line Suppression State ...
0
votes
1answer
13 views

Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint 'questions_ibfk_1' in the referenced table 'category'

cannot add foreign key constraint to table create table users ( user_id int auto_increment primary key not null, username varchar(50) unique null , email varchar(50) unique , passwords ...
0
votes
0answers
21 views

Trouble with created database returning null values for queries

I created a database to keep track of congressmen in two different states. I used MySQL Workbench's ER diagram GUI to create it, and to also insert values into each column. I spent hours inserting ...
0
votes
1answer
16 views

Cant connect to mysql db by workbench but can log in via terminal

Im trying to connect to a mysql database crated on my local, however when I try to log in on mysql-workbench I get the following error: Access denied for user 'root'@'localhost' (using password: ...
0
votes
1answer
15 views

How to fix Error 1064 while creating tables with foreign keys?

MySql workbench tells me I have an error in my SQL syntax that corresponds to my MariaDB server version and I don't know why. I've already looked at other questions but none of them seem to help so I'...
0
votes
1answer
22 views

MySQL: wiered chopping for string when using “SELECT INTO OUTFILE”

I exported two fields: name and header from the database using: SELECT name, header INTO OUTFILE '/var/lib/mysql-files/myfile.txt' FIELDS TERMINATED BY '<xx>' LINES TERMINATED BY '\n' FROM ...
-1
votes
0answers
25 views

Can't export data properly from MySQL into a file

I have a large table. I need to export two fields form it. I use this command: SELECT col1, col2 INTO OUTFILE '/var/lib/mysql-files/f.csv' FIELDS TERMINATED BY '<xx>' FROM table1; The data ...
0
votes
1answer
34 views

Creating Subquery with linking table and source tables mysql

I'm receiving an error when I try to create a query from a linking table and it's two source table. When I ran this in access, it actually worked fine but mysql produced an error stating I needed to ...
-1
votes
0answers
31 views

MySQL 1064 error when query is from php but not from MySQL Workbench or phpMyAdmin

I am writing some php code to get data out of MySQL 5.7.23 database. When when the query executes it gets 1 1064 (You have an error in your SQL syntax; check the manual that corresponds to your MySQL ...
0
votes
1answer
27 views

SQL Query to select only certain data and remove unnecessary data

I am looking for a query to select only data which is needed. Eg: hhhhhhhh@gmail.com#2 hhhhhhh2@gmail.com#3 i need a query which would only select email and remove data after this.
0
votes
1answer
26 views

Getting error 1822 in MySQL when trying to create a foreign key

I am getting an error when creating a foreign key. The error is 1822 and it says the following: Error Code: 1822. Failed to add the foreign key constraint. Missing index for constraint '...
0
votes
0answers
28 views

Regex in MySQL: How to match every occurrence of a key against a value pattern?

I have these data: What I need to do: 1) For every occurrence of My-Name dictionary key (which can occur 0 or more times), check that it is followed by a variable assignement AND has both words Good ...
0
votes
4answers
27 views

Selecting where data `not exists` and selecting columns that are empty or `is null` - MySQL

This is the query I have currently: select * from outerb where not exists( Select * from wms where wms.barcode = outerb.barcode); This query returns me values that I need. So far so good... Next I ...
0
votes
0answers
14 views

how to write csv or any file to mysql database from python

I have to write inputs from python to mysql database by loading csv file into my sql from python. when using to_sql iam getting below error DatabaseError: Execution failed on sql 'SELECT name FROM ...
0
votes
2answers
39 views

Database and Showing Results

I'm new in coding. It seems that I can't produce the result in this one. I am creating an RFID Tap Card System. When I tap the card (with info in the database), the data will be saved (PictureBox1 ...
0
votes
1answer
20 views

Create function that returns a “SELECT” statement result

I was told to create a mysql function that, given the artwork title, return the name of the creator. I know it sounds silly, i could use just a select. I followed some tutorials, but none of them ...
-1
votes
0answers
35 views

Unknown column error in SQL Workbench but not in Toad

SELECT teacher_name, teacher_subject FROM teacher_table t1 INNER JOIN teacher_allocation_table t2 ON t1.teacher_id = t2.teacher_id; I am trying to run the code in SQL WORKBENCH,I ...
0
votes
0answers
15 views

how to unpivot the dynamic pivot table in mysql

i created employees table in that i grouped by emp_profile with respective to names and salaries.i used dynamic pivot for that.now i have to unpivot the dynamic pivot.i used static method for that but ...
0
votes
2answers
29 views

Regexp not working with single/double quotes

I have a field called myfield that contains this string: {'Content-Language': 'en', 'X-Frame-Options': 'SAMEORIGIN', 'X-Generator': 'Drupal 7 (http://drupal.org)', 'Link': '<https://01.org/node>...
0
votes
1answer
23 views

I was wondering if anyone knew how to find the min value and a max value and find the timeframe between them?

im working with a movie database I made and I wanted to make a select query that would separately select the the movie with the highest revenue and the movie with the lowest value and find the ...
1
vote
2answers
90 views

How to load data infile mysql workbench for AWS RDS?

I am trying to import a CSV file into my AWS RDS database through mysql workbench by using Load Data Infile. I was able to load the data infile for a local db I created. For that local database I used ...
1
vote
0answers
20 views

How to create recursive function to find out hierarchical order in MySQL

I have the following table with a list of employees, its name, and the employee that is in charge of them. (ex. IDEmployee 1001 reports to IDEmployee 1000) IDEmployee Name ReportsTo 1000 A ...
-2
votes
0answers
21 views

SQL - Create a new table that returns every value in column 2 against unique values in column 1

UPDATED Sorry, new to this let me try again. I have this SQL code: USE data; SELECT email,GROUP_CONCAT(competition_id) FROM alldata; GROUP BY email; This returns all unique email addresses in column ...
0
votes
1answer
24 views

Django FutureFqType matching query does not exist

I'm setting up a new website using Django, and want to get an object name from sql . But it keep output the error objects.get matching query does not exist Where do I need to modify the code? views ...
0
votes
1answer
30 views

How to connect HTML page to MySQL Workbench Server using JavaScript,Ajax and PHP?

I have an HTML page where we enter the name of a movie and if that movie is present in the database,then the name is displayed. I am trying to connect to the database using JavaScript, Ajax and PHP. ...

http://mssss.yulina-kosm.ru