filmov
tv
MySQL - Command Line Client - Debugging .sql script that fills tables using INSERT INTO (Mac OS X)

Показать описание
This tutorial demonstrates, how to fill MySQL tables (relations) with data using INSERT INTO MySQL commands. It uses importing of SQL script written in file. The video shows how to correctly debug such SQL script and how many things can go wrong while writing such scripts, i.e. commas, semicolons, incorrect order of INSERT INTO statements, lack of fields for NOT NULL columns, or different number of values in different rows in one INSERT INTO statement.