This post will cover how to create Stored Procedures using PHP My Admin. Next part will cover how to execute Stored Procedures using Laravel.
First of all what is Stored Procedure?
A stored procedure is a prepared SQL code that you can save, so the code can be reused over and over again.
You can pass parameters to the stored procedure to get data based on Dynamic values.
Step -1 : Open PHP My Admin and select the database to create stored procedure
Step -2 : Go to Routines menu & Click on Add routine.
Step -3 : By Clicking on Add Routine Link, PHPMyAdmin will open Pop-up.
Step -4 : Follow the steps and create stored procedure.Create stored procedure to get data from users table( Without Parameters) .
Stored procedure Without Parameters
CREATE PROCEDURE `GerUsers`() NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER BEGIN Select * From users; END
Stored Procedure with Parameters
CREATE PROCEDURE `GetUserByEmail`(IN `uEmail` VARCHAR(255)) NOT DETERMINISTIC CONTAINS SQL SQL SECURITY DEFINER BEGIN select * from users where email = uEmail; END
Execute Stored Procedure from PHP MyAdmin
PHP MyAdmin will display list of created Stored Procedures.
Click on Execute link to Run Specific Stored Procedure.
Procedure without parameters will directly Run Query and list out the data Procedure parameters will open Pop up to add parameters, then Run Procedure and get result data.
That’s it. Hope this article helps you guys to understand how to mange Stored Procedure Using PHP My Admin. In the Next article I will explain how to Execute Stored Procedure In Laravel Framework.
Part 2 : //medium.com/@nishitvmaheta/how-to-execute-stored-procedure-using-laravel-8d067c306154
To those still experiencing this, and don't want to wait for it to randomly work again:
I just encountered this, and cannot find any explanation other than some bug.
I tried:
CREATE TABLE `database`.`measurement_types` ( `TypeID` INT(2) NOT NULL AUTO_INCREMENT , `Name` VARCHAR(32) NOT NULL , `Description` VARCHAR(256) NOT NULL , PRIMARY KEY (`TypeID`)) ENGINE = InnoDB;Which produced the same "Please enter valid length" error
Tried a few times with different length values, but kept getting the same error.
--SOLUTION--
So I just created the table with a single column first, then altered it with the two other columns like so:
And then:
ALTER TABLE `measurement_types` ADD `Name` VARCHAR(32) NOT NULL AFTER `TypeID`, ADD `Description` VARCHAR(256) NOT NULL AFTER `Name`;And that worked.
I also tried to delete the table and create it with the first SQL again, and this time it worked. Seems pretty random
In this quick tutorial, we'll learn how to check the MySQL version of a server. Without a doubt, MySQL is one of the most popular RDBMS (Relational database management system) options available, so you'll find it pretty much everywhere. There can be some pretty staggering differences between MySQL versions, so knowing which version you're working with is important. Learn here how to check the version of MySQL your server is using!
Let's start with a quick video review of this
subject:
Check the MySQL version
- These instructions are intended for checking the MySQL (or MariaDB) version on our VPS server (and are similar to the dedicated server directions as well).
- We'll be working from our high-availability MySQL server, and I'll be logged in as root.
From the Command Line
- With a command line open, enter the following command:
subject
mysql -V mysql Ver 15.1 Distrib 10.1.29-MariaDB, for Linux (x86_64) using readline 5.1
Note:
Are you looking to upgrade MySQL on a Liquid Web Core Managed or Fully Managed server? Then contact our support team! If you’re looking for ways to improve the performance of your VPS, check out our blog on Optimizing Your VPS!
From the MySQL Client
1. When you run the MySQL command client without any flags the version will be displayed. So while logged in via SSH enter:
mysql Welcome to the MariaDB monitor. Commands end with ; or \g. Your MariaDB connection id is 4 Server version: 10.1.29-MariaDB MariaDB Server Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others. Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
The server version in this example is 10.1.29-MariaDB MariaDB Server.
2. From within the MySQL client, you can also run the following command for more details:
SHOW VARIABLES LIKE "%version%";
+-------------------------+----------------------------+ | Variable_name | Value | +-------------------------+----------------------------+ | innodb_version | 5.6.36-82.2 | | protocol_version | 10 | | slave_type_conversions | | | version | 10.1.29-MariaDB | | version_comment | MariaDB Server | | version_compile_machine | x86_64 | | version_compile_os | Linux | | version_malloc_library | system | | version_ssl_library | OpenSSL 1.1.0g 2 Nov 2017 | | wsrep_patch_version | wsrep_25.21 | +-------------------------+----------------------------+ 10 rows in set (0.02 sec)
In this block of text, you'll find additional version details about your installed MySQL software like innodb_version, protocol_version, version_ssl_library, and more.
From The PHPMyAdmin Interface
If you aren't familiar with running commands through ssh, you may have access to PHPMyAdmin on the server which gives a nice graphical interface for managing the databases. If you have cPanel or Plesk access you should be able to open PHPMyAdmin when logged in to the hosting account. In PHPMyAdmin on the right side, it should have information listen under the "Database server" section and the "Server version" is what shows the MySQL or MariaDB version is running on the server.
When standard uptime is not enough, you don’t have to wage war alone. Liquid Web's High-Availability Databases provides the bleeding edge hardware needed for keeping your site online. Does significantly reducing overhead while not having to worry about managing MySQL sounds like a dream come true? Then check out our affordable plans!