March 31st, 2013, 10:26 PM
Is it important to memorize the synthax of DDL statements.
I believe the whole point of query writting is to be able to write dynamic DML statements and select or update data based on the needs
But what about CREATE and ALTER?
Is it neccesarry to memorize them or is it good enough to rely on phpmyadmin to do so?
March 31st, 2013, 11:20 PM
It's disappointing that you even have to ask.
March 31st, 2013, 11:42 PM
will you do a lot of database administration and raw SQL? Learn the syntax. Is all your application SQL hidden behind an ORM, and does you company have its own DBAs? Don't learn the syntax.
There's no general answer. Learn what you need. Yeah, it's probably a good idea to at least know the basics and be able to look up the rest. But if you never actually need to do CREATE and ALTER queries, knowing all possible syntax details inside out won't help you a lot in your life.
I mean, this is like "Do I need to know exactly how my computer works in order to be a good programmer?". If you're going to do assembler, yes. If you gonna work with some high-level scripting language and no specific performance requirements, no.
March 31st, 2013, 11:53 PM
I haven't memorized the syntax and have no plans to do so; I use phpMyAdmin to generate all of my DDL statements.
I don't write DDL statements often enough to have learned them by memory; thus, I don't use them often enough to make memorizing them worthwhile.
I can read and completely understand any DDL statement, I just can't write them from scratch without a reference.
April 1st, 2013, 06:44 AM
i would just like to point out that those are not your only two options
Originally Posted by zxcvbnm
if you can memorize DDL, more power to you
i've been writing sql since 1987 and i still need to use da manual
as for phpmyadmin, that's a piece of crap, and i would not stake my job on what it produces
April 1st, 2013, 06:54 AM
You live by the GUI, you die by the GUI.
Originally Posted by E-Oreo
What if you don't have that available and still need to administrate your DB?
I will not read nor answer questions where the SQL code is messy and not formatted properly using [code] tags.
Tips on how to ask better questions:
April 1st, 2013, 02:04 PM
If I don't have it available then I use the command line. This is almost always the case on production servers; however, I rarely run structure altering queries by hand on production servers as most of the time the projects I'm working on have some form of migration utility that does it.
I'm not a database administrator; 90% of the database administrator work that I do is on development servers, and is only done in support of development work.