Alankritha Ammu has Published 59 Answers

How can we use MySQL TRIM() to remove the whitespaces from all the rows and update table?

Alankritha Ammu

Alankritha Ammu

Updated on 06-Feb-2020 06:48:17

Suppose if a table has many values having whitespaces in the columns of a table then it is wastage of space. We can use TRIM() function to remove whitespaces from all the rows and update the table too in a single query. Following the example from ‘Employee’, having whitespaces in ... Read More

How LIKE operator works with comparison operators for matching specific kinds of patterns of a string?

Alankritha Ammu

Alankritha Ammu

Updated on 06-Feb-2020 06:00:33

We can also use comparison operators in WHERE clause along with LIKE operator to get specific output. It is demonstrated in the following example −ExampleSuppose we want to get the names end with letter ‘v’ from a table but we do not want a specific name say ‘Gaurav’ in the ... Read More

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

Alankritha Ammu

Alankritha Ammu

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

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

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

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

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

How to set background image of a webpage?

Alankritha Ammu

Alankritha Ammu

Updated on 09-Jan-2020 08:20:53

To set the background image of a webpage, use the CSS style. Under the CSS tag, add the property background-image. The property sets a graphic such as jpg, png, svg, gif, etc. HTML5 do not support the background attribute, so CSS is used to change set background image.ExampleYou ... Read More

What is the JavaScript version of sleep()?

Alankritha Ammu

Alankritha Ammu

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

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

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

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"

Advertisements