Today we will see a very basic example of understanding Skills with CSS. Read More: What is Bootstrap Container and How to use in HTML How to create bootstrap buttons Sample Code to show basic Skill bar
We require the sum of column values to display or use in the programming skill. So today you see How to SUM Columns value in MYSQL. Learn More: How to Select Data Into MySQL Database Using PHP ? How to Create Event Calendar with jQuery, PHP, and MySQL Problem Statement: subject | mark1 | mark2 … Read more
What is Bootstrap Bootstrap is the most popular HTML, CSS and JavaScript framework for developing a responsive and mobile friendly website . Bootstrap helps web developers build website faster as they don’t need to worry about basic commands and functions. Bootstrap became popular very quickly, and not without reason. Web designers and web developer like bootstrap because it … Read more
The DELETE statement is used to delete records from a table. you can delete records from a table using the SQL DELETE statement. It is typically used in conjugation with the WHERE clause to delete only those records that matches specific criteria or condition. Syntax : DELETE FROM table_nameWHERE some_column = some_value ; Implementation of the Delete Query … Read more
Introduction : MySQL is the most popular Open Source Relational SQL database management system. MySQL is one of the best RDBMS being used for developing web-based software applications. It is commonly deployed as part of the LAMP stack (which stands for Linux, Apache, MySQL, and PHP) and, as of this writing, is the most popular open-source database in the world. Prerequisites : A Linux … Read more
What is XML : XML is stand for (Extensible Markup Language) is a mark up language. It is designed to store transmitting, and reconstructing arbitrary data. The XML standard is a flexible way to create information formats and electronically share structured data via the public internet, as well as via corporate networks.XML does not define … Read more
Define Binary logs : In MySQL, the changes that occur within the database are logged simultaneously. The binary log is a set of log files that contain information about data modifications made to a MySQL server instance. The log is enabled by starting the server with the –log- bin option. The MySQL Bin Log (Binary Logs) … Read more
Select : Select Data From a MySQL Database The SELECT statement is used to select data from one or more tables The SQL SELECT command is used to fetch data from the MySQL database. You can use this command at mysql> prompt as well as in any script like PHP. Syntax : Columns are the column names … Read more
MySQL String Functions : MySQL string functions manipulate the character string data effectively. The following table indicates each of the functions with a brief description: Name Description CONTACT Concatenate two or more strings into a single string INSTR Return the position of the first occurrence of a substring in a string ASCII Returns the ASCII … Read more
VARCHAR Datatype: Varchar is a datatype in SQL that holds characters of variable length. This data type stores character strings of up to 255 bytes in a variable-length field. If the length of the string is less than set or fixed-length then it will store as it is without padded with extra blank spaces. The … Read more