mysql commands to learn basic sql commands on terminal

 

On your mac terminal to open your mysql use the below command

firstname.lastname@MRMAcNAME ~ % mysql -u root -A

Welcome to the MariaDB monitor.  Commands end with ; or \g.

Your MariaDB connection id is 1277

Server version: 10.4.33-MariaDB Homebrew

Copyright (c) 2000, 2018, Oracle, MariaDB Corporation Ab and others.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

MariaDB [(none)]> 

=======================================================

To list databases

MariaDB [(none)]> show databases;

+--------------------+

| Database           |

+--------------------+

| database1   |

| master       |

| information_schema |          |

| mysql              |            |

+--------------------+

7 rows in set (0.004 sec)

MariaDB [(none)]> 

============================================

To create a new database

MariaDB [(none)]> create database testdemo;

Query OK, 1 row affected (0.003 sec)

============================================

To use the database 

MariaDB [(none)]> use testdemo;

Database changed

============================================

To list the tables

MariaDB [testdemo]> show tables;

Empty set (0.001 sec)

============================================

To delete a database

MariaDB [(none)]> drop database testdemo;

Query OK, 0 rows affected (0.022 sec)

============================================

To exit from the Mysql server

MariaDB [testdemo]> exit;

Bye

firstname.lastname@MRMAcNAME ~ % 

Can't connect to local MySQL server through socket '/tmp/mysql.sock'

 If you see this error message while trying to connect to a local MySQL Server:

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock'

It means either the MySQL server is not installed/running, or the file mysql.sock doesn’t exist in /var/lib/mysql/.

There are a couple of solutions for this error. 

On your command prompt or terminal try to stop the server first by running below command

Mysql.server stop

And after successfully stopped

Run below command to start the mysql server

Mysql.server start

what is the difference between public static final and public final static

what is the difference between public static final and public final static

No difference at all

They are the same. The order of modifiers is not significant. And note that the same rule applies in all contexts where modifiers are used in Java.

However, most Java style guides recommend/mandate the same specific order for the modifiers.
In this case, it is public static final.


private static final String API_RTN_ERROR= "1";
private final static String API_RTN_ERROR= "1";
static private final String API_RTN_ERROR= "1";
static final private String API_RTN_ERROR= "1";
final static private String API_RTN_ERROR= "1";
final private static String API_RTN_ERROR= "1";

even all above are same the position of first three is intercangeable.

Does it differ for private or public?
No, you can use any order in private and public. Just difference is private variables will not be accessible outside of class directly.


https://stackoverflow.com/questions/11219556/difference-between-final-static-and-static-final

what is the meaning of public static final string SOME_VARIABLE = "variable text"

what is the meaning of public static final string SOME_VARIABLE = "variable text"

final indicates that the value of the variable won't change - in other words, a variable who's value can't be modified after it is declared.

Use public final static String when you want to create a String that:

belongs to the class (static: no instance necessary to use it), and that
won't change (final), for instance when you want to define a String constant that will be available to all instances of the class, and to other objects using the class.


Similarly:

public static final int ERROR_CODE = 54654;
It isn't required to use final, but it keeps a constant from being changed inadvertently during program execution, and serves as an indicator that the variable is a constant.

Even if the constant will only be used - read - in the current class and/or in only one place, it's good practice to declare all constants as final: it's clearer, and during the lifetime of the code the constant may end up being used in more than one place.

Also, you may access the value of a public static string w/o having an instance of a class.

static means that the object will only be created once, and does not have an instance object containing it. The way you have written is best used when you have something that is common for all objects of the class and will never change. It even could be used without creating an object at all.

Usually it's best to use final when you expect it to be final so that the compiler will enforce that rule and you know for sure. static ensures that you don't waste memory creating many of the same thing if it will be the same value for all objects.

public makes it accessible across other classes.


what-is-difference-between-public static final and public final static

How to add ISTQB certification to linked in profile

Here follow these steps to add any certification as below steps so that

First click on your Profile in Linked in

Just below to your details there is a option "Add a section to your profile" In that block click on "View details"

 Click on View more

Select  certifications
Now fill details

Click on Save button so that it will appear as below on your linked profile.

How to connect to shared drive on mac

Step 1: First please check whether you have connected to your company network or not ? if not connect to your LAN or internet network and in my company scenario I have to connect to blue cable to my mac laptop.

Step2:  Click on Finder icon  or by minimising all browsers for windows come into Desktop

Step 3: From keyboard click Cmd  + K  or In the Finder , Choose Go > “Connect to Server”

Step 4: It will open “Connect to Sever” window

Step 5: On the “Server address” give your shared drive address

 machinename/foldername1/foldername2

and click on “Connect” button  It will ask for User id and password  please give your system user id and password
it will generate as below
smb://machinename/foldername1/foldername2

Just in case if you need to keep as a further reference click on + icon


Just in case if you want to remove even you can remove by clicking on Remove button.

More details you can get here

https://support.apple.com/kb/ph10644?locale=en_US

package org.junit does not exist

package org.junit does not exist

Your Test class might be located in src/main/java.
Also the value of the "scope" element in the POM for JUnit was "test", although that is how it is supposed to be.
The problem was that You had been sloppy when creating the test class in Eclipse that is
resulting in it being created in src/main/java insted of src/test/java.

So put your .java class in src/test/java


And in pom.xml just add  <scope>test</scope> for junit dependency if it is already existed.


<dependency>
  <groupId>junit</groupId>
  <artifactId>junit</artifactId>
  <version>4.11</version>
  <scope>test</scope>
</dependency>