Question: |
Good-den. Sozdal simple function in MySQL. SET @p0 = `564165`;SELECT `f_person_add` ( @p0 ) AS `f_person_add` ;like vypolnili successfully but this is not added in the table. |
Answer: |
Hello. What conclusion should be the result of this query? Check please. |
Question: |
example perigaum parameter p_email = `[email protected]`BEGIN SELECT p.person_id INTO p_person_id FROM core_persons p WHERE p.`email` = trim(upper(p_email)) LIMIT 0,1; select p_email; END; vozrastaet empty but when I divide so BEGIN SELECT p.person_id INTO p_person_id FROM core_persons p WHERE p.`email` = trim(upper(`[email protected]`)) LIMIT 0,1; select p_email; END;it operate.in procedure |
Question: |
SET @p0 = `[email protected]`;SET @p1 = \";CALL `f_person_add` (@p0 , @p1 , @p2); |
Question: |
created for concepts postou example |
Answer: |
please Wait. |
Question: |
OK |
Answer: |
Check this query: SET @p_email = `[email protected]`; SELECT p.`person_id` INTO @p_person_id FROM core_persons p WHERE p.`email` = trim(upper(@p_email)) LIMIT 0,1; SELECT @p_person_id; SELECT @p_email; |
Answer: |
you Also have a table in the encoding of utf8_general_ci and the table with the data-encoded utf8_unicode_ci is a You need to bring them to a common encoding!!! |