SQL for Marketers: Dominate data analytics, data science, and big data (Data Science and Machine Learning in Python) by LazyProgrammer

Author:LazyProgrammer
Language: eng
Format: azw3, epub
Published: 2016-03-16T16:00:00+00:00

Check if it’s been updated correctly (you can hit up to use the previous command).

Delete

Now let’s say we want to get rid of this new row. The general syntax for deletion is:

DELETE FROM table_name

WHERE condition;

So for us it would be:

DELETE FROM user_actions WHERE name = ‘John’;

Check if it’s been updated correctly.

CRUD

In this section we’re going to draw an analogy between SQL and web development.

A lot of the time, separating the data from the application gives us a nice architecture where we can split up, the data, the UI, and the application code. You can think of this as model-view-controller or MVC.

Download

Copyright Disclaimer:
This site does not store any files on its server. We only index and link to content provided by other sites. Please contact the content providers to delete copyright contents if any and email us, we'll remove relevant links or contents immediately.