Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
445
questions
0
votes
0answers
20 views
Who can access my MySql database [closed]
I have created a new database in the MySql workbench. If I make an application in python which updates
this database -for example, a login system that stores usernames, passwords and IDs and lets you ...
1
vote
1answer
19 views
Understanding linking tables in a many-to-many relationship
I am still working on a photo storage app (designing the database for the data for the photos stored), using MySQL, and have been told that a photo may have one or more people in it, and a person may ...
0
votes
0answers
28 views
Migration from Teradata to MYSQL over partition by
Working SQLs in Teradata
select row_number() over (partition by job_name, parent_job_name order by elapsed_sec) as rowno from schema.xyz
select min(elapsed_sec) over (partition by job_name, ...
0
votes
0answers
17 views
Attempted to import .csv into mySQL using workbench, but only imports 7 rows?
To start, I'm still a relative SQL noob so this question could have an obvious answer that I'm just missing. I'm trying to start a big practice project in my spare time using a dataset which has ~...
0
votes
1answer
23 views
Change default timezone to America Pacific
SELECT @@GLOBAL.time_zone, @@SESSION.time_zone;
Result: SYSTEM SYSTEM
SELECT CURRENT_TIME;
Result: 06:25:07
But MY System time is 11.55 AM IST and PST TIME is 11.25 PM
How can I change ...
0
votes
2answers
27 views
Issue with Auto increment in MYSQL
Current Structure in MYSQL:
CREATE TABLE `JOB_ONPREM` (
`JOB_ID` bigint(20) NOT NULL AUTO_INCREMENT,
`JOB_NAME` varchar(255) NOT NULL DEFAULT '',
`SANDBOX` varchar(100) NOT NULL ...
1
vote
1answer
35 views
SQL Trigger that creates new table when a new record is added to current table
It's been quite a few years since I have done DB work. I am working through mysql workbench (using MS Access as a frontend).
I have a base table that I am multilinking (basically a name index type ...
0
votes
0answers
14 views
Storage fluctuates when creating a table as select from another table via python
My table "test_table2" holds around 12mil records and has 6 columns with small records (short strings, dates, etc.). The size of the table is cca 1 GB.
When I'm running this query:
create table db....
0
votes
1answer
98 views
MySql Workbench csv data import error
I' trying to import a csv file in MySql WorkBench but get an error:
Can't analyze file. Please, try to change encoding type. If that doesn't help, maybe the file is not: csv, or the file is empty. ...
0
votes
1answer
31 views
Obfuscate data during migration with MySQL Workbench
Is it possible to obfuscate sensible data during migration using MySQL Workbench?
We are going to work on site so we need to make a copy for develpment but the (MySQL) database contains sensible user ...
1
vote
1answer
31 views
MySQL - is there a way to implement a CHECK constraint after creating the table?
I created a table and after entering all the data, I found that I had missed a CHECK constraint in the CREATE TABLE statement.
create table jims_faculty
( fac_id int primary key,
fac_name varchar(15) ...
0
votes
1answer
21 views
MySQL Workbench Model sync sql_mode
Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution"
When I open a Workbench Model, and use the "sync with any ...
0
votes
1answer
32 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 @...
1
vote
2answers
68 views
Error Code: 1136. Column count doesn't match value count at row 1
I'm struggling here. This is my code
CREATE DEFINER=`****`@*****` PROCEDURE `setCountry`(
IN `countryname` VARCHAR(100) CHARSET utf8mb4,
IN `nationality` VARCHAR(100) CHARSET utf8mb4,
IN ...
1
vote
2answers
30 views
SQL case statement not executing else part
Problem statement:
Create a function to search a student with roll_no; if exists show "Student Name and Course" else show "Roll No not exist".
CREATE FUNCTION search(roll_num VARCHAR(50))
RETURNS ...
0
votes
2answers
53 views
Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1
I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy.
The date column in the table is defined with ...
0
votes
0answers
514 views
DBeaver: Access denied for user 'root'@'localhost' (using password: YES)
Context: I am creating a new Schema and looking to import .sql file generated from mysql dump. I have server running: MySQL 8.0.19.
I am using DBeaver client Version 7.0.2 and have setup a new MySQL ...
0
votes
0answers
25 views
unhandled exception:invalid column partition_name for resultset
I am a beginner of Mysql partition.
I create a table like this:
CREATE TABLE t1 (c1 INT, c2 CHAR(5), c3 DATE)
PARTITION BY HASH( YEAR(c3) )
PARTITIONS 4;
And then I tried to select the ...
-1
votes
1answer
40 views
Problems with remote ssh access to mysql with Workbench MacOS
I am having problems connecting Workbench with Siteground.
All my connection settings are as instructed, however my question is do I have to open port 3306 on my Mac to connect to the Siteground ...
0
votes
1answer
50 views
Connection failed: No such file or directory Mysql - WSL
Sorry if i posted incorrect section.
I have Windows with this WSL:
PRETTY_NAME="Debian GNU/Linux 10 (buster)"
NAME="Debian GNU/Linux"
VERSION_ID="10"
VERSION="10 (buster)"
VERSION_CODENAME=buster
ID=...
0
votes
1answer
295 views
Error Code: 1416. Cannot get geometry object from data you send to the GEOMETRY field
I am trying to run .sql file/import into MySQL database, however, I am running into Error Code: 1416. Cannot get geometry object from data you send to the GEOMETRY field .
Here's my code:
CREATE ...
0
votes
1answer
21 views
MySQL Workbench: I need to update values in a table based on values from a csv
Newbie Problem, but I've tried creating a new table and importing the csv to that then updating, but I have been having trouble with that, any guidance would be greatly appreciated.
I have a csv file ...
0
votes
1answer
19 views
Where can I get a proper dataset for performing Normalization techniques? [closed]
I'm new to databases and I just started with learning different techniques of Data Warehousing. I was given an assignment to perform Normalization techniques on a dataset of at least 1000 rows with ...
1
vote
1answer
30 views
Should pivot tables have more columns (many to many relationship)
I'm currently thinking about how to organize my tables, and I have some information that I'm not sure were should be, one of them is the quantity of a food in a refrigerator
Is it right if I add ...
0
votes
0answers
46 views
Importing csv file error 1059
I'm trying to import a csv file circa 30GB. I have a MySql server running remotely on a vm. When i try to import the csv file I receive the following error
is too long 1059
I'm using MySql ...
0
votes
1answer
33 views
Mysql import csv not complete by Mysql bench
I upload the csv file which has more than 5 thousand rows table data for option import wizard by Mysql Workbench. As the result the output table only 335 rows, have no idea how to overcome the ...
0
votes
1answer
22 views
mysql workbench can't write to sql history file
I'm running mysql workbench on my local machine, connected to a remote sql server.
I am able to apply changes to the database, however, I see this error every time I apply a change
I can't seem to ...
0
votes
1answer
56 views
Select rows from table having more than two specific values
I have a table having details such that
Userpin product Time1 contains
4556 23 7:30 A
4557 23 7:30 B
4558 23 7:30 C
...
0
votes
1answer
18 views
Detect with Left Join duplicates entries and return the first value, also return sum of duplicates entries
¡Hi!, i have a case with two tables than can have a lot of matches entries and the time of fetching increases a lot.
This tables can be
Table A: Employees
-------------------------
| Name | ID | ...
0
votes
1answer
57 views
problem to import load data infile
I am trying to load data into mysql database form text file.
LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january
FIELDS TERMINATED BY '\t'
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
IGNORE 1 ...
0
votes
0answers
18 views
How import document when fixed width?
I need to import into a table files with TXT format and delimited by fixed width.
I'm trying to model a script to perform bulk import, and I'm not able to declare.
0
votes
2answers
37 views
MySQL query duplicates from 2 columns [closed]
I need to query duplicates in a table from 2 columns (agents_name) and (estates_name) based off the (display_name) column.
I tried the following:
SELECT id, display_name, author_table.agents_name, ...
2
votes
3answers
72 views
Table Creation Order
I have designed my database model with entities and they have relations along with normalization. Now I want to implement my design in my database engine. Before implementing I am puzzled with the ...
0
votes
0answers
71 views
error while importing data in MySQL workbench
I tried to import data from a dump file on MySQL workbench 8, it is showing the (unknown database) error with code 1049 (42000)for each table in the database,
is it because I exported data from a ...
0
votes
1answer
37 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 ...
0
votes
1answer
216 views
Is it okay to use MySQL Workbench with MariaDB? [closed]
Workbench 8 gives me a warning when connecting to MariaDB, but it appears to work fine. Since MariaDB is based on MySQL, would it be a problem to keep using it?
-2
votes
1answer
19 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 ...
-1
votes
1answer
58 views
Define user variables to use in a SQL that has an “in” statement in MySQL Workbench
I am trying to use defined variables in MySQL Workbench.
I am using version 6.3 of Workbench.
I am trying to run ad hoc queries that can have a value or multiple values:
If I have a single value, the ...
0
votes
1answer
24 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 ...
0
votes
1answer
36 views
Comparison and creating new column
Table A
> - Product#|Customer|state|Type
Glasses |mr. Xyz | MN |Instore
Glasses |mr. abc | MN |Instore
perishables|mr. abc12| TN |Instore
N-perishables|mr. abc122| ...
0
votes
0answers
24 views
Unable to connect to DB using Mysqlworkbench
I am running a Mysql db inside docker container as shown below:
Adding a new user from within the container and logging in with same user works fine within the container but the same doesnt work when ...
0
votes
0answers
31 views
Why does MySQL Workbench hang forever on queries that run instantly via command line?
This query (and others like it) fail to run on MySQL Workbench but returns results nearly instantly when I use SSH to log into the server and then log into MySQL and paste the query in the terminal ...
1
vote
1answer
775 views
MySQL Workbench, Windows Server 2019, MySQL not showing Performance, Information of MySQL Schemas!
This evening I installed MySQL on a new clean install of Windows 2019 server. When the install finished, the installer offered the possibility of opening Workbench so I said yes.
Then I noticed that ...
0
votes
1answer
698 views
Is it possible to run multiple versions of MySQL Workbench?
I'm doing an application migration from MySQL 5.5 to workbench v8... 5.5 supports MySQL Workbench up to version 6.3... However, MySQL server 5.5 only supports up to version 6.3 of the workbench.
I ...
-1
votes
1answer
113 views
Follow up to multiple result tabs in Workbench
@Mike Lischke -- this is in response to your reply to my question here regarding multiple result tabs (Multiple Result Tabs in Workbench)
This is a screenshot of the tutorial I am viewing to teach ...
0
votes
1answer
486 views
Multiple Result Tabs in Workbench
I have several queries in the editor, each terminating with a semi-colon (I am teaching myself SQL and so in the editor is a mix of queries and notes like below):
SELECT *
FROM orders
WHERE ...
0
votes
0answers
10 views
Syntax error when creating procedure in mysql
I am trying to create a procedure, but I am always getting syntax error and it is marking me "(" or ",". Iam using version 6.3. Can somebody help me to fix this problem? And here is my code
0
votes
0answers
18 views
prepared statement returns NULL, unable to retrieve the column value
I'm creating a procedure where it will iterate over every column in a table and get maximum value of every column. This is my code:
DELIMITER //
DROP PROCEDURE IF EXISTS min_max //
CREATE PROCEDURE ...
1
vote
2answers
28 views
ALTER TABLE DROP COLUMN - server status 'Stopped'
I am in the process of removing 4 columns from my (MySQL/innodb) table,
simple code,
ALTER TABLE database_name.table_name
DROP COLUMN A,
DROP COLUMN B,
DROP COLUMN C,
DROP COLUMN D;
It has been ...
0
votes
0answers
15 views
Import mysql tables and data into Sql server2008, when mysql is on a remote server and sql server 2008 is my local server
I am trying to import mysql tables and data (on a remote server), to sql server local database. I have exported data from mysql workbench and saved them as .txt and then imported flat text files into ...
