WordPress/PHP Developer Chennai
Structured Query Language, or SQL, is the standard language used to communicate with a database, and or change records and user privileges, and perform queries. The Language, which became an ANSI standard in 1989, is currently used by almost all of today’s commercial RDBMS.
Types of SQL
In this article, I will show you How to Change “Return to Shop” Button text in WooCommerce.
Copy below code and paste into theme function.php file.
add_filter( 'gettext', 'change_woocommerce_return_to_shop_text', 20, 3 );
function change_woocommerce_return_to_shop_text( $translated_text, $text, $domain ) {
switch ( $translated_text ) {
case 'Return to shop' :
$translated_text = __( 'Return to Store', 'woocommerce' );
break;
}
return $translated_text;
}
Have any doubt, then comment here!
There are mainly five types of tables present in MySQL. Out of all these database engines, the default database engine used in MySQL is MyISAM. Refer below to know the five types of tables:
SIX triggers are allowed in MySQL table. They are as follows:
Following objects are created using CREATE statement:
A BLOB is a binary large object that can hold a variable amount of data. There are four types of BLOB
They all differ only in the maximum length of the values they can hold.
A TEXT is a case-insensitive BLOB. The four TEXT types
They all correspond to the four BLOB types and have the same maximum lengths and storage requirements.
The only difference between BLOB and TEXT types is that sorting and comparison is performed in case-sensitive for BLOB values and case-insensitive for TEXT values.
Every row of a table is identified uniquely by primary key. There is only one primary key for a table.
Primary Key is also a candidate key. By common convention, candidate key can be designated as primary and which can be used for any foreign key references.
TIMESTAMP column is updated with Zero when the table is created. UPDATE CURRENT_TIMESTAMP modifier updates the timestamp field to current time whenever there is a change in other fields of the table.
Following are the differences between CHAR and VARCHAR:
jQuery.ajax() method performs asynchronous http request and gets the data from the server. it allows you to send asynchronous http requests to submit or retrieve data from the server without reloading the whole page.
it can be used to send http GET, POST, PUT, DELETE etc. request. It can retrieve any type of response from the server.
Syntax: jQuery.ajax(url,[options])
Use option parameter to customize ajax request as per your need. All available options for configuring Ajax request can be listed below.