Chandu yadav has Published 1091 Articles

How can I make a table in MySQL called “order”?

Chandu yadav

Chandu yadav

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

5K+ Views

As you know, order is a keyword in MySQL, you cannot give table name order directly. You need to use backtick around the table name order. Backtick allow a user to consider the keyword as table or column name.The syntax is as followsCREATE TABLE `order` (    yourColumnName1 dataType,   ... Read More

LongStream.Builder accept() method in Java

Chandu yadav

Chandu yadav

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

112 Views

The accept() method of the LongStream.Builder class adds an element to the stream being built.The syntax is as followsvoid accept(long i)Here, i is the input.To use the LongStream.Builder class in Java, import the following packageimport java.util.stream.LongStream;Create a LongStreamLongStream.Builder builder = LongStream.builder();Add some elementsbuilder.accept(200L); builder.accept(600L); builder.accept(400L);The following is an example to ... Read More

Memory Write (MW) machine cycle in 8085 Microprocessor

Chandu yadav

Chandu yadav

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

3K+ Views

In the last three clock cycles the instructions ‘MVI M, 25H’ are the example for Memory Write machine cycle. We have shown the Waveforms for MW machine cycle are shown in fig below.The address which is sent out from the register pair in a Memory Write machine cycle is completely dependent ... Read More

How to get the second last record from a table in MySQL?

Chandu yadav

Chandu yadav

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

5K+ Views

To get the record before the last one i.e. the second last record in MySQL, you need to use subquery.The syntax is as followsSELECT *FROM (SELECT *FROM yourTableName ORDER BY yourIdColumnName DESC LIMIT 2) anyAliasName ORDER BY yourIdColumnName LIMIT 1;Let us first create a table. The query to create a ... Read More

DoubleStream mapToInt() method in Java

Chandu yadav

Chandu yadav

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

153 Views

The mapToInt() function of the DoubleStream class returns an IntStream consisting of the results of applying the given function to the elements of this stream.The syntax is as followsIntStream mapToInt(DoubleToIntFunction mapper)Here, mapper is a stateless function to apply to each element. The DoubleToIntFunction is a function that accepts a double-valued ... Read More

Memory speed requirement in 8085 Microprocessor

Chandu yadav

Chandu yadav

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

323 Views

At the end of the state T2 in a machine cycle, 8085 processor senses the Ready input pin. If it is logic 0, 8085 processors enter the Twait state, else it enters to the T3 state. The Ready input is permanently fixed to logic 1. The memory chips and the Input ... Read More

How android YouTube app Play Video from Intent

Chandu yadav

Chandu yadav

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

2K+ Views

In some situations, we should open you tube application from our application to show some specific video. This example demonstrate about How android YouTube app Play Video from Intent.Step 1 − Create a new project in Android Studio, go to File ⇒ New Project and fill all required details to ... Read More

How to add elements in Java CopyOnWriteArrayList?

Chandu yadav

Chandu yadav

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

171 Views

To add elements in CopyOnWriteArrayList class in Java, use the add() method. Here, the element is appended to the end of the list.The syntax is as followsboolean add(E e)Here, the parameter e is the element to be appended to this list.To work with CopyOnWriteArrayList class, you need to import the ... Read More

DoubleStream flatMap() method in Java

Chandu yadav

Chandu yadav

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

141 Views

The flatMap() method of the DoubleStream class returns a stream with the results of replacing each element of this stream with the contents of a mapped stream formed by applying the provided mapping function to each element.The syntax is as followsDoubleStream flatMap(DoubleFunction

What MySQL databases do I have permissions on?

Chandu yadav

Chandu yadav

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

110 Views

To check this, you can use SHOW command. The syntax is as follows −show grants\GLet us implement the above syntax to display the permissions you have −mysql> SHOW GRANTS\GThis will produce the following output −*************************** 1. row *************************** Grants for root@%: GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, SHUTDOWN, ... Read More

Advertisements