# Get the first name and copy it to a new column Here's how ALTER TABLE emailsĪDD COLUMN `fname` VARCHAR(30) AFTER `Full Name`,ĪDD COLUMN `lname` VARCHAR(30) AFTER `fname` Suppose you have a column titled Full Name and you want to split the information into two columns Fname and Lname. ALTER TABLE MyTable CHANGE COLUMN `Full Name` to `Name` Suppose you just want to change the name of a column, here's how to run that function. SELECT DISTINCT `column name` FROM `table name` # Create a view that will only show unique values from within a single column. You're interested in knowing how many unique cities are within the thousands of observations. Suppose you have a database filled with thousands of rows and one of the columns is titled Cities. Navicat - Views Get Unique Data from a Single Column If you look to the left, you'll notice that there are views, queries, and functions.īelow are a few of my favorite examples of views, queries and functions. Even better, you can save your work into the cloud for reuse. Navicat Premium helps you create views, queries and functions using an easy-to-use UIX. If you work regularly with MySQL, Mongo DB, AWS RDS, or DynamoDB, then you might find Navicat Premium useful.
0 kommentar(er)
