How to filter a table in mysql

Question

1.00/5 (1 vote)

See more:

hi all

I have two questions

question 1: I am doing another table where i have to display all the customers that are not in a particular area, what is the proper syntax

question 2: how do you increase the credit limit for customers whose credit limit is $10,000 and over by 20%

can someone point me in the right direction.

What I have tried:

for question 1: I have tried this:

SQL

select * from customers where not exist = port of spain

I idk if that is the correct syntax and for question 2 I have tried this

SQL

select custID, fname,lname, creditLimit
from customers
where creditLimit >= $10000  and creditLimit * 0.20%

I do not know if that also is the correct answer,

Posted 6-Apr-18 16:25pm

divinity02

Updated 6-Apr-18 19:00pm

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2018-04-06T19:01:00

First of all, you haven't shared the table definitions so it's quite impossible to use the exact syntax.

Furthermore, this sounds like homework, and we don't do homework. After all the main idea in homework is that the student learns.

But to get you started. For question 1: Have a look at the comparisons. I think you'll find the exact answer from the documentation: MySQL :: MySQL 5.7 Reference Manual :: 12.3.2 Comparison Functions and Operators[^]

For question 2: to make changes to an existing row, you need to use UPDATE statement. Have a look at MySQL :: MySQL 5.7 Reference Manual :: 13.2.11 UPDATE Syntax[^]