normalize_mysql

Replaces constants with '?' placeholder.Outputs the normalized query along with the values of the parameters

Returns: STRING

The normalized query with the values of the parameters in the query as JSON.

Arguments

Variable	Type	Description
sql_string	STRING	The MySQL query string
cmd_code	INT64	The MySQL command code for this sql request.

Examples:

# Normalize the SQL query.
df.normalized_sql_json = px.normalize_mysql(df.sql_query_string)
# Pluck the relevant values from the json.
df.normed_query = px.pluck(df.normalized_sql_json, 'query')
df.params = px.pluck(df.normalized_sql_json, 'params')

This site uses cookies to provide you with a better user experience. By using Pixie, you consent to our use of cookies.