Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Let us see who the major contributors to MySQL are −Although Oracle Corporation and/or its affiliates own all copyrights in the MySQL server and the MySQL manual, we wish to recognize those who have made contributions of one kind or another to the MySQL distribution. Contributors are listed here, in somewhat random order −Gianmassimo Vigazzola − They helped with the initial port to Win32/NT.Per Eric Olsson − They provided for constructive criticism and real testing of the dynamic record format.Irena Pancirov − Helped with the Win32 port with Borland compiler. They also helped with the mysqlshutdown.exe and mysqlwatch.exe.David J. Hughes ... Read More
Let us understand how MySQL binary and package-based installations can be upgraded in Unix or Linux. This can be done in-place as well as by using a logical upgrade method. Let us understand both these methods in brief −In place upgradeAn in−place upgrade involves shutting down the old MySQL server, replacing the old MySQL binaries or the packages with the new ones.Once this is done, the MySQL server is restarted on the existing data directory.After this, the remaining parts of the existing installation, that require some kind of upgrade, are upgraded.For some Linux platforms, MySQL installation from RPM or Debian ... Read More
Let us understand how to check the version of MySQL that the user is currently running −Before entering queries on the console, it is important to ensure that the user is connected to the server.Check MySQL VersionThe below query would give the version number of the server being used, and the current date.mysql> SELECT VERSION(), CURRENT_DATE;Note: The function ‘VERSION()’ and ‘CURRENT_DATE’ are case −insensitive. This means ‘version()’, ‘Version()’, ‘vERsion()’, all mean the same. Same goes with ‘CURRENT_DATE’QueriesLearn about MySQL QueriesAn SQL query is followed by a semi−colon.When a query is issued to mysql, it sends the query to the server ... Read More
Linux supports many different methods to install MySQL. Only one of the distributions from Oracle needs to be used out of the many installations available.StepsType − Apt, set up method−Enable the MySQL Apt repositoryType − Yum, set up method−Enable the MySQL Yum repositoryType − Zypper, set up method−Enable the MySQL SLES repositoryType − RPM, set up method−Download a specific packageType − DEB, set up method−Download a specific packageType − Generic, set up method−Download a generic packageType − Source, set up method−Compile from sourceType − Docker, set up method−Use Docker Hub for MySQL Community Edition; download Docker image for MySQL Enterprise ... Read More
Some problems with compiling MySQL could be because of not configuring properly. Hence, the solution is to reconfigure.If CMake is run right after it was previously run, there is a possibility that it would use information that was gathered from its previous call. This information is present in CMakeCache.txt. When CMake begins, it looks for this file and reads the contents (if it exists), assuming that the information is correct. This assumption becomes wrong when the file is reconfigured.Each time CMake is run, ‘make’ has to be executed again to recompile. The old object files from previous builds can be ... Read More
Let’s take the concept of arrays to about compile time and run time initialization −ArrayArray is a collection of items stored at contiguous memory locations and elements can access by using indices.Compile time array initializationIn compile time initialization, user has to enter the details in the program itself.Compile time initialization is same as variable initialization. The general form of initialization of array is as follows −Syntaxtype name[size] = { list_of_values }; //integer array initialization int rollnumbers[4]={ 2, 5, 6, 7}; //float array initialization float area[5]={ 23.4, 6.8, 5.5, 7.3, 2.4 }; //character array initialization char name[9]={ 'T', 'u', 't', 'o', ... Read More
ProblemCompiler not reading the string after integer in C programming? How can we solve this problem?SolutionWhen you enter an integer number and press enter to read next value, compiler stores null into the string’s first char and string input terminates. Because scanf will terminate whenever it reads a null character.How to Solve It?When we are trying to read string or character after int or float, we should read a temporary char which is present in the input buffer.The following is the program without errors −Example Live Demo#include struct student{ char name[10]; int roll; char temp; } s; ... Read More
ProblemCommon error occurred while reading string and numeric data using scanf() function in C languageSolutionThe scanf() function is used to read formatted input from stdin in C language. It returns the whole number of characters written in it otherwise, returns a negative value.Generally in case of scanf() function while reading string values after integer from the user, we get frequent errors.ExampleFollowing is a C program which reads roll number (integer value) and name of a student − Live Demo#include struct student { char name[10]; int roll; } s; int main(){ printf("Enter information of students:"); printf("Enter roll ... Read More
ProblemTry to print a name 10 times without using any loop or goto statement in C programming language.SolutionGenerally, looping statements are used to repeat the block of code until condition is false.Example1In this program, we are trying to print a name 10 times without using loop or goto statements. Live Demo#include void printname(char* name,int count){ printf("%03d : %s",count+1,name); count+=1; if(count
Yes, we can give arguments in the main() function.Command line arguments in C are specified after the name of the program in the system’s command line, and these argument values are passed on to your program during program execution.The argc and argv are the two arguments that can pass to main function.But main() function is actually called by the operating system (or shell program) when you run the program from the terminal.SyntaxThe syntax is explained below −int main(int argc, char *argv[]){ //Code return 0; }Example Live Demo#include int main(int argc, char *argv[]){ int i; for (i = ... Read More