[Resolved] MySQL error code: 1175 during UPDATE in MySQL Workbench

If WHERE clause does not have primary key in UPDATE query then this error comes. If you want to run the update query without having primary key in WHERE clause of UPDATE query then below command needs to be run to disable the safe mode.

SET SQL_SAFE_UPDATES = 0;

It is good to run SET SQL_SAFE_UPDATES = 1; after running your UPDATE query and again enable the safe mode.

Example:

SET SQL_SAFE_UPDATES=0;

UPDATE table_name SET col_name=1;

SET SQL_SAFE_UPDATES=1;

Comments

LinkList implementation with Insert, InsertAt, Delete Methods in Java

Linklist Representation Node.java public class Node { int data ; Node next ; Node( int data , Node next ){ this . data = data ; this . next = next ; } } LinkList.java public class LinkList { Node head ; public void insert( int data ) { Node node = new Node( data , null ); if ( head == null ) { head = node ; } else { Node currentNode = head ; while ( currentNode . next != null ) { currentNode = currentNode . next ; } currentNode . next = node ; } } public void inserAtStart( int data ) { Node node = new Node( data , null ); node . next = head ; head = node ; } public void insertAt( int index , int data ) { Node node = new Node( data , null ); // if index is 0 or head is null then insert at start if ( index == 0 || head == null ) { inserAtStart( data ); } els

Python Language Basics - 2

Slice string in python: details= "Akshay Kumar Gupta--akshaygupta.me" # details[:6] and details[0:6] will give same result print(details[: 6 ]) # OUTPUT: Akshay # details[20:] and details[20:34] will give same result print(details[ 20 :]) # OUTPUT: akshaygupta.me # -1 denotes the reverse order print(details[ 11 ::- 1 ]) #OUTPUT: ramuK yahskA # Here -9 denotes the count from the end of the string print(details[:- 9 :- 1 ]) #OUTPUT: em.atpug #Both syntax gives the same result for reversing the string print(details[- 1 ::- 1 ]) #OUTPUT: em.atpugyahska--atpuG ramuK yahskA print(details[::- 1 ]) #OUTPUT: em.atpugyahska--atpuG ramuK yahskA Format print in python: print( "hi, My name is {} and I am a {}. I like {}." .format( "Akshay" , "Software Engineer" , "python" )) In the above print statement, "{}" refers to the placement of the values given in "format()" function. First value in the order "format()"

Print Given Number Pattern in Java

public class NumberPattern { public static void main(String a []) { for ( int i = 1; i <=4; i ++) { for ( int j =0; j <4; j ++) { int sum = i + j ; // if sum is greater than 4 then subtract 4 from the sum otherwise print the sum System. out .print( sum > 4 ? sum - 4+ " " : sum + " " ); } System. out .println(); } } }

Short Technical Notes

Search This Blog