MySQL Stored Procedure Definer Root Issue on Localhost

Chandu yadav
Updated on 30-Jul-2019 22:30:25

2K+ Views

First of all, you need to check the host. The host can be ‘localhost’ or ‘%’. Check the existence of user accounts with host −mysql> select user, host from MySQL.user;This will produce the following output −+------------------+-----------+ | user             | host      | +------------------+-----------+ | Bob              | % | | User2            | % | | mysql.infoschema | % | ... Read More

Memory Mapped I/O in 8085 Microprocessor

Nancy Den
Updated on 30-Jul-2019 22:30:25

9K+ Views

It is possible to address an I/O port as if it were a memory location. For example, let us say, the chip select pin of an I/O port chip is activated when address = FFF0H, IO/M* = 0, and RD* = 0. This is shown in the following fig.In this case, the I/O port chip is selected when the 8085 is thinking that it is addressing memory location FFF0H for a read operation. Note that 8085 thinks that it is addressing a memory location because it has sent out IO/M* as a logic 0. But in reality, an input port ... Read More

Remove All Vowels from TextView String in Android

Vrundesha Joshi
Updated on 30-Jul-2019 22:30:25

383 Views

This example demonstrates How to remove all vowels from textview string in AndroidStep 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to create a new project.Step 2 − Add the following code to res/layout/activity_main.xml.     In the above code, we have taken name and when user click on button it will print without vowels of edittext value.Step 3 − Add the following code to src/MainActivity.javapackage com.example.andy.myapplication; import ... Read More

Example of Using Taglib Directive in JSP

karthikeya Boyini
Updated on 30-Jul-2019 22:30:25

125 Views

The JavaServer Pages API allow you to define custom JSP tags that look like HTML or XML tags and a tag library is a set of user-defined tags that implement custom behavior.The taglib directive declares that your JSP page uses a set of custom tags, identifies the location of the library, and provides means for identifying the custom tags in your JSP page.The taglib directive follows the syntax given below −Where, the uri attribute value resolves to a location the container understands and the prefix attribute informs a container what bits of markup are custom actions.You can write the XML ... Read More

Check Substring in JSP Ignoring Case

karthikeya Boyini
Updated on 30-Jul-2019 22:30:25

452 Views

The fn:containsIgnoreCase() function determines whether an input string contains a specified substring. While doing search it ignores the case.SyntaxThe fn:containsIgnoreCase() function has the following syntax −boolean containsIgnoreCase(java.lang.String, java.lang.String)ExampleFollowing is the example to explain the functionality of the fn:containsIgnoreCase() function −           Using JSTL Functions                              Found test string                      Found TEST string         You will receive the following result −Found test string Found TEST string

monthDay isAfter Method in Java

Krantik Chavan
Updated on 30-Jul-2019 22:30:25

146 Views

It can be checked if a particular MonthDay is after the other MonthDay in a timeline using the isAfter() method in the MonthDay class in Java. This method requires a single parameter i.e. the MonthDay object that is to be compared. It returns true if the MonthDay object is after the other MonthDay object and false otherwise.A program that demonstrates this is given as followsExample Live Demoimport java.time.*; public class Main {    public static void main(String[] args) {       MonthDay md1 = MonthDay.parse("--02-25");       MonthDay md2 = MonthDay.parse("--02-21");       System.out.println("The MonthDay md1 is: " ... Read More

Duration Minus Method in Java

karthikeya Boyini
Updated on 30-Jul-2019 22:30:25

294 Views

An immutable copy of a duration where the required duration is subtracted from it can be obtained using the minus() method in the Duration class in Java. This method requires two parameters i.e. the duration to be subtracted and the TemporalUnit of the duration. Also, it returns the duration with the required duration subtracted from it.A program that demonstrates this is given as follows −Example Live Demoimport java.time.Duration; import java.time.temporal.*; public class Demo {    public static void main(String[] args) {       Duration d = Duration.ofHours(10);       System.out.println("The duration is: " + d);       System.out.println("Duration ... Read More

Format Number with Thousand and Decimal Separators

Arjun Thakur
Updated on 30-Jul-2019 22:30:25

1K+ Views

You can use format() function for the separators. It will work in MySQL version greater than or equal to 5.5. We are using the version 8.0.12mysql> select version(); +-----------+ | version() | +-----------+ | 8.0.12 | +-----------+ 1 row in set (0.00 sec)The syntax is as followsSELECT FORMAT(yourColumnName, valueAfterDecimalPoint, 'de_DE') AS anyAliasNamefrom yourTableName;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table formatNumberDemo -> ( -> Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, -> Number DECIMAL(19, 1) ... Read More

Wrapping C/C++ for Python using SWIG

Jennifer Nicholas
Updated on 30-Jul-2019 22:30:25

2K+ Views

There are multiple ways to wrap your existing C or C++ functionality in Python. In this section, we are going to see how we can wrap C/C++ functionality with SWIG. Below are other options to wrap c/c++ functionality in python.Manual wrappingUsing pyrex to wrap C code.CtypesSIPBoost PythonSWIG (Simple Wrapper Interface Generator) is capable of wrapping C code with numerous other languages including Perl, Python, PHP, Ruby, Tcl, C#, Common Lisp (CLISP, Allegro, CL, UFFI, CFFI), Java, Modula-3 and OCAML. Swig also supports multiple interpreted and compiled Scheme implementations (like Guile, MzScheme, Chicken) are supported.But we will discuss its implementation with ... Read More

Functions Executed Before and After Main in C

Vrundesha Joshi
Updated on 30-Jul-2019 22:30:25

3K+ Views

Here we will see how to write a code where two functions are present, and one function will be executed before the main function, and another function will be executed after the main function. These features are used to do some startup task before executing the main, and some cleanup task after executing main.To do this task we have to put attribute for these two functions. When the attribute is constructor attribute, then it will be executed before main(), and when the attribute is destructor type, then it will be executed after main().Example Code#include void before_main() __attribute__((constructor)); void after_main() __attribute__((destructor)); ... Read More

Advertisements