![]() command line options, “dry-run” mode, etc.) that I have greater confidence in them. Luckily, with scripts you have so much greater control (i.e. I personally take great precaution with smart solutions. Ummm, did you realize the visual editor would typically use a naive approach of doing everything in one huge transaction? The visual editor allows for export/import/copy/transfer of tables and rows with just one click! “Why is it so complicated in the command line to purge 1,000,000 rows from a table?”.That’s because you can’t beat SHOW CREATE TABLE, the definite table structure description. I didn’t realize it only covered first n characters of my VARCHAR.”. “I didn’t realize the index did(n’t) cover this and that columns. The visual editor shows table definition graphically. ![]() Well, sure, a filesort of 1,000,000 rows that can satisfy the first 1,000 will quit early! “But the same query runs so much faster on my machine!”. The visual editor will only show 1,000 results, via LIMIT 0,1000.The visual editor would open a new connection for every new query (oh, so the I’ve just assigned turns NULL, or the TEMPORARY TABLE disappears).Opening up a console shows a completely different picture. Time and again students show me something on their editor. Well, again and again I reach the same conclusion: Visual editors are not as trustworthy as the command line. Most students will give it a shot, then go back to their favorite editor. Or you would copy+paste from some text editor. And repeating your last command with a minor modification requires a lot of key stroking. It may not even be convenient (especially on Windows, in my opinion). I always humbly suggest they close down their software and open up a command line. I see MySQL Workbench, SQLyog, Toad for MySQL, or several more. Or they would use MySQL Workbench, which is what I usually have pre-installed on their desktops. Sometimes they just bring over their laptops with the software installed. Typically this would be the software they’re using at work. ![]() Students in my training classes usually prefer to use some kind of visual editor for MySQL.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |