If you need a structure only .sql file of a MySQL tables’ Data Definition Language (DDL), phpMyAdmin makes this super-easy with just a few clicks. Continue reading and learn how…
(more…)phpMyAdmin
PHP technical writing compilation
Having spent the majority of this year programming a custom reporting dashboard for my employer written in PHP and MySQL, it is an understatement to say that I have learned a lot. Nothing beats real-world experience and I really have come into my own with PHP, learning more and more daily as I continue progressing forward on my goal of becoming a Back-End Web Developer. I have written several PHP-related posts this year and wanted to provide them all in one easy-to-access list. Enjoy! [Keep reading for more MySQL database and Python/PHP-centric content >>>]
Use MySQL UNIQUE Constraint in phpMyAdmin
The MySQL UNIQUE
constraint is often used in a column definition in which we need each value for that column to be distinct from the others. Perhaps it is an email column for an on-line registration form and we want to ensure that users cannot register twice for an account using the same email. Whatever the case may be, UNIQUE
is there to help us ensure this type of data integrity or business requirement. What if the target table already exists and you determine you need to add a UNIQUE
constraint to an existing column? In this post, I will cover 2 ways you can implement a UNIQUE
constraint on existing columns using the phpMyAdmin web interface…
MySQL DROP statement using phpMyAdmin
The MySQL DROP
statement is one of many powerful DDL commands. Be it ALTER TABLE some_table DROP some_column
or DROP some_table
, this type of command can drastically change your data landscape because in executing MySQL DROP
, you are completely removing objects from the database! If you are using the phpMyAdmin web interface, you can execute the MySQL DROP
statement with just a few mouse clicks. Continue reading to see how…