Several problems encountered in using mysql

Source: Internet
Author: User
Tags mysql functions

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 stored procedure parameters cannot contain "@", and you must add "?" before the parameters in the program. ", 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 ~~

Contact Us

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.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.