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
-
Economics & Finance
Articles by AmitDiwan
Page 688 of 840
MySQL Command-Line Options that Affect Option-File Handling
Let us understand how MySQL command line options affect option file handling −Many of the MySQL programs which support option files handle the below options. Since these options affect option-file handling, they must be provided on the command line and not in an option ile. For it to work properly, each of these options must be provided before other options, with the below mentioned exceptions −−−print−defaults should be used immediately after −−defaults−file, −−defaults−extra−file, or −−loginpath.On Windows, if the server startup is done with the --defaults-file and --install options, --install must be first.--defaults-extra-file=file_nameOn Unix, read the above line in option file ...
Read MoreUsing Option Files for MySQL programs? Usage of Option Files
Let us understand how option files can be used with MySQL programs −Most MySQL programs can read the startup options from option files, which is also known as the configuration files.Option files provide an easy way to specify commonly used options so that they need not be entered on the command line every time the user runs a program.To know whether a program reads option files or not, it can be invoked with the help of the −−help option.For mysqld, the −−verbose and –help can be used.If the program reads option files, the help message indicates the files that it ...
Read MoreUsing Options on the Command Line for MySQL programs?
Let us understand how to use options on command line for MySQL programs −The program options which are specified on the command line follow the below rules −The options are given after the command name.An option argument begins with one dash or two dashes, and this depends on whether it is a short form or long form of the option name.Many options have both short and long forms. Let us take an example to understand this − −? and −−help are the short and long forms of the option which instructs a MySQL program to display the help message.The option ...
Read MoreInvoking MySQL Programs
A MySQL program can be invoked from the command line (i.e, from your shell or command prompt).How to invoke?This can be done by entering the program name followed by any options or arguments that would be needed to instruct the program to do what the user wants.The below commands show some sample program invocations. The ‘shell>’ represents the prompt for the command interpreter; which is not part of what the user types. The specific prompt seen by user depends on their command interpreter.Typical prompts are $ for sh, ksh, or bash, % for csh or tcsh, and C:\> for the ...
Read MoreOverview of MySQL Programs
There are many programs in a MySQL installation. Let us see an overview of some of the programs. Some programs are platform−specific, which means they are not present in all of MySQL distributions.Every MySQL program takes different options. There is a ‘- - help’ option that can be used to get a description of the program’s different options. The default option values can be overridden for MySQL program, by specifying options on command line or in an option file.Every MySQL program takes different options. There is a ‘- - help’ option that can be used to get a description of ...
Read MoreWorking with AUTO_INCREMENT Columns in MySQL
Let us understand how to work with AUTO_INCREMENT columns in MySQL −The AUTO_INCREMENT attribute is used to generate a unique identify for new rows. Let us see how this statement works. Before that, consider the below query −QueryCREATE TABLE tableName ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO tableName (name) VALUES (‘val1’), ('val2'), ('val3'), ('val4'); SELECT * FROM tableName;Output+----+---------+ | id | name | +----+---------+ | 1 | val1 | | 2 | val2 | | ...
Read MoreMySQL AUTO_INCREMENT with Examples
Let us understand how ATUO_INCREMENT works −The AUTO_INCREMENT attribute is used to generate a unique identify for new rows. Let us see how this statement works. Before that, consider the below query −QueryCREATE TABLE tableName ( id MEDIUMINT NOT NULL AUTO_INCREMENT, name CHAR(30) NOT NULL, PRIMARY KEY (id) ); INSERT INTO tableName (name) VALUES (‘val1’), ('val2'), ('val3'), ('val4'); SELECT * FROM tableName;Output+----+---------+ | id | name | +----+---------+ | 1 | val1 | | 2 | val2 | | 3 | val3 | | ...
Read MoreSQL queries for counter web visits per day, month, year and totals
Let us understand how to form the query to find the number of web visits per day, per month, per year, and the total in MySQL:Note: We assume we have created a database named ‘DBNAME’ and a table named ‘tableName’.Let us see the MySQL query which can be used to get the web visits per day, month, year and totals −QuerySELECT COUNT(DISTINCT ip) FROM tableName WHERE create_at >= LAST_DAY(NOW()) + INTERVAL 1 DAY - INTERVAL 1 MONTH AND create_at < LAST_DAY(NOW()) + INTERVAL 1 DAYThe above query searches through a range of DATETIME values by beginning from the present month ...
Read MoreHow can I count visitors per page per day using MySQL?
Note: We assume we have created a database named ‘DBNAME’ and a table named ‘tableName’.Let us understand how the count of visitors per day per page can be queried using MySQL. This can be done using the bit group function −QuerySELECT DATE(date) Date, page_id, COUNT(*) colName FROM tableName GROUP BY DATE(date), page_idHere ‘colName’ refers to the ‘visits per day’ column, and ‘tableName’ refers to the table that contains details about visitors.It makes sure that the duplicate values in the table are removed when the above query is run.
Read MoreMaking slow queries fast using composite indexes in MySQL
Let us first see what is Composite Index −A composite index is an index that is used on multiple columns.It is also known as a multiple-column index.MySQL allows the user to create a composite index which can consist of up to 16 columns.The query optimizer uses the composite indexes for queries which will test all columns in the index.It can also be used for queries which will test the first columns, the first two columns, and so on.If the columns are specified in the right order in the index definition, a single composite index can be used that would speed ...
Read More