mysql

Documentation

Index

• Constants
• func EofChar() int
• func ExtractMysqlComment(sql string) (string, string)
• func Parse(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)
• func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)
• func PutScanner(scanner *Scanner)
• type Lexer
  • func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *Lexer
  • func (l *Lexer) AppendStmt(stmt tree.Statement)
  • func (l *Lexer) Error(err string)
  • func (l *Lexer) GetParamIndex() int
  • func (l *Lexer) Lex(lval *yySymType) int
• type PositionedErr
  • func (p PositionedErr) Error() string
• type Scanner
  • func NewScanner(dialectType dialect.DialectType, sql string) *Scanner
  • func (s *Scanner) Scan() (int, string)
  • func (s *Scanner) ScanComment() (int, string)

Constants

const ACCOUNT = 57672

const ACCOUNTS = 57673

const ACTION = 57625

const ADD = 57559

const ADDDATE = 57867

const ADMIN_NAME = 57722

const AFTER = 57389

const AGAINST = 57859

const ALGORITHM = 57632

const ALL = 57374

const ALTER = 57555

const ANALYZE = 57558

const AND = 57452

const ANY = 57639

const APPROXNUM = 57715

const APPROX_COUNT = 57873

const APPROX_COUNT_DISTINCT = 57874

const APPROX_PERCENTILE = 57875

const ARROW = 57915

const AS = 57377

const ASC = 57379

const ASCII = 57682

const ASSIGNMENT = 57470

const ATTRIBUTE = 57725

const AT_AT_ID = 57427

const AT_ID = 57426

const AUTOEXTEND_SIZE = 57721

const AUTO_INCREMENT = 57714

const AUTO_RANDOM = 57619

const AVG = 57906

const AVG_ROW_LENGTH = 57595

const BACKEND = 57936

const BACKUP = 57942

const BEGIN = 57483

const BETWEEN = 57454

const BIGINT = 57502

const BINARY = 57478

const BINDINGS = 57923

const BIT = 57496

const BIT_AND = 57868

const BIT_CAST = 57910

const BIT_LITERAL = 57439

const BIT_OR = 57869

const BIT_XOR = 57870

const BLOB = 57524

const BOOL = 57516

const BOOLEAN = 57860

const BOTH = 57665

const BSI = 57661

const BTREE = 57658

const BY = 57363

const CALL = 57931

const CANCEL = 57855

const CASCADE = 57624

const CASCADED = 57402

const CASE = 57455

const CAST = 57871

const CHAIN = 57491

const CHANGE = 57680

const CHAR = 57514

const CHARACTER = 57517

const CHARSET = 57446

const CHECK = 57628

const CHECKSUM = 57599

const CIPHER = 57737

const CLIENT = 57705

const CLUSTER = 57637

const CLUSTER_CENTERS = 57891

const COALESCE = 57683

const COLLATE = 57477

const COLLATION = 57684

const COLUMN = 57570

const COLUMNS = 57782

const COLUMN_FORMAT = 57618

const COLUMN_NUMBER = 57792

const COMMENT = 57431

const COMMENT_KEYWORD = 57432

const COMMIT = 57486

const COMMITTED = 57805

const COMPACT = 57616

const COMPRESSED = 57614

const COMPRESSION = 57600

const CONFIG = 57846

const CONNECT = 57367

const CONNECTION = 57754

const CONNECTOR = 57851

const CONNECTORS = 57852

const CONSISTENT = 57489

const CONSTRAINT = 57571

const CONVERT = 57820

const COPY = 57392

const COUNT = 57872

const CREATE = 57554

const CREDENTIALS = 57435

const CROSS = 57416

const CURDATE = 57876

const CURRENT = 57728

const CURRENT_DATE = 57823

const CURRENT_ROLE = 57825

const CURRENT_TIME = 57813

const CURRENT_TIMESTAMP = 57811

const CURRENT_USER = 57824

const CURRVAL = 57913

const CURTIME = 57877

const CYCLE = 57649

const DAEMON = 57853

const DATA = 57601

const DATABASE = 57812

const DATABASES = 57775

const DATE = 57579

const DATETIME = 57512

const DATE_ADD = 57878

const DATE_SUB = 57879

const DAY = 57675

const DAY_HOUR = 57835

const DAY_MICROSECOND = 57832

const DAY_MINUTE = 57834

const DAY_SECOND = 57833

const DEALLOCATE = 57645

const DECIMAL = 57507

const DECIMAL_VALUE = 57509

const DECLARE = 57925

const DEFAULT = 57383

const DEFINER = 57398

const DELAYED = 57553

const DELAY_KEY_WRITE = 57603

const DELETE = 57358

const DENSE_RANK = 57909

const DESC = 57380

const DESCRIBE = 57577

const DIRECTORY = 57602

const DISABLE = 57393

const DISCARD = 57768

const DISK = 57597

const DISTINCT = 57375

const DISTINCTROW = 57376

const DIV = 57474

const DO = 57924

const DOUBLE = 57505

const DRAINER = 57847

const DROP = 57556

const DUPLICATE = 57382

const DYNAMIC = 57613

const ELSE = 57458

const ELSEIF = 57460

const EMPTY = 57347

const ENABLE = 57394

const ENCLOSED = 57762

const ENCRYPTION = 57604

const END = 57459

const ENFORCED = 57629

const ENGINE = 57605

const ENGINES = 57719

const ENGINE_ATTRIBUTE = 57620

const ENUM = 57529

const ERRORS = 57784

const ESCAPE = 57580

const ESCAPED = 57763

const EVENT = 57711

const EVENTS = 57809

const EXCEPT = 57349

const EXCLUSIVE = 57747

const EXECUTE = 57698

const EXISTS = 57378

const EXPANSION = 57864

const EXPIRE = 57671

const EXPLAIN = 57578

const EXTENDED = 57778

const EXTENSION = 57647

const EXTERNAL = 57641

const EXTRACT = 57880

const FAILED_LOGIN_ATTEMPTS = 57730

const FALSE = 57444

const FIELDS = 57781

const FILE = 57708

const FILESYSTEM = 57943

const FILL = 57934

const FIRST = 57387

const FIXED = 57617

const FLOAT = 57440

const FLOAT_TYPE = 57506

const FOLLOWING = 57773

const FOR = 57366

const FORCE = 57419

const FORCE_QUOTE = 57920

const FOREIGN = 57574

const FORMAT = 57752

const FROM = 57359

const FULL = 57779

const FULLTEXT = 57573

const FUNCTION = 57695

const GE = 57463

const GEOMETRY = 57533

const GEOMETRYCOLLECTION = 57537

const GLOBAL = 57796

const GRANT = 57700

const GRANTS = 57369

const GROUP = 57361

const GROUPS = 57774

const GROUP_CONCAT = 57881

const HANDLER = 57938

const HASH = 57659

const HAVING = 57362

const HEADER = 57918

const HEADERS = 57850

const HEX = 57438

const HEXNUM = 57441

const HIGH_PRIORITY = 57552

const HISTORY = 57726

const HOUR = 57685

const HOUR_MICROSECOND = 57829

const HOUR_MINUTE = 57831

const HOUR_SECOND = 57830

const ID = 57425

const IDENTIFIED = 57736

const IF = 57568

const IGNORE = 57567

const ILIKE = 57471

const IMPORT = 57767

const IN = 57469

const INCREMENT = 57648

const INDEX = 57564

const INDEXES = 57786

const INFILE = 57759

const INLINE = 57758

const INNER = 57414

const INOUT = 57482

const INPLACE = 57391

const INSERT = 57356

const INSERT_METHOD = 57622

const INSTANT = 57390

const INT = 57500

const INT1 = 57541

const INT2 = 57542

const INT3 = 57543

const INT4 = 57544

const INT8 = 57545

const INTEGER = 57501

const INTEGRAL = 57437

const INTERSECT = 57350

const INTERVAL = 57480

const INTNUM = 57503

const INTO = 57381

const INVISIBLE = 57657

const INVOKER = 57399

const IS = 57466

const ISOLATION = 57799

const ISSUER = 57738

const ITERATE = 57929

const IVFFLAT = 57662

const JOIN = 57410

const JSON = 57528

const JSONTYPE = 57769

const KEY = 57448

const KEYS = 57385

const KEY_BLOCK_SIZE = 57575

const KILL = 57941

const LANGUAGE = 57861

const LAST = 57388

const LASTVAL = 57914

const LE = 57462

const LEADING = 57664

const LEAVE = 57928

const LEFT = 57412

const LESS = 57587

const LEVEL = 57800

const LEX_ERROR = 57346

const LIKE = 57467

const LIMIT = 57364

const LINEAR = 57633

const LINES = 57765

const LINESTRING = 57535

const LIST = 57631

const LISTS = 57668

const LIST_ARG = 57430

const LOAD = 57757

const LOCAL = 57808

const LOCALFILE = 57642

const LOCALTIME = 57814

const LOCALTIMESTAMP = 57815

const LOCK = 57384

const LOCKS = 57789

const LONGBLOB = 57527

const LONGTEXT = 57523

const LOOP = 57926

const LOWER_THAN_CHARSET = 57445

const LOWER_THAN_COMMA = 57354

const LOWER_THAN_EQ = 57461

const LOWER_THAN_ON = 57420

const LOWER_THAN_ORDER = 57352

const LOWER_THAN_SET = 57372

const LOWER_THAN_STRING = 57424

const LOW_CARDINALITY = 57720

const LOW_PRIORITY = 57551

const MANAGE = 57368

const MATCH = 57858

const MAX = 57882

const MAXVALUE = 57584

const MAX_CONNECTIONS_PER_HOUR = 57750

const MAX_FILE_SIZE = 57919

const MAX_QUERIES_PER_HOUR = 57748

const MAX_ROWS = 57606

const MAX_UPDATES_PER_HOUR = 57749

const MAX_USER_CONNECTIONS = 57751

const MEDIAN = 57890

const MEDIUMBLOB = 57526

const MEDIUMINT = 57499

const MEDIUMTEXT = 57522

const MEMORY = 57598

const MERGE = 57396

const MICROSECOND = 57686

const MID = 57883

const MIN = 57884

const MINUS = 57351

const MINUTE = 57687

const MINUTE_MICROSECOND = 57827

const MINUTE_SECOND = 57828

const MINVALUE = 57650

const MIN_ROWS = 57607

const MOD = 57475

const MODE = 57407

const MODIFY = 57679

const MODUMP = 57770

const MONTH = 57688

const MULTILINESTRING = 57539

const MULTIPOINT = 57538

const MULTIPOLYGON = 57540

const MYSQL_COMPATIBILITY_MODE = 57678

const NAMES = 57795

const NATURAL = 57417

const NCHAR = 57519

const NE = 57464

const NEVER = 57676

const NEXT = 57404

const NEXTVAL = 57911

const NO = 57492

const NODE = 57788

const NONE = 57744

const NOT = 57453

const NOW = 57885

const NULL = 57442

const NULLS = 57386

const NULLX = 57713

const NULL_SAFE_EQUAL = 57465

const NUMERIC = 57508

const OFFSET = 57365

const ON = 57421

const ONLY = 57803

const OPEN = 57783

const OPTIMIZE = 57582

const OPTION = 57701

const OPTIONAL = 57729

const OPTIONALLY = 57761

const OP_TYPE = 57669

const OR = 57449

const ORDER = 57353

const OUT = 57481

const OUTER = 57415

const OUTFILE = 57917

const OVER = 57771

const OWNERSHIP = 57370

const PACK_KEYS = 57608

const PARALLEL = 57921

const PARSER = 57655

const PARTIAL = 57626

const PARTITION = 57585

const PARTITIONS = 57634

const PASSWORD = 57745

const PASSWORD_LOCK_TIME = 57731

const PAUSE = 57854

const PERCENT = 57939

const PERSIST = 57797

const PIPE_CONCAT = 57450

const PLUGINS = 57810

const POINT = 57534

const POLYGON = 57536

const POSITION = 57886

const PRECEDING = 57772

const PREPARE = 57644

const PREV = 57932

const PRIMARY = 57569

const PRIORITY = 57494

const PRIVILEGES = 57696

const PROCEDURE = 57589

const PROCESSLIST = 57780

const PROFILES = 57756

const PROPERTIES = 57654

const PROXY = 57594

const PUBLICATION = 57651

const PUBLICATIONS = 57653

const PUMP = 57677

const QUARTER = 57689

const QUERY = 57863

const QUERY_RESULT = 57944

const QUICK = 57495

const QUOTE_ID = 57433

const RANDOM = 57723

const RANGE = 57630

const RANK = 57907

const READ = 57801

const REAL = 57504

const RECURSIVE = 57845

const REDUNDANT = 57615

const REFERENCE = 57371

const REFERENCES = 57702

const REGEXP = 57468

const REINDEX = 57670

const RELEASE = 57493

const RELOAD = 57707

const RENAME = 57557

const REORGANIZE = 57586

const REPAIR = 57581

const REPEAT = 57690

const REPEATABLE = 57804

const REPLACE = 57819

const REPLICATION = 57703

const REQUIRE = 57742

const RESET = 57646

const RESTRICT = 57623

const RESTRICTED = 57734

const RESUME = 57857

const RETURNS = 57560

const REUSE = 57727

const REVERSE = 57691

const REVOKE = 57694

const RIGHT = 57413

const ROLE = 57593

const ROLES = 57790

const ROLLBACK = 57487

const ROUTINE = 57710

const ROW = 57916

const ROWS = 57766

const ROW_COUNT = 57692

const ROW_FORMAT = 57609

const ROW_NUMBER = 57908

const RTREE = 57660

const S3OPTION = 57546

const SAMPLE = 57940

const SAN = 57741

const SCHEMA = 57561

const SCHEMAS = 57787

const SECOND = 57681

const SECONDARY = 57733

const SECONDARY_ENGINE_ATTRIBUTE = 57621

const SECOND_MICROSECOND = 57826

const SECURITY = 57401

const SELECT = 57355

const SEPARATOR = 57821

const SEQUENCE = 57563

const SEQUENCES = 57777

const SERIALIZABLE = 57807

const SERVERS = 57937

const SESSION = 57798

const SESSION_USER = 57887

const SET = 57373

const SETVAL = 57912

const SHARE = 57406

const SHARED = 57746

const SHIFT_LEFT = 57472

const SHIFT_RIGHT = 57473

const SHOW = 57576

const SHUTDOWN = 57712

const SIGNED = 57716

const SIMPLE = 57627

const SLAVE = 57704

const SLIDING = 57933

const SMALLINT = 57498

const SNAPSHOT = 57490

const SOME = 57640

const SOURCE = 57848

const SPATIAL = 57572

const SPBEGIN = 57935

const SPHERICAL_KMEANS = 57892

const SQL = 57400

const SQL_BIG_RESULT = 57549

const SQL_BUFFER_RESULT = 57550

const SQL_CACHE = 57409

const SQL_NO_CACHE = 57408

const SQL_SMALL_RESULT = 57548

const SQL_TSI_DAY = 57838

const SQL_TSI_HOUR = 57837

const SQL_TSI_MINUTE = 57844

const SQL_TSI_MONTH = 57840

const SQL_TSI_QUARTER = 57841

const SQL_TSI_SECOND = 57843

const SQL_TSI_WEEK = 57839

const SQL_TSI_YEAR = 57842

const SSL = 57743

const STAGE = 57434

const STAGEOPTION = 57547

const STAGES = 57436

const START = 57484

const STARTING = 57764

const STATS_AUTO_RECALC = 57610

const STATS_PERSISTENT = 57611

const STATS_SAMPLE_PAGES = 57612

const STATUS = 57591

const STD = 57888

const STDDEV = 57889

const STDDEV_POP = 57893

const STDDEV_SAMP = 57894

const STORAGE = 57596

const STRAIGHT_JOIN = 57411

const STREAM = 57849

const STRING = 57428

const SUBDATE = 57895

const SUBJECT = 57740

const SUBPARTITION = 57635

const SUBPARTITIONS = 57636

const SUBQUERY_AS_EXPR = 57423

const SUBSCRIPTIONS = 57652

const SUBSTR = 57896

const SUBSTRING = 57897

const SUM = 57898

const SUPER = 57699

const SUSPEND = 57724

const SYSDATE = 57899

const SYSTEM_USER = 57900

const TABLE = 57562

const TABLES = 57776

const TABLESPACE = 57697

const TABLE_NUMBER = 57791

const TABLE_SIZE = 57794

const TABLE_VALUES = 57793

const TASK = 57856

const TEMPORARY = 57709

const TEMPTABLE = 57397

const TERMINATED = 57760

const TEXT = 57520

const THAN = 57588

const THEN = 57457

const TIME = 57510

const TIMESTAMP = 57511

const TIMESTAMPDIFF = 57822

const TINYBLOB = 57525

const TINYINT = 57497

const TINYTEXT = 57521

const TO = 57566

const TRAILING = 57666

const TRANSACTION = 57485

const TRANSLATE = 57901

const TRIGGER = 57590

const TRIGGERS = 57755

const TRIM = 57902

const TRUE = 57443

const TRUNCATE = 57583

const TYPE = 57638

const UNARY = 57476

const UNBOUNDED = 57732

const UNCOMMITTED = 57806

const UNDEFINED = 57395

const UNDERSCORE_BINARY = 57479

const UNION = 57348

const UNIQUE = 57447

const UNKNOWN = 57667

const UNLOCK = 57674

const UNSIGNED = 57717

const UNTIL = 57930

const UNUSED = 57922

const UPDATE = 57357

const URL = 57643

const USAGE = 57706

const USE = 57418

const USER = 57735

const USING = 57422

const UTC_DATE = 57816

const UTC_TIME = 57817

const UTC_TIMESTAMP = 57818

const UUID = 57530

const VALIDATION = 57866

const VALUE = 57405

const VALUES = 57403

const VALUE_ARG = 57429

const VARBINARY = 57518

const VARCHAR = 57515

const VARIABLES = 57592

const VARIANCE = 57903

const VAR_POP = 57904

const VAR_SAMP = 57905

const VECF32 = 57531

const VECF64 = 57532

const VERBOSE = 57753

const VIEW = 57565

const VISIBLE = 57656

const WARNINGS = 57785

const WEEK = 57693

const WHEN = 57456

const WHERE = 57360

const WHILE = 57927

const WITH = 57862

const WITHOUT = 57865

const WORK = 57488

const WRITE = 57802

const X509 = 57739

const XOR = 57451

const YEAR = 57513

const YEAR_MONTH = 57836

const ZEROFILL = 57718

const ZONEMAP = 57663

Functions

func EofChar

func EofChar() int

func ExtractMysqlComment

func ExtractMysqlComment(sql string) (string, string)

ExtractMysqlComment extracts the version and SQL from a comment-only query such as /*!50708 sql here */

func Parse

func Parse(ctx context.Context, sql string, lower int64) ([]tree.Statement, error)

func ParseOne

func ParseOne(ctx context.Context, sql string, lower int64) (tree.Statement, error)

func PutScanner

func PutScanner(scanner *Scanner)

Types

type Lexer

type Lexer struct {
	// contains filtered or unexported fields
}

func NewLexer

func NewLexer(dialectType dialect.DialectType, sql string, lower int64) *Lexer

func (*Lexer) AppendStmt

func (l *Lexer) AppendStmt(stmt tree.Statement)

func (*Lexer) Error

func (l *Lexer) Error(err string)

func (*Lexer) GetParamIndex

func (l *Lexer) GetParamIndex() int

func (*Lexer) Lex

func (l *Lexer) Lex(lval *yySymType) int

type PositionedErr

type PositionedErr struct {
	Err    string
	Line   int
	Col    int
	Near   string
	LenStr string
}

PositionedErr holds context related to parser errros

func (PositionedErr) Error

func (p PositionedErr) Error() string

type Scanner

type Scanner struct {
	LastToken string
	LastError error

	MysqlSpecialComment *Scanner

	CommentFlag bool
	Pos         int
	Line        int
	Col         int
	PrePos      int
	// contains filtered or unexported fields
}

func NewScanner

func NewScanner(dialectType dialect.DialectType, sql string) *Scanner

func (*Scanner) Scan

func (s *Scanner) Scan() (int, string)

func (*Scanner) ScanComment

func (s *Scanner) ScanComment() (int, string)

ScanComment finds all Comment (/* */, //) until gets EOF or LEX_ERROR