Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Economics & Finance
You can append data to a MySQL database field with the help of in-built CONCAT() function.The syntax is as follows −update yourTableName set yourColumnName = CONCAT(yourColumnName, ’AppendValue’);To understand the above concept, let us create a table. The query to create a table −mysql> create table AppendingDataDemo −> ( −> FirstNameAndLastName varchar(200) −> ); Query OK, 0 rows affected (0.59 sec)Insert some records in the table with the help of insert command. The query is as follows −mysql> insert into AppendingDataDemo values('John'); Query OK, 1 row affected (0.27 sec) mysql> insert ... Read More
To give a dynamic height to an UIlabel in swift we can use the frame property of UILabel. We can create a frame using the CGRect which allows us to give different variables like x position, y position, width, and height.Let’s create a label and add it as a subview to our view.let label = UILabel() label.frame = CGRect(x: 10, y: 40, width: 200, height: 50) label.backgroundColor = colorLiteral(red: 0.7450980544, green: 0.1568627506, blue: 0.07450980693, alpha: 1) label.textColor = colorLiteral(red: 0.05882352963, green: 0.180392161, blue: 0.2470588237, alpha: 1) label.text = "Custom label" self.view.addSubview(label)We can embed this in a function as well, and ... Read More
This is absolutely true that marketers are crossing all borders to not only sell their products but also to have an upper hand over their competitors. You look around and observe that their eyes are everywhere and they won’t even hesitate to have a sneak peek into your bedroom if they get a chance. Recently, I was scrolling down my social media account and came across this exceptional way of marketing and thought of sharing with you. Just have a look at these side-splitting advertising efforts.
Public relations officers also known as public relations or communications specialists, facilitate relations between organizations and the public. They may work for corporations, non-profit groups, or government agencies.Requirements To Become A Public Relations OfficerDegree: One does not usually need a very high-level degree. A foundation level degree is acceptable. MBA is a huge add-on, although.Start Low: One may start as a public assistant, and then become Public relations officer.Confidence: A qualification in such professions would be Confidence and self-motivational skills. These do come under the banner of soft skills, which are a necessity in this field.Excellent Communication Skills: If one ... Read More
You need to use CONVERT() function along with binary keyword. The syntax is as follows −SELECT CONVERT(binary CONVERT(yourColumnName using latin1) USING UTF8) as anyAliasName FROM yourTableName;To understand the above syntax, let us create a table. The query to create a table is as follows −mysql> create table UtfDemo -> ( -> Id int NOT NULL AUTO_INCREMENT, -> Name varchar(15), -> PRIMARY KEY(Id) -> ); Query OK, 0 rows affected (0.76 sec)Insert some records in the table using INSERT command. The query is as follows −mysql> insert into UtfDemo(Name) values('Obama’s'); Query OK, 1 row affected (0.28 ... Read More
The following is the syntax to work with FOR LOOP in MySQL stored procedure −delimiter // CREATE procedure yourProcedureName() wholeblock:BEGIN DECLARE anyVariableName1 INT ; Declare anyVariableName3 int; DECLARE anyVariableName2 VARCHAR(255); SET anyVariableName1 =1 ; SET anyVariableName3 =10; SET anyVariableName2 = ''; loop_label: FORLOOP IF anyVariableName1 > anyVariableName3 THEN LEAVE loop_label; END IF; SET anyVariableName2 = CONCAT(anyVariableName2 ,anyVariableName1 ,', '); SET anyVariableName1 = anyVariableName1 + ... Read More
In this program we will see how to subtract two 8-bit numbers using 8085 microprocessor.Problem StatementWrite 8085 Assembly language program to subtract two 8-bit numbers with or without borrow and store the result at locations 8050H and 8051H.DiscussionIn 8085, the SUB instruction is used 2’s complemented method for subtraction. When the first operand is larger, the result will be positive. It will not enable the carry flag after completing the subtraction. When the result is negative, then the result will be in 2’s complemented form and carry flag will be enabled.We are using two numbers at location 8000H and 8001H. ... Read More
In this program we will see how to swap two 16-bit numbers in direct addressing mode.Problem StatementWrite 8085 Assembly language program to swap two 16-bit number stored at location 8000H – 8001H and 8002H – 8003H using direct addressing mode.DiscussionHere we are swapping the values using XCHG instruction. This instruction swaps the contents of DE and HL pair contents. We are taking the first number into DE register pair, then the second number into HL pair, then by XCHG we are swapping them.InputAddressData......8000CD8001AB800234800312......Flow DiagramProgramAddressHEX CodesMnemonicsCommentsF0002A, 00, 80LHLD 8000HLoad the first number into HLF003EBXCHGExchange DE and HLF0042A, 02, 80LHLD 8002HLoad the ... Read More
Ambush, as the name implies, is a surprise marketing. The term Ambush marketing was coined by Jerry Welsh, a marketing strategist. Ambush marketing is a type of marketing where the marketer associates the product with an event or property and the marketer is not directly or officially related to that event. This is a type of Guerilla marketing.To be more precise, we often happen to watch some advertisements which refer to some events or personalities indirectly without mentioning them officially. Such advertisements have a lot of impact on unknowingly.Grab the OpportunityThis kind of advertising is done by utilizing the opportunities ... Read More
To create a scrollable TextView in iOS we can do it in two ways, one by creating it using the storyboard and other by creating another textView programmatically.A text view is scrollable by default if it has text more than the height of textView and the scrollable property is disabled.1.Using storyboardGo to storyboard and from the object library drag a textView to your view.Now in the text view if the text is more than it’s height than it will be scrollable by default, otherwise it will not be scrollable.Give height constraint along with remaining required constraint.Make sure that scrolling enabled ... Read More