Skip to main content

The Most Important SQL Commands || SQL syntax || sql commands with syntax

By

This video I have discussed on the SQL comment. Some important SQL comment (syntax) you have to remember it.

. . . Most of the actions you need to perform on a database are done with SQL statements. SQL keywords are NOT case sensitive: select is the same as SELECT. Some database systems require a semicolon at the end of each SQL statement. Semicolon is the standard way to separate each SQL statement in database systems that allow more than one SQL statement to be executed in the same call to the server.



Location: India

Comments

Post a Comment

Top Most viewed

How to draw circle, rectangle and triangle by canvas in Android?

By
Hi... friends, welcome to Bit Byte. This video is How to draw circles, rectangles, and triangles by canvas on Android? The Android Canvas provides convenient methods for drawing simple shapes such as circles and rectangles, using drawCircle and drawRect respectively, but beyond these, the majority of shapes require some custom Path logic to draw. Three shapes that I was required to draw were circle, rectangle, and triangle, so I thought I’d share how I accomplished this. And hard copy code is below this link. GitHub - https://github.com/giriArun/AndroidCanvasT1.git
Post a Comment
Read more

Connect to MySQL with PHP in XAMPP or WAMP server || MySQL database connection with PHP

By
This video will discuss how to connect to MySQL with PHP. I'm using PhpMyAdmin and connect MySQL database with PHP using the WAMP server. And you can use this code any php server. . . . WampServer Version 3.1.9 64bit Created by Romain Bourdon (2005) Maintainer / Upgrade to 2.5 by Herve Leclerc Upgrade to 3 by Otomatic (wampserver@otomatic.net) Multi styles for homepage by Jojaba Installer by Inno Setup: http://www.jrsoftware.org/isinfo.php Forum Wampserver: http://forum.wampserver.com/index.php ______________________ Versions used ______________________ Apache 2.4.39 Port 80- PHP 7.2.18 MySQL 5.7.26 Port 3308 PHP 5.6.40 for CLI (Command-Line Interface) CODE:- <?php //DB connection // new mysqli(host, user, password, database name); $connect = new mysqli("localhost:3308", "bit", "bitbyte", "bit_yt"); //Check connection if($connect->connect_error){ echo "Failed to connect to MySQL: ". $connect->connect_error; exit(); } ...
Post a Comment
Read more

AJAX call in jQuery get and post method | ajax call in PHP using jQuery | ajax call with example

By
In this Ajax call video, I'm trying to show how to call Ajax in jQuery using the GET or POST method. And how simple you call Ajax in PHP using jQuery. In this video, I did that with an example. I'm using the GET and POST method, and I called Ajax and got back a return value. AJAX stands for Asynchronous JavaScript and XML. AJAX is a new technique for creating better, faster, and more interactive web applications with the help of XML, HTML, CSS, and Java Script.
Post a Comment
Read more