Hey.

Question by mysql. I decided to see what is in the database table.

mysql> SHOW DATABASES; +--------------------+ | Database | +--------------------+ | information_schema | | mysql | | performance_schema | | qwe | | test | +--------------------+ 5 rows in set (0.24 sec) mysql> USE qwe; Database changed mysql> SHOW TABLES; Empty set (0.11 sec) mysql> CREATE TABLE table1(name VARCHAR(15) DEFAULT NULL, sourname VARCHAR(15) DEFAULT NULL); Query OK, 0 rows affected (0.92 sec) mysql> SHOW TABLES; +---------------+ | Tables_in_qwe | +---------------+ | table1 | +---------------+ 1 row in set (0.08 sec) mysql> INSERT INTO table1 (name, sourname) VALUES ('Vasia', 'Vasiliev'); Query OK, 1 row affected (0.17 sec) mysql> SELECT * FROM table1; +-------+----------+ | name | sourname | +-------+----------+ | Vasia | Vasiliev | +-------+----------+ 1 row in set (0.00 sec)

I have a qwe db-folder in which only 1 table is - table1 . That is, I created the table table1 , stuffed two fields into it - name and sourname , added the entry with "Vasia" "Vasiliev" , opened this table in the hex editor, but did not see there "Vasia" "Vasiliev" , but saw it :

enter image description here

Question - WHERE is the entry with cells "Vasia" "Vasiliev" ? **** What is this db.opt file (encoding and collation is indicated inside it) is in the qwe database folder?

  • What is the default table engine in your database? If innoDB, then the data is in the common innoDB data file. If MyISAM, then there should be several files. .frm - structure description In general, in the official MySQL documentation you can find descriptions of data storage - Mike
  • probably, innoDB, because if you open the table in a hacks editor, then there are innoDB characters - Dimon
  • one
    For innoDB, by default everything is in one ibdata1 file at the root of the data directory. Only descriptions of the structure in the database folders - Mike

0