techguru-sampan.blogspot.com

How to Execute Query & Stored Procedure in Linux Using Shell Scripting. You can simply use below mention script for executing the query or procedure. #!/bin/sh mysql -u root –ppassword -e 'call test_procedure();' Databasename Where -p is used password in which you can mention the password of your mysql. Where -e is used for executing the   query or stored procedure. Where databasename is used for your mysql database name. #!/bin/sh mysql -u root –ppassword -e ‘select * from tbl_test;’ Databasename   This single line can be used for   executing stored procedure as well as sql query. You can save this script into any extension of file but you need to give the permission first for executing the script file for example: #chmod +x filename

Limitations of MySQL Database Many of the Mysql user does not know the limitations of Mysql database. So here I am writing some of the Mysql limitations are as follows. In mysql database the maximum size of the table is determined by operating system in which the Mysql is installed. So the maximum size of table is allowed by the operating system. Below mentioned table showing the file size limit of operating systems : Operating System File Size Limit Windows (FAT32) 4GB Windows (NTFS) 2TB MacOS 2TB Linux 4TB Solaris 9/10 16TB Limitations of Joins : The maximum number of tables that can be referenced in a single join is 61. This also applies to the number of tables that can be referenced in the definition of a view. It can also applies to LEFT and RIGHT OUTER JOINS. Limitations of the MyISAM storage engine : Large files up to 63-