mysql 冒号

SET @myVariable = 'Hello, World!';
SELECT @myVariable;

SHOW VARIABLES LIKE 'max_connections';

DELIMITER //
CREATE PROCEDURE myProcedure(IN param1 INT)
BEGIN
    SELECT * FROM myTable WHERE id = param1;
END //
DELIMITER ;

SELECT 'Hello, World!' REGEXP '(?P<greeting>Hello)';

mysql -h localhost -P 3306 -u username -p

[mysqld]
port=3306

SELECT JSON_EXTRACT('{"key": "value"}', '$.key');

SET @myVariable = 'Hello, World!';
SELECT @myVariable; -- 确保变量名拼写正确

DELIMITER //
CREATE PROCEDURE myProcedure(IN param1 INT)
BEGIN
    SELECT * FROM myTable WHERE id = param1;
END //
DEL览器;
CALL myProcedure(1); -- 确保正确传递参数

SELECT 'Hello, World!' REGEXP '(?P<greeting>Hello)'; -- 确保MySQL版本支持命名捕获组