Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Articles on Trending Technologies
Technical articles with clear explanations and examples
Documenters and translators of MySQL
Let us see who the documenters and translators of MySQL are −Many people have contributed in the MySQL documentation, translation of the documentation and error messages in MySQL. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL.But the major people who have supported in the documentation and translation of certain parts of MySQL by lending their never-ending support, along with their contributions have been listed below −Kim Aldale − They have helped rewrite Monty's and David's early attempts at English into English.Michael J. Miller Jr − They have helped in ...
Read MoreMajor Supporters of MySQL
Let us see who the major supports of MySQL are −Oracle Corporation and/or its affiliates own all copyrights of the MySQL server and the MySQL manual. There are many people, organizations, students, and others who have helped in the development, maintenance, and improvement of MySQL. Many companies have helped in the development of the MySQL server. This includes paying for developing a new feature or providing hardware for development of the MySQL server. They have been listed below −VA Linux / Andover.netThey helped with the funding of the replicationNuSphereThey helped with the editing of the MySQL manual.Stork Design studioIt was ...
Read MoreMySQL Differences from Standard SQL
Let us understand the differences between MySQL and Standard SQL. MySQL performs many operations differently in certain cases −PrivilegesThere are many differences between MySQL and standard SQL with respect to privileges given to the user. In MySQL, privileges for a table are automatically not revoked when a table is deleted. A REVOKE statement needs to be explicitly issued to revoke privileges for a table.Foreign Key ConstraintsThe MySQL implementation of foreign key constraints is different from the SQL standard. If there are many rows in the parent table with the same referenced key value, InnoDB engine does a foreign key check ...
Read MoreMySQL Extensions to Standard SQL
MySQL server supports extensions which may not be found in other SQL databases. This means, if these extensions of MySQL are used, the code can’t be ported to other SQL servers. But sometimes, it can be ported.Let us understand the MySQL extensions to standard SQL −Enclosing StringsThe strings can be enclosed in “ (double quotes) or ‘ (single quote) by default. If the ‘ANSI_QUOTES’ SQL mode is on, the strings have to be enclosed using ‘, and if “ (double quotes) is used, the server interprets this as identifiers.Escape Character\ is the escape character for strings.Accessing TableMySQL doesn’t support tablespaces, ...
Read MoreMySQL Standards Compliance
The standards compliance tells how MySQL is related to the ANSI/ISO SQL standards. There are many versions of the SQL standard, and the phrase ‘SQL standard’ is used to refer to the current version of SQL standard at any point in time.Following are the MySQL Standards Compliance −MySQL server was originally designed to work with medium-sized databases (10 to 100 million rows or 100 MB per table) on small systems. But currently, it has been upgraded to work with terabyte-sized databases.MySQL supports ODBC levels ranging from 0 to 3.5.1.MySQL also supports high-availability database clustering, which can be achieved with the ...
Read MoreHow to delete the vowels from a given string using C language?
The logic we use to implement to delete the vowels from the given string is as follows −for(i=0; i
Read MoreHow to use Pre-defined mathematical function in C language?
ProblemHow to find the cube root of any given number by using the C programming language?SolutionAlgorithmStep 1: Enter any number at run time Step 2: Read from console Step 3: Compute result Result:pow(number, 1.0/3.0) Step 4: Increment result Step 5: Print resultExampleFollowing is the C program to find the cube root of any given number −//finding cube root of given number// #include #include #include void main(){ int number, result; printf("Enter any number: "); scanf("%d", &number); result=pow(number, 1.0/3.0); result++; printf("\Cube of %d is: %d", number, result); getch(); }OutputWhen the above ...
Read MoreWhat are the input and output for strings in C language?
An array of characters (or) collection of characters is called a string.Input and output for stringsExampleFollowing is the C program for input and output for strings −#include main ( ){ char a[30]; printf("enter your name"); scanf ( "%s", a); printf ("your name is %s", a); getch ( ); }OutputWhen the above program is executed, it produces the following result −1. Enter your name : Lucky 2. Enter your name : Lucky Lol Your name is Lucky Your name is LuckyNote −‘&’ is not used for accepting strings because name of the string itself specifies the ...
Read MoreWhat do you mean by buffer in C language?
A temporary storage area is called buffer. All input output (I/O) devices contain I/O buffer.When we try to pass more than the required number of values as input then, the remaining values will automatically hold in the input buffer. This buffer data automatically go to the next input functionality, if it is exists.We have to clear the buffer before the next input is taken in.ExampleFollowing is the C program for buffer −#include void main(){ int a, b; printf(" Enter a value: "); scanf("%d", &a); printf(" Enter b value: "); scanf("%d", &b); printf(" a+b=%d ", ...
Read MoreExplain the constant type qualifier in C language
Type qualifiers add special attributes to existing datatypes in C programming language.There are three type qualifiers in C language and constant type qualifier is explained below −ConstThere are three types of constants, which are as follows −Literal constantsDefined constantsMemory constantsLiteral constants − These are the unnamed constants that are used to specify data.For example, a=b+7 //Here ‘7’ is literal constant.Defined constants − These constants use the preprocessor command ‘define" with #For example, #define PI 3.1415Memory constants − These constants use ‘C’ qualifier ‘const’, which indicates that the data cannot be changed.The syntax is as follows −const type identifier = valueFor ...
Read More