This is likely because you have named at least one constraint with the same identifier as a column: /* You already have a column named `restaurant` in this table, but are naming the FK CONSTRAINT `restaurant` also… */ CONSTRAINT `restaurant` FOREIGN KEY (`restaurant` ) REFERENCES `mydb`.`restaurants` (`id` ) ON DELETE NO ACTION ON UPDATE NO … Read more
The main reason why the error has been generated is because there is already an existing value of 1 for the column ID in which you define it as PRIMARY KEY (values are unique) in the table you are inserting. Why not set the column ID as AUTO_INCREMENT? CREATE TABLE IF NOT EXISTS `PROGETTO`.`UFFICIO-INFORMAZIONI` ( … Read more
I ran into this same issue, but I think I know what’s causing the confusion. If you use MySQL Query Analyzer, you can do this just fine: SELECT myvalue INTO @myvar FROM mytable WHERE anothervalue = 1; However, if you put that same query in MySQL Workbench, it will throw a syntax error. I don’t … Read more
Launch MySQL Workbench. On the left pane of the welcome window, choose a database to connect to under “Open Connection to Start Querying”. The query window will open. On its left pane, there is a section titled “Object Browser”, which shows the list of databases. (Side note: The terms “schema” and “database” are synonymous in … Read more
Most of the code below is self explanatory. Still I have put the needful comments. I was able to connect to the MySql database with the code below. I had used SSH library from here and MySql connector for .NET. using(var client = new SshClient(“ssh server id”, “sshuser”, “sshpassword”)) // establishing ssh connection to server … Read more
Alternatively, if your database is not that huge, you can make a dump and make your search in the .sql generated file.
I had the following solution: change my.ini in a [mysqld] section like this: #default_authentication_plugin=caching_sha2_password (comment line!) default_authentication_plugin=mysql_native_password (new line) Connect to your MySQL under root in a command line client and execute: ALTER USER ‘root’@’localhost’ IDENTIFIED WITH mysql_native_password BY ‘xxx’; Where xxx is your current password.
I would say that first and foremost: be consistent. I reckon you are almost there with the conventions that you have outlined in your question. A couple of comments though: Points 1 and 2 are good I reckon. Point 3 – sadly this is not always possible. Think about how you would cope with a … Read more
Here’s how to change MySQL Workbench’s colors (INCLUDING THE BACKGROUND COLOR). Open the XML file called code_editor.xml located in the data folder of the MySQL Workbench’s installation directory (usually C:\Program Files\MySQL\MySQL Workbench 6.3 CE\data). Here you’ll find a lot of styling for different code elements, but there are some missing. MySQL Workbench uses scintilla as … Read more
The issue is likely due to socket authentication being enabled for the root user by default when no password is set, during the upgrade to ubuntu 16.04. The solution is to revert back to native password authentication. You can do this by logging in to MySQL using socket authentication by doing: sudo mysql -u root … Read more