Giri Raju has Published 116 Answers

How to empty a C# list?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 12:29:44

To empty a C# list, use the Clear() method.Firstly, set a list and add elements −List<string> myList = new List<string>() {    "one",    "two",    "three",    "four",    "five",    "six" };Now, let us empty the list −myList.Clear();Example Live Demousing System; using System.Collections.Generic; public class Program {    public ... Read More

How can I check the tables of databases other than current database?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 12:14:06

With the help of following MySQL command, we can check the tables of a database other than the database we are currently using −Show Tables from Database_name;For example, the following query would display the list of tables from a database named ‘gaurav’ when currently we are using a database named ... Read More

What happens if I use both G and semicolon (;) termination symbol with a single MySQL statement?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 11:21:31

As we know that \G option sends the command to MySQL server for execution and with the help of Semicolon (;) MySQL determines the end of the statement. It is also known that both of them have a different format of the result set.Now, if we will use both of ... Read More

How the MySQL command that you are in the process of entering can be canceled?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 10:59:45

Suppose if we do not want to execute a command that we are entering, then we can use a clear \c option which clears the current input. For example, the use of \c option can be done as follows −mysql> Select *     -> from\cIn the example above, when ... Read More

Role of CSS :nth-last-child(n) Selector

Giri Raju

Giri Raju

Updated on 22-Jun-2020 07:29:12

Use the CSS :nth-last-child(n) selector to style every <p> element that is the child of its parent, counting from the last child.You can try to run the following code to implement the :nth-last-child(n) selector −ExampleLive Demo<!DOCTYPE html> <html>    <head>       <style>          p:nth-last-child(4) { ... Read More

How MySQL REPEAT loop statement can be used in stored procedure?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 06:07:11

As we know that MySQL provides us loop statements that allow us to execute a block of SQL code repeatedly based on a condition. A REPEAT loop statement is one of such kind of loop statement. Its syntax is as follows −REPEAT    statements; UNTIL expression END REPEATFirst of all, MySQL ... Read More

Role of margin property with value inherit using CSS

Giri Raju

Giri Raju

Updated on 22-Jun-2020 05:24:06

The margin property with value inherit is used to inherit an element from the parent element. You can try to run the following code to implement margin: inherit;ExampleLive Demo<!DOCTYPE html> <html>    <head>       <style>          div {             border: ... Read More

How can we see only the list of stored procedures in a particular MySQL database?

Giri Raju

Giri Raju

Updated on 22-Jun-2020 05:21:03

We can see only the list of stored procedures in a particular MySQL database by the following query −mysql> SELECT ROUTINE_TYPE, ROUTINE_NAME FROM INFORMATION_SCHEMA.ROUTINES WHERE ROUTINE_SCHEMA = 'query'AND ROUTINE_TYPE = 'PROCEDURE'// +--------------+------------------------+ | ROUTINE_TYPE | ROUTINE_NAME           | +--------------+------------------------+ | PROCEDURE    | allrecords     ... Read More

CSS3 Multi-Column column-rule Property

Giri Raju

Giri Raju

Updated on 21-Jun-2020 05:35:34

The multi-column column-rule property is used to specify the number of rules.You can try to run the following code to implement the column-rule property in CSS3 −ExampleLive Demo<html>    <head>       <style>          .multi {             /* Column count property ... Read More

What are storage engines and how we can check the list of storage engines supported by MySQL installation?

Giri Raju

Giri Raju

Updated on 20-Jun-2020 13:48:51

It may be defined as the software components that a database management system (DBMS) uses to handle different SQL operations like create, read, update and delete data from the database. In other words, it is used by DBMS to manage information in a database. The most widely used storage engine ... Read More

Advertisements