Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles by Ankith Reddy
Page 57 of 73
How to convert date YYYYMMDD to YY-MM-DD in MySQL query?
To convert date YYYYMMDD to YY-MM-DD in MySQL, use the below syntax −select date_format(str_to_date(yourColumnName, '%Y%m%d'), '%Y-%m-%d') from yourTableName;Let us first create a table −mysql> create table DemoTable ( ClientId int NOT NULL AUTO_INCREMENT PRIMARY KEY, ClientProjectDeadline varchar(200) ); Query OK, 0 rows affected (0.57 sec)Insert some records in the table using insert command. We have inserted dates in the YYYYMMDD format −mysql> insert into DemoTable(ClientProjectDeadline) values('20121221'); Query OK, 1 row affected (0.19 sec) mysql> insert into DemoTable(ClientProjectDeadline) values('20190416'); Query OK, 1 row affected (0.53 sec) mysql> insert into DemoTable(ClientProjectDeadline) values('20160624'); Query OK, 1 row affected (0.20 sec) mysql> ...
Read MoreResolve the error Column count doesn’t match value count in MySQL?
This type of error occurs when number of columns does not match whenever you are inserting records in the destination table. For a demo example, let us create a tablemysql> create table errorDemo -> ( -> User_Id int NOT NULL AUTO_INCREMENT, -> User_Name varchar(20), -> PRIMARY KEY(User_Id) -> ); Query OK, 0 rows affected (0.47 sec)The error is as followsmysql> insert into errorDemo values('John'); ERROR 1136 (21S01): Column count doesn't match value count at row 1To avoid this type of error, you need to use the following syntaxinsert into yourTableName(yourColumnName1, yourColumnName2, ...N)values(yourValue1, yourValue2, ....N);Insert some ...
Read MoreWhat does /* in MySQL means?
This is a type of comment. The /* is the beginning of a comment and */ is the end of comment.Let us implement and display how to create a commentmysql> /* This is the first MySQL Program */MySQL will ignore the above comment.Let us see an example. Here, we have written a comment with /* and */mysql> /*This table has information about person */ mysql> create table DemoTable ( PersonId int NOT NULL AUTO_INCREMENT PRIMARY KEY, PersonName varchar(20), PersonAge int ); Query OK, 0 rows affected (0.58 sec)
Read More8085 Program to perform selection sort in descending order
Now let us see a program of Intel 8085 Microprocessor. In this program we will see how to sort a sequence of numbers in reverse order using selection sort.Problem Statement:Write 8085 Assembly language program to sort a given sequence using selection sort in descending order. The numbers are stored at 8001H onwards. 8000H is holding the block size.Discussion:In the selection sorting technique, we will choose the minimum or the maximum term from a set of numbers. In this case we are considering the sorting in descending order, so we are choosing the maximum number. By taking the maximum number, we ...
Read MoreMySQL SELECT to add a new column to a query and give it a value?
To add column to MySQL query and give it a value, use the below syntax −select yourColumnName1, yourColumnName2, .....N ,yourValue AS anyAliasName from yourTableName;Let us first create a table −mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY, FirstName varchar(20) ); Query OK, 0 rows affected (0.84 sec)Insert some records in the table using insert command −mysql> insert into DemoTable(FirstName) values('John'); Query OK, 1 row affected (0.13 sec) mysql> insert into DemoTable(FirstName) values('Larry'); Query OK, 1 row affected (0.17 sec) mysql> insert into DemoTable(FirstName) values('Chris'); Query OK, 1 row affected (0.14 sec) mysql> insert into ...
Read MoreGet MySQL maximum value from 3 different columns?
To get the maximum value from three different columns, use the GREATEST() function.The syntax is as followsSELECT GREATEST(yourColumnName1, yourColumnName2, yourColumnName3) AS anyAliasName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as followsmysql> create table MaxOfThreeColumnsDemo -> ( -> First int, -> Second int, -> Third int -> ); Query OK, 0 rows affected (0.73 sec)Insert some records in the table using insert command.The query is as followsmysql> insert into MaxOfThreeColumnsDemo values(30, 90, 60); Query OK, 1 row affected (0.16 sec) mysql> insert into MaxOfThreeColumnsDemo values(100, ...
Read MoreGeneration of .OBJ file using a cross-assembler
Generation of .OBJ file by using a cross-assembler:The file assembly language program file, e.g. MULT.ASM which is created by using an editor is simply a text file. We cannot execute this file directly. At first we have to assemble the file, and then we have to link it. The step of assembly the translation of the program of assembly language to machine code requires the generation of a .OBJ file.We have used some examples in the text of ‘2500 A.D i.e. the 8085 cross-assembler of version 4.01.In the prompt mode the translation is:We type ‘X8085’ just for performing the translation ...
Read MoreStatus check data transfer in 8085
Status check data transfer process is a much more complex process than simple data transfer. We use this method is used when there is lack of accurate knowledge of the Input Output device consisting of the timing characteristics. Status information is received by the processor regarding the readiness of the Input Output device for performing the data transfer. Generally, the processor is involved in the checking of the loop for the device to get ready. The device releases from the loop when the device is ready for use for the execution of the IN or OUT instruction which depends on ...
Read MoreData file mode in 8085 Microprocessor
DATA FILE MODE in8085 MicroprocessorWe can refer to ‘X8085 cross-assembler’ manual for details.The format of Intel Hex: We have shown the MULT.HEX file to give a brief description at a glance.:01 C100 00 04 3A:01 C200 00 05 38:02 C300 00 00 00 3B:10 C000 00 21 00 C1 5E 16 00 21 00 C2 7E 21 00 00FE 00 CA 90:10 C010 00 17 C0 19 3D C2 12 C0 22 F7 FF 22 00C3 CD BC 06 D3:01 C020 00 76 A9:00 0000 01 FFThere are several lines which the file consists of which are termed as records. ...
Read MoreAction taken by 8085 when INTR pin is activated
We have assumed that the interrupt system gets enabled by using the EI instruction, and the signals which have higher priority are not in active state.In the penultimate clock cycle of the last machine cycle of every instruction, the 8085 senses all the internal interrupt signals.If the INTR internal signal which is at logic 1, the 8085 enters to a machine cycle which is called interrupt acknowledge (INA) machine cycle.The interrupts from the Input Output port gets acknowledged by the 8085 by the activation of INTA* pin in the T2 state of the machine cycle INA where INTA* is a ...
Read More