Rishi Rathor has Published 184 Answers

Delete all records from a table in MySQL?

Rishi Rathor
Rishi Rathor
Published on 10-Jan-2019 11:20:26
To delete all the records from a table in MySQL, use the TRUNCATE command. Let us fir see the syntax −TRUNCATE TABLE yourTableName.The above syntax will delete all the records from a table. Let us create a table to understand the above syntax −mysql> create table TruncateTableDemo −> (   ... Read More

MySQL extract year from date format?

Rishi Rathor
Rishi Rathor
Published on 10-Jan-2019 11:10:28
To extract year from date format, you can use in-built function YEAR() from MySQL. The query is as follows −mysql> SELECT YEAR(curdate()) as OnlyYearFromCurrentDate;The following is the output −+-------------------------+ | OnlyYearFromCurrentDate | +-------------------------+ | 2018 ... Read More

How to cast DATETIME as a DATE in MySQL?

Rishi Rathor
Rishi Rathor
Published on 10-Jan-2019 10:54:02
To cast DATETIME as a DATE in MySQL, use the CAST() function. The syntax is as follows −select cast(yourColumnName as Date) as anyVariableName from yourTableName;To understand the above syntax, let us first create a table −mysql> create table ConvertDatetimeToDate −> (    −> YourDatetime datetime −> ); Query OK, 0 ... Read More

How to get MySQL random integer range?

Rishi Rathor
Rishi Rathor
Published on 10-Jan-2019 10:31:52
To get the random integer range, use the rand() function. The query to create a table −mysql> create table RandomIntegerDemo −> (    −> Number int −> ); Query OK, 0 rows affected (0.61 sec)Inserting records into table. The query is as follows −mysql> insert into RandomIntegerDemo values(1), (2), (3), ... Read More

Change a single character in a Java StringBuffer object in Java

Rishi Rathor
Rishi Rathor
Published on 03-Jan-2019 16:08:24
In order to change a single character in a StringBuffer object in Java, we use the setCharAt() method. The setCharAt() method sets the character at the index specified as a parameter to another character whose value is passed parameter of the setCharAt() method. The method sets a new character sequence ... Read More

Change the length of the StringBuffer Object in Java

Rishi Rathor
Rishi Rathor
Published on 03-Jan-2019 15:52:31
The setLength(int newLength) method is used to change the length of the StringBuffer Object. It sets the length of the character sequence. The character sequence is updated to a new one whose length is determined by the value passed as the parameter in the method. The newLength should be greater ... Read More

What does the StringBuffer append() method do in Java?

Rishi Rathor
Rishi Rathor
Published on 03-Jan-2019 15:25:07
The StringBuffer append() method appends the String representation of the particular argument to the sequence. It is a method of the java.lang.StringBuffer class. This method returns a reference to the object.The basic syntax for append() method is as follows −public StringBuffer append(data_type variable_name)A program to illustrate the use of append() ... Read More

Declare static variables and methods in an abstract class in Java

Rishi Rathor
Rishi Rathor
Published on 03-Jan-2019 14:45:19
If a method is declared as static, it is a member of a class rather than belonging to the object of the class. It can be called without creating an object of the class. A static method also has the power to access static data members of the class.A static ... Read More

Low-Density Parity Check (LDPC)

Rishi Rathor
Rishi Rathor
Published on 03-Jan-2019 10:49:14
Low - density parity check (LDPC) code is a linear error-correcting block code, suitable for error correction in large block sizes transmitted via very noisy channels.LDPC was developed by Robert G. Gallager, in his doctoral dissertation at the Massachusetts Institute of Technology in 1960. So, these codes are also known ... Read More

Error Correcting Codes - Reed-Solomon codes

Rishi Rathor
Rishi Rathor
Published on 31-Dec-2018 16:06:37
Errors and Error Correcting CodesErrors in data occur when bits get corrupted in the data. When bits are transmitted over the computer network, they are subject to get corrupted due to interference and network problems, leading to errors.Error-correcting codes (ECC) are a sequence of numbers generated by specific algorithms for ... Read More
Previous 1 ... 4 5 6 7 8 9 10 ... 19 Next
Advertisements