Tagged questions

1000 results found

SQL Database SampleJune 05, 2016

Do you have a sample of a database that I can upload it in MySQLWorkbench and play with it offline. This will help us practicing more and playing with the SQL.

8

views

0

votes

2

answers

What's the best query to run for "Remove Actors"?June 05, 2016

I first tried to use IN alongside LIKE, but that apparently doesn't work, so I used: DELETE FROM actors WHERE name LIKE "Yuri %" OR name LIKE "Walter %" OR name LIKE "Victor %

8

views

0

votes

2

answers

PHP Debugging in ChromeJune 05, 2016

Hello, is there a way to debug php code running on a local server in google chrome. What i found so far looks dubious... Thanks

10

views

0

votes

4

answers

Trying to use LefT JOIN on 3 tables help please June 05, 2016

I have 3 tables "users" 3 columns User-ID int (11) Location varchar (250) Age int (11) Primary-key (User-ID) "books" 5 columns ISBN varchar (13) Book-title varchar(255) Book-author

10

views

0

votes

1

answers

How does SQL know which id to take as we have book_id,patron_id,id in loans table?June 05, 2016

select first_name,email from patrons where id =4; In this query, how does SQL know that it has to select the patron_id only?

12

views

0

votes

1

answers

SQL, NULL's and auto-increment -- is typing 'null' necessary?June 05, 2016

My question is straightforward. In the review, Chalkley says that using the NULL statement can trigger auto-incrementing columns. My question is, do you have to? Maybe it's different in SQLite, but I

10

views

0

votes

1

answers

Typo in Teacher's NotesJune 05, 2016

In the Teacher's Notes, you wrote the following: "To get the minimum value of a numeric column use the MAX() funciton." I'm pretty sure it should be "MIN() function" rather than &q

43

views

0

votes

1

answers

When using the % as a wildcard, what is the difference in placement? June 05, 2016

What is the difference between "%drew", "Alien%", and "%Brief History%" ?

10

views

0

votes

2

answers

Why the genre column did not update?June 05, 2016

Hi, To update the missing genre raw, I tried my own statement and it did not worked, can you explain why? Here is the query: UPDATE books SET genre="Classic" WHERE genre = NULL; Thank you

9

views

0

votes

4

answers

On the review/practice for SELECT and Aliasing, it asks to alias the title and year_released. Tells me no title column.June 05, 2016

On the reinforcement portion for SELECT and ALIASING. The question to alias title and year_released, when run, tells me there is no column name title. I even tried to copy/paste in the event that I ha

10

views

0

votes

2

answers