Arjun Thakur has Published 1025 Articles

How to use NULL in MySQL SELECT statement?

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:51:12

1K+ Views

In MySQL, the length of NULL is 0. Here, we will see how NULL can be used with SELECT statement. Let us create a table with the help of CREATE command −Creating a table −mysql> CREATE table NullWIthSelect -> ( -> Name varchar(100) -> ); Query OK, 0 rows affected ... Read More

How to enable MySQL Query Log?

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:48:37

1K+ Views

To enable query log, use the command SET global. You cannot use set general_log in MySQL version 8.0.12 version. If you are using version 8.0.12, then you will get the below given error. Here, we are trying to set general_log to see what error will come −mysql> SET general_log = ... Read More

Drawing lines with continuously varying line width on HTML canvas

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:45:56

568 Views

To draw lines with continuously varying line width, you can try to run the following code −Examplevar context = document.getElementById('canvas1').getContext('2d'); var pts = [null, null, null, null]; for(var i=-1; i

How to make SQL case sensitive string comparison in MySQL?

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:44:14

819 Views

Firstly, we will create a table with the help of CREATE command.Creating a table −mysql> CREATE table InCaseSensDemo -> ( -> Name varchar(100) -> ); Query OK, 0 rows affected (0.50 sec)Inserting records into the table with the help of INSERT command −mysql> INSERT into InCaseSensDemo values('JOhN'); Query OK, 1 ... Read More

HTML5 Canvas Text Stroke for Large Font Size

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:42:11

265 Views

To draw large font properly in HTML5 Canvas, you can try to run the following code −var myCanvas = document.getElementById("myCanvas"); var context = myCanvas.getContext("2d"); context.font = '180pt Georgia'; context.strokeStyle = "#FF0000"; context.fillStyle = "#FFFFFF "; context.lineWidth = 34; context.fillText("Demo!",0,200); context.strokeText("Demo!",0,200);

Perform basic HTML5 Canvas animation

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:38:10

306 Views

HTML5 canvas provides the necessary methods to draw an image and erase it completely. We can take JavaScript help to simulate good animation over an HTML5 canvas.ExampleYou can try to run the following code to perform basic HTML5 Canvas Animation −               ... Read More

CSS only Animate - Draw Circle with border-radius and transparent background

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:36:26

736 Views

To draw a circle with transparent background and border-radius, use the following CSS −body {    background: repeating-linear-gradient(45deg, white 0px, green 100px);    height: 400px;    background-size: 400px 400px;    background-repeat: no-repeat; } html {    height: 100%; } #box {    position: absolute;    width: 400px;    height: 400px; ... Read More

HTML5+CSS3 Framework like BluePrint/960gs?

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:23:57

115 Views

You can use the BluePrint/960gs framework or any of the following −52frameworkSusy        52framework (Refer)The framework that provides −CSS3 gradients, multiple shadows, and other amazing properties.CSS3 selectors with support for IE.New and improved HTML5 video support with vimeo like skinA completely new Form Framework with HTML5 Validation (via ... Read More

Perform Animation on CSS clip property

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:22:35

155 Views

To implement animation on clip property with CSS, you can try to run the following codeExampleLive Demo                    div {             width: 200px;             height: 300px;         ... Read More

HTML5 video not working with jquery bxSlider plugin on iPad

Arjun Thakur

Arjun Thakur

Updated on 25-Jun-2020 07:10:16

207 Views

To make it work, download the bxslider plugin from the official website. Get an images folder from the downloaded bxslider zip and you need to paste it into js folder of your project.All the folders will now look like − The above should solve your problem.

Advertisements