Questions tagged as 'mysql-workbench'

1
answer

Query to return text from the middle of a field

I have a query that returns some class names / disciplines , however I wanted it to bring me just the names of the disciplines . Below is the result of the query with the [class] [discipline_name] [branch]: ADM N1A OFFICIAL COMMUNICATION...
asked by 09.02.2018 / 22:35
1
answer

Catch image in database

I wanted to know how I could retrieve an image from the database, used php7, the image is stored in the database in type BLOB, I searched the internet and they were very old examples and none worked here, could anyone help me?     
asked by 07.03.2017 / 12:48
1
answer

Lost my script to recover?

After a blue screen, I lost my work in the workbench, but keep the schema. Can you recover or will I have to do the work again?     
asked by 23.06.2017 / 06:23
1
answer

MYSQL - FK ERROR

Hi, could you help me? I am trying to add the FK in the table officials, only it is giving this error OBS I am creating the other tables before the officials 20:29:15 CREATE TABLE Funcionarios( id INT(5) NOT NULL AUTO_INCREMENT, nomeComplet...
asked by 13.09.2015 / 01:03
2
answers

Perform automatic MySQL backup

I'm using MySQL as a DBMS, and while searching the internet for a way to create a backup routine I found that older versions had a tool that no longer exists in newer versions, uses MySQL was not in the old versions. I would like to know if...
asked by 19.06.2015 / 15:57
1
answer

Export search result to .Txt

I use the MySQL Workbench. I would like to know how I can save the result of a query in a txt file. and that is separated by tabulation, I've tried everything else right.     
asked by 16.06.2015 / 19:12
3
answers

Foreign Key in another database?

Doubt in MySQL ... What are the possible problems that can occur when doing a foreign key in different databases? Considering this type of foreign key and a View that looks for information from another database, which one is most useful?...
asked by 31.07.2014 / 19:26
1
answer

Error executing the PASSWORD function in MYSQL SERVER (SQL SYNTAX ERROR 1064)

Error executing the PASSWORD function in MYSQL SERVE I have the following query: SELECT * FROM users WHERE login = 'FABIO' AND pwd = PASSWORD('2018') LIMIT 0, 50000 You're giving this error:    Error Code: 1064. You have...
asked by 13.09.2018 / 15:39
1
answer

Generate Script MySql Workbench

Good afternoon. I use MySql Workbench 6.3. I need to generate the script to create the local database to publish to the server. It is completely impractical to create everything again in the hand because the base is huge. How can I do this...
asked by 15.05.2018 / 20:12
1
answer

Calculate average length of service

Well, I need to take the average number of calls and I have the following data: 00:12:35 00:05:10 00:01:42 00:08:12 00:01:01 {...} The question is, how can I do it? I searched for a way to do this using Mysql's AVG but I did not succeed ......
asked by 17.01.2018 / 19:37