Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
The Input Week autofocus property sets/returns whether Input Week is focused upon initial page load.SyntaxFollowing is the syntax −Returning boolean value - true/falseinputWeekObject.autofocusSetting autofocus to booleanValueinputWeekObject.autofocus = booleanValueBoolean ValuesHere, “booleanValue” can be the following −booleanValueDetailsTrueIt defines that input will be autofocused on page load.FalseIt is the default value and input is not autofocused.ExampleLet us see an example for Input Week autofocus property − Live Demo Input Week autofocus form { width:70%; margin: 0 auto; text-align: center; } * { padding: 2px; ... Read More
You can use TINYINT data type in MySQL to store negative number. Following is the syntax −CREATE TABLE yourTableName ( yourColumnName TINYINT . . . . N );Let us first create a table with a column set as type TINYINT −mysql> create table DemoTable ( Number tinyint ); Query OK, 0 rows affected (0.69 sec)Insert some records in the table using insert command −mysql> insert ... Read More
This example demonstrate about How can I define underlined text in an Android layout xml file.Step 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.java Step 3 − Add the following code to src/MainActivity.javapackage app.tutorialspoint.com.sample ; import android.os.Bundle ; import android.support.v7.app.AppCompatActivity ; import android.text.SpannableString ; import android.text.style.UnderlineSpan ; import android.widget.TextView ; public class MainActivity extends AppCompatActivity { @Override protected void onCreate (Bundle savedInstanceState) { super .onCreate(savedInstanceState) ; ... Read More
Let us first create a table −mysql> create table DemoTable -> ( -> Number int -> ); Query OK, 0 rows affected (0.83 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(20); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(10); Query OK, 1 row affected (0.23 sec) mysql> insert into DemoTable values(30); Query OK, 1 row affected (0.14 sec) mysql> insert into DemoTable values(10); Query OK, ... Read More
The Input Week defaultValue property sets/returns the default value corresponding to Week Input. The value attribute changes as the user resets the week input but default value does not change.SyntaxFollowing is the syntax −Returning string valueinputWeekObject.defaultValueSetting defaultValue to stringinputWeekObject.defaultValue = ‘string’ExampleLet us see an example for Input Week defaultValue property − Live Demo Input Week defaultValue form { width:70%; margin: 0 auto; text-align: center; } * { padding: 2px; margin:5px; } input[type="button"] { border-radius: 10px; ... Read More
Here we will see how to print long int value using the putchar() function in C. We can easily print the value of some variables using printf() in C, but here the restriction is, we cannot use any other function except putchar().As we know that the putchar() is used to print only characters. We can use this function to print each digit of the number. When one numeric value is passed, we have to add character ‘0’ with it to get the ASCII form. Let us see the code to get the better idea.Example#include void print_long(long value) { ... Read More
The variable table_type doesn’t work since this variable is deprecated as of MySQL 5.5.3. Use default_storage_engine instead. Following is the syntax −SET default_storage_engine = yourTableEngine;The table engine name may be InnoDB or MyISAM. Here, we will set engine type to MyISAM −mysql> SET default_storage_engine=MyISAM; Query OK, 0 rows affected (0.00 sec)Let us create a table.mysql> create table DemoTable ( Id int NOT NULL AUTO_INCREMENT PRIMARY KEY ); Query OK, 0 rows affected (0.40 sec)Now check the engine type of above table −mysql> SHOW TABLE STATUS WHERE Name = 'DemoTable';This will produce the following output −+--------------+--------+---------+------------+------+----------------+-------------+------------------+--------------+-----------+----------------+---------------------+---------------------+------------+-----------------+----------+----------------+---------+ | Name | Engine | ... Read More
How often you develop an application and you write same validation for every input fields. One such example is User registration, Login screen or Registration screen or any other screen. It becomes tedious to write same line of code for every input field moreover you may tend to mistake the same.As per the design it is never recommend to write validation for each field, rather you should be writing generic validation functions.So in this blog we will be writing generic validation library of input Text Fields.Advantages of writing genetic validation library.Reuse able code for all functions.Chances of human error getting ... Read More
You can use find() for this. Let us first create a collection with documents −> db.findDocumentsDemo.insertOne( { _id: 101, "ProductDetails": [ { "ProductValue":100 }, { "ProductValue":120 } ] } ); { "acknowledged" : true, "insertedId" : 101 } > db.findDocumentsDemo.insertOne( { _id: 102, "ProductDetails": [ { "ProductValue":120}, { "ProductValue":120 }, { "ProductValue":120 } ] } ); { "acknowledged" ... Read More
Instead of IN(), use FIND_IN_SET to search between comma separated values within one field. Let us first create a table −mysql> create table DemoTable -> ( -> ListOfValues text -> ); Query OK, 0 rows affected (0.56 sec)Insert some records in the table using insert command −mysql> insert into DemoTable values('10|20|30|40|50|60|100'); Query OK, 1 row affected (0.18 sec)Display all records from the table using select statement −mysql> select *from DemoTable;This will produce the following output −+-----------------------+ | ListOfValues | +-----------------------+ | 10|20|30|40|50|60|100 ... Read More