You don't have to worry about it. You have never worried about it before. Haha, if you want to perform visualized operations in MSSQL, you can use MySQL administrator. This is when you develop software. If you want to develop a website and use PHP, you can use phpadmin as a visualization tool. Well, you should have an initial impression on MySQL ~~
Second, MySQL creates a stored procedure. Haha, MySQL is special. The parameters of the stored procedure cannot contain "@". ProgramWhen using the parameter, add "?" before the parameter. Well, as you get used to MSSQL, it takes a while to create a stored procedure using MySQL. "@" Is not applicable in MySQL, but "?" is used. .
Furthermore, when accessing the stored procedure created by MySQL through a program, you must add the database name before the stored procedure, and the database name must be in lower case, this allows me to get out of one and enter another.
Continue:
MySQL stored procedures cannot have return, of course MySQL functions can have. What if the stored procedure returns a value? Don't worry. MySQL provides parameter modifiers in, out, And inout. Do you know what it means? If a parameter is used for output results, you can use out to modify it.
There are so many other things you may encounter when you wait. Haha, good luck ~~
The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion;
products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the
content of the page makes you feel confusing, please write us an email, we will handle the problem
within 5 days after receiving your email.
If you find any instances of plagiarism from the community, please send an email to:
info-contact@alibabacloud.com
and provide relevant evidence. A staff member will contact you within 5 working days.