classMySqlProvider

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker, 'mysql-5.7.44');
    $provider->integerLiteral(min: 42, max: 42) // => '42'

new \SqlFaker\MySqlProvider(\Faker\Factory::create(), 'missing-version') // throws \RuntimeException: Unsupported

$provider = new \SqlFaker\MySqlProvider(\Faker\Factory::create());
    $plan = (new \SqlFaker\Generation\Choice\BytePlanCompiler())->compile('', $provider->planner());
    $provider->generate($plan) === $provider->generate($plan) // => true

$provider = new \SqlFaker\SqliteProvider(\Faker\Factory::create());
    $plan = \SqlFaker\Generation\Plan\GenerationPlan::all()->requiringNonEmpty()->withExpansionBudget(100);
    $provider->generate($plan) !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->sql(\SqlFaker\MySql\StatementType::Select, maxDepth: 0);
    preg_match('/\bSELECT\b/i', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->sqlWithoutEmptyRows(\SqlFaker\MySql\StatementType::Select, maxDepth: 0);
    preg_match('/\bSELECT\b/i', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->selectStatement(maxDepth: 0);
    preg_match('/\bSELECT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertStatement(maxDepth: 0);
    preg_match('/\bINSERT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->updateStatement(maxDepth: 0);
    preg_match('/\bUPDATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->deleteStatement(maxDepth: 0);
    preg_match('/\bDELETE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->loadDataStatement(maxDepth: 0);
    preg_match('/\bLOAD\b.*\bDATA\b.*\bINFILE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->multiTableUpdateStatement(maxDepth: 0);
    preg_match('/\bUPDATE\b.*,.*\bSET\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->multiTableDeleteStatement(maxDepth: 0);
    preg_match('/\bDELETE\b.*,.*\bFROM\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createTableStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->alterTableStatement(maxDepth: 0);
    preg_match('/\bALTER\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->dropTableStatement(maxDepth: 0);
    preg_match('/\bDROP\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->simpleStatement(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->identifier(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->quotedIdentifier(minLength: 4, maxLength: 4);
    preg_match('/^`[a-z_][a-z0-9_]{3}`$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->stringLiteral(minLength: 4, maxLength: 4);
    preg_match('/^\'[A-Za-z0-9_]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->nationalStringLiteral(minLength: 4, maxLength: 4);
    preg_match('/^N\'[A-Za-z0-9_]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->dollarQuotedString(minLength: 4, maxLength: 4);
    preg_match('/^\$\$[A-Za-z0-9_]{4}\$\$$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $provider->integerLiteral(min: 42, max: 42) // => '42'

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $provider->longIntegerLiteral(min: 42, max: 42) // => '42'

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->unsignedBigIntLiteral(minLength: 4, maxLength: 4);
    preg_match('/^(0|[1-9][0-9]{0,3})$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->decimalLiteral(precision: 5, scale: 2);
    preg_match('/^[0-9]{1,3}\.[0-9]{2}$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->floatLiteral(precision: 5, scale: 2, minExponent: 3, maxExponent: 3);
    preg_match('/^[0-9]{1,3}\.[0-9]{2}e3$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->hexLiteral(minLength: 4, maxLength: 4);
    preg_match('/^0x[0-9a-f]{4}$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->quotedHexLiteral(minBytes: 2, maxBytes: 2);
    preg_match('/^X\'[0-9a-f]{4}\'$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->binaryLiteral(minLength: 4, maxLength: 4);
    preg_match('/^0b[01]{4}$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $token = $provider->hostname(minParts: 2, maxParts: 2, maxPartLength: 4);
    preg_match('/^[a-z0-9]{1,4}\.[a-z0-9]{1,4}$/', $token) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->replaceStatement(maxDepth: 0);
    preg_match('/\bREPLACE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->truncateStatement(maxDepth: 0);
    preg_match('/\bTRUNCATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->createIndexStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bINDEX\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->dropIndexStatement(maxDepth: 0);
    preg_match('/\bDROP\b.*\bINDEX\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->beginStatement(maxDepth: 0);
    preg_match('/\bBEGIN\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->commitStatement(maxDepth: 0);
    preg_match('/\bCOMMIT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->rollbackStatement(maxDepth: 0);
    preg_match('/\bROLLBACK\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->expr(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->simpleExpr(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->literal(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->predicate(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->whereClause(maxDepth: 0);
    preg_match('/\bWHERE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->orderClause(maxDepth: 0);
    preg_match('/\bORDER\b.*\bBY\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->limitClause(maxDepth: 0);
    preg_match('/\bLIMIT\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->tableReference(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->joinedTable(maxDepth: 0);
    preg_match('/\bJOIN\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->tableIdent(maxDepth: 0);
    $sql !== '' // => true

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->subquery(maxDepth: 0);
    preg_match('/\(.*\bSELECT\b.*\)/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->withClause(maxDepth: 0);
    preg_match('/\bWITH\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->foreignKeyConstraint(maxDepth: 0);
    preg_match('/\bCONSTRAINT\b.*\bFOREIGN\b.*\bREFERENCES\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->updateJoinDerivedStatement(maxDepth: 0);
    preg_match('/\bUPDATE\b.*\bJOIN\b.*\bSELECT\b.*\bSET\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertSelectCompoundStatement(maxDepth: 0);
    preg_match('/\bINSERT\b.*\bSELECT\b.*\bUNION\b.*\bALL\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertRowAliasUpsertStatement(maxDepth: 0);
    preg_match('/\bINSERT\b.*\bAS\b.*\bDUPLICATE\b.*\bUPDATE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->insertFunctionUpsertStatement(maxDepth: 0);
    preg_match('/\bINSERT\b.*\bDUPLICATE\b.*\bUPDATE\b.*\bIF\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->fullTextSearchStatement(maxDepth: 0);
    preg_match('/\bSELECT\b.*\bMATCH\b.*\bAGAINST\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->temporaryTableStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bTEMP(?:ORARY)?\b.*\bTABLE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->viewStatement(maxDepth: 0);
    preg_match('/\bCREATE\b.*\bVIEW\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->generatedColumnStatement(maxDepth: 0);
    preg_match('/\bGENERATED\b.*\bALWAYS\b.*\bAS\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->foreignKeyCascadeStatement(maxDepth: 0);
    preg_match('/\bREFERENCES\b.*\bCASCADE\b.*\bCASCADE\b/is', $sql) // => 1

$faker = \Faker\Factory::create();
    $provider = new \SqlFaker\MySqlProvider($faker);
    $faker->seed(7);
    $sql = $provider->partitionSelectStatement(maxDepth: 0);
    preg_match('/\bSELECT\b.*\bPARTITION\b/is', $sql) // => 1