mysql-workbench

What is there: Installed Ubuntu 16 on VirtualBox. In the settings of the virtual machine (hereinafter referred to as Ubunt ... s besides localhost? In other words, how to connect to a MySQL server installed on VirtualBox remotely using MySQL Workbench?

CREATE TABLE IF NOT EXISTS `book_shop`.`Book` ( `ISBN_BOOK` VARCHAR(20) NOT NULL, `YEAR_BOOK` YEAR NULL, `TITLE_BOOK` VARCHAR ... de: 1005. Can't create table book_shop.shoppingbaskets_have_books (errno: 150 "Foreign key constraint is incorrectly formed")

Here is the view: Why can't I delete the lines? Delete from p_p where name= "MoscoW";

I'm trying to design a database (mysql) for a future chat messenger. Here is the resulting model at the moment: I am new to ... rs) has a link to the chat of this list (dialog). I do not know if I need this connection in principle and how I will use it.

Please help me with my teaching) I'm trying to do a cascading delete and update. Creating 2 tables: create table Details( ... hat there was an error with foreign keys, but I can't understand what the problem is. Thank you in advance for your answers:)

I have a bank on MySQL Workbench with the data filled in and I want to pass that data all filled in to another MySQL Workbench, but on another computer. Is it possible to do this or will I have to fill in the data all over again?

I cannot migrate the bank from PostegreSql to mysql due to this error: Psqlodbca.so: cannot open shared object file: F ... nection string: DRIVER=PostgreSQL ANSI; SERVER=127.0.0.1; PORT=5432;DATABASE = financial; UID=postgres; usedeclarefetch=1;

I need help. I have a query in php and Mysql and I would like to add to this query the option to export the data also to exce ... "; $qr = mysql_query($sql) or die(mysql_error()); while($exibe = mysql_fetch_array($qr)){ //Todos os dados a serem mostrado

I created a table in MySQL Workbench with the following definitions: CREATE TABLE teste ( id INT AUTO_INCREMENT, nome VARCH ... e, I am doing something wrong even or every time I insert data into the table through INSERT into I have to enter the id too?

Not MySQL.. I want to update a text field, the same has about 300 characters and does not allow to do it, informed that it i ... GTEXT", "VARCHAR(1000)" and did not allow. Is it any limitation in MySQL settings or something? What to do in this situation?

closed. this question is out of scope and is not currently accepting answers. ... indows 7 Ultimate, 64 bits. Has anyone ever had this problem? Did you solve it? Any suggestions for a program similar to it?

After a blue screen, I lost my work on the workbench, but it keeps the schema. Do you have a way to recover or will I have to do the work again?

I am trying to update the local table with the cursoProunine table data with the following command: Insert into local (idlo ... ca, city_busca FROM cursosprounine; , but you are giving the error "Duplicate entry' 2 ' for key PRIMARY, help-me please?

Good afternoon guys, I'm having a problem in the Windows 10 service. I installed MySQL Server and WorkBench to work with BD a ... completely from my machine, I deleted the Registry Editor but now it gives this information up and continues in the service.

I would like to know how to manually enable the connection in MySQL WorkBench, without the aid of a command IDE such as xampp ... I will be attaching an image of the steps that were done by me. But I believe that these steps are not correct, I thank you.

When you create a MySQL code and execute, that code after executed, do you need to save it or not? Or after executed can forget it? I speak of the commands that creates table, update, insert, etc.

I'm trying to import an excel spreadsheet with 536 thousand records by mysql Workbench I saved the spreadsheet as csv but at ... ra,Linhas,Classificacao, Vigencia,mesesContrato,Fidelidade, ValorGasto,FixoEmpresa,Gestor, Celular,FixoGestor,Email,Obs);

I am not able to migrate a database from MySQL to SQL Server, using Database Migration from MySQL Workbench. In SQL Server ... ould not. I also tried changing the authentication from, Windows Authentication to SQL Server authentication and couldn't.

I have been working daily on mysql workbench. It turns out that out of nowhere the tool stopped working. I press the icon and ... kbench\log\wb" and has the following error: "Workbench]: Console redirection failed." Does anyone know how I can solve this?