How To

How to Get Started with Machine Learning

Machine learning is a rapidly growing field that has the potential to revolutionize industries and change the way we live our lives. If you’re interested in getting started with machine learning, but don’t know where to begin, this article will provide you with a step-by-step guide to help you on your journey. Step 1: Learn […]

How to Copy a Directory from One Server to Another in Ubuntu/Linux

You can use the below scp command to copy an entire directory or a specific file from one linux based server to another: scp -i {keyfile} -r {origin} {destination} Example:1 scp -i yourpem.pem -r username@ip_address_of_remote_server:/remote_directory_path destination_direction_path Example:2 scp -i yourpem.pem -r root@111.111.111.111:/home/abc /home/efg

How to convert a String List to Comma Seprated String

Stream Collectors.joining import java.util.Arrays; import java.util.List; import java.util.stream.Collectors; //———————— public class YourClass { public static void main(String[] args) { List list = Arrays.asList(“a”, “b”, “c”); String result = list.stream().collect(Collectors.joining(“,”)); System.out.println(result); } } Output: a,b,c String.join import java.util.Arrays; import java.util.List; public class MyClass { public static void main(String[] args) { List list = Arrays.asList(“a”,”b”,”c”); String result […]

MySQL How To Create a New User and Grant Permissions

Creating a New User SSH to your Ubuntu system and login to MYSQL instance using root user mysql -u root -p Once you have gained access to the MYSQL, add your user using CREATE USER command CREATE USER ‘username’@’host’ IDENTIFIED WITH authentication_plugin BY ‘password’; Run the following command to create a user that authenticates with […]

How to List all Forign Keys of a SQL Table

List Forign keys of a table SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = ‘<database>’ AND REFERENCED_TABLE_NAME = ‘<table>’; List Forign keys of a table column SELECT TABLE_NAME,COLUMN_NAME,CONSTRAINT_NAME, REFERENCED_TABLE_NAME,REFERENCED_COLUMN_NAME FROM INFORMATION_SCHEMA.KEY_COLUMN_USAGE WHERE REFERENCED_TABLE_SCHEMA = ‘<database>’ AND REFERENCED_TABLE_NAME = ‘<table>’ AND REFERENCED_COLUMN_NAME = ‘<column>’; Drop a Forign Key from a Table MySQL: ALTER TABLE Orders DROP […]

Scroll to top