Alankritha Ammu has Published 55 Articles

How can we fetch all the records from a particular MySQL table?

Alankritha Ammu

Alankritha Ammu

Updated on 29-Jan-2020 06:37:09

163 Views

We can fetch all the record from a MySQL table by using SELECT * from table_name; query. An example is as follows, fetched all the records from ‘Employee’ table −mysql> Select * from Employee; +------+--------+ | Id   | Name   | +------+--------+ | 100  | Ram    | | 200  | Gaurav | | 300  | Mohan  | +------+--------+ 3 rows in set (0.00 sec)

How can I modify an existing MySQL column’s data type?

Alankritha Ammu

Alankritha Ammu

Updated on 29-Jan-2020 06:12:24

77 Views

ALTER COMMAND is used to modify an existing MySQL column’s data type. Following is an example which demonstrates that how we can use this command to modify column’s data type −mysql> describe testing\G *************************** 1. row ***************************   Field: id1    Type: int(11)    Null: NO     Key: PRI ... Read More

How should I display MySQL database that is currently in use?

Alankritha Ammu

Alankritha Ammu

Updated on 28-Jan-2020 10:38:56

56 Views

We can display the name of MySQL database that is currently in use by Select Database() command.mysql> select database(); +------------+ | database() | +------------+ | tutorial   | +------------+ 1 row in set (0.00 sec)This command shows that we currently use tutorial database.

How to use a Boolean in JavaScript Constructors?

Alankritha Ammu

Alankritha Ammu

Updated on 13-Jan-2020 08:21:50

159 Views

To use Boolean in JavaScript constructors, use JavaScript boolean constructor() method. It returns a reference to the Boolean function that created the instance's prototype.ExampleYou can try to run the following code to learn how to use Booleans in ConstructorsLive Demo           JavaScript constructor() Method     ... Read More

What is the JavaScript version of sleep()?

Alankritha Ammu

Alankritha Ammu

Updated on 07-Jan-2020 09:35:37

296 Views

The JavaScript version of sleep() is “await”. The await feature pauses the current aync function.ExampleYou can try to run the following code to implement sleep in JavaScriptLive Demo                    function setSleep(ms) {             return new ... Read More

What is the use of return statement inside a function in JavaScript?

Alankritha Ammu

Alankritha Ammu

Updated on 07-Jan-2020 08:51:24

213 Views

The “return” statement in JavaScript mentions a value, which you like to return. Inside a function, the value is returned to the function caller.ExampleYou can try to run the following code to implement return statement inside a functionLive Demo                    function ... Read More

I am getting GUID Key columns truncated while using proxy ERP tables to query SAP tables

Alankritha Ammu

Alankritha Ammu

Updated on 06-Dec-2019 11:12:59

101 Views

I think there is a restriction in SAPand when you use default functional module it only shows 16characters.To overcome this you should install Z module in SAP system and you can activate it by entering the name of LINQ table.Custom function "Z_XTRACT_IS_TABLE"

Aggregating rows in SAP ABAP with the same name

Alankritha Ammu

Alankritha Ammu

Updated on 05-Dec-2019 10:38:25

388 Views

You can use the COLLECT keyword or some aggregate functions to achieve the result. You should define some datatype to match the scenario.TYPES: BEGIN OFt_my_type,    key_aTYPE foo,    key_bTYPE foo,    nokey_cTYPE foo,    nokey_dTYPE foo, END OFt_my_type, tt_my_type_list TYPE STANDARD TABLE OF t_my_type WITH DEFAULT KEY, tt_my_type_hash TYPE ... Read More

Error connecting SAP while sapjco3.jar file is in my library path

Alankritha Ammu

Alankritha Ammu

Updated on 05-Dec-2019 10:26:37

475 Views

You need to copy sapjco3.dll in a folder in your Java library path as he t library is not sapjco3.jar and it is a sapjco3.dll file.You can call in your application usingfollowing:System.getProperty("java.library.path")Following approaches can be used:First is by copying sapjco3.dll into one of the folder which are already in your ... Read More

How to convert a Java String to an Int?

Alankritha Ammu

Alankritha Ammu

Updated on 30-Jul-2019 22:30:21

188 Views

The parseXxx() method is used to get the primitive data type of a certain String. In this case to convert a String to integer you could use the parseInt() method.Example Live Demopublic class Test {    public static void main(String args[]) {       int x =Integer.parseInt("9");       double ... Read More

Advertisements