SQL

Most Viewed first Recent First
3562 0
TRIM(), LTRIM(), RTRIM() Functions in SQL Server
In this article, I have discussed about SQL Server TRIM(), LTRIM(), RTRIM() Functions in SQL Server with example
Type
Article
1548 0
Best Open Source Database Software (DBMS)
In this article, I have mentioned Best free and Open Source Database Software (DBMS), which you can use.
Type
Article
3632 0
Get Date From Datetime in SQL Server
In this article, I have mentioned how to get date from datetime in sql server using various examples.
Type
Article
3134 0
Microsoft SQL Server Versions List
In this article, I have mentioned about all the versions of Microsoft SQL Server, so you can decide which is good one for you.
Type
Article
3568 0
Download and Install SQL Server Management Studio (Step by Step)
In this article, I have mentioned how you can download and install SQL Server management studio (SSMS) in your local pc and how to use SSMS.
Type
Article

8984 1
Download and Install SQL Server (Step by Step procedure)
In this article, I have provided the guide to download and install sql server database on your machine with step by step procedure.
Type
Article
6093 0
Drop all tables of SQL Server Database
In this article, I have provided various possible ways to delete all tables of SQL Server database, without deleting the main database.
Type
Article
4084 0
Convert Month Number to Month Name in SQL
In this article, I have mentioned, how we can convert month number to month name in sql server, mysql and oracle database.
Type
Article
10134 1
Tools to Compare Two SQL Server Database
In this article, I have provided list of various tools which can compare two SQL Server database schema and highlights the difference between the two.
Type
Article
4849 2
Error Code: 1175 - You are using safe update mode

When I am trying to execute this query in MySQL Workbench 'DELETE FROM Job;', I am getting below error 

Error Code: 1175. You are using safe update mode and you tried to update a table without a WHERE that uses a KEY column. To disable safe mode, toggle the option in Preferences -> SQL Editor and reconnect.

So, how can I resolve this error, why I cannot Execute the simple delete query?

...
Type
Question

Page 5 of 11