Syntax\n------\n\n_rowid\n\nDescription\n-----------\n\nThe _rowid pseudo column is mapped to the primary key in the related table. This can be used as a replacement of the rowid pseudo column in other databases. Another usage is to simplify sql queries as one doesn't have to know the name of the primary key.\n\nExamples\n--------\n\nCREATE TABLE t1 (a INT PRIMARY KEY, b VARCHAR(80));\nINSERT INTO t1 VALUES (1,"one"),(2,"two");\nSELECT * FROM t1 WHERE _rowid=1;\n\nURL: https://mariadb.com/docs/server/reference/sql-functions/pseudo-columns/_rowid