CODEWITHSUNDEEP
mysqlsqlderived
user3351284
user3351284

Reputation: 31

SQL Derived Table

I am new to SQL and really struggle just testing it out. My question is how do I derive data from one table to a new one keeping only specific data like: -Real name -Screen name

and also how do I create new variables using SQL. For example the Number of tweets that the person contributed.

Upvotes: 0

Views: 77

Answers (2)

Gordon Linoff
Gordon Linoff

Reputation: 1269953

In MySQL, you would use create table as:

create table table2 as
    select RealName, ScreenName
    from table1;

However, you don't actually need to copy the data. You can just use a view instead:

create view table2 as
    select RealName, ScreenName
    from table1;

Or, just put the logic into your query.

Upvotes: 3

codelover
codelover

Reputation: 317

SELECT ur specific column

INTO newtable

FROM oldtable;

check here for more examples

Upvotes: 0

Related Questions