1answer.
Ask question
Login Signup
Ask question
All categories
  • English
  • Mathematics
  • Social Studies
  • Business
  • History
  • Health
  • Geography
  • Biology
  • Physics
  • Chemistry
  • Computers and Technology
  • Arts
  • World Languages
  • Spanish
  • French
  • German
  • Advanced Placement (AP)
  • SAT
  • Medicine
  • Law
  • Engineering
fgiga [73]
2 years ago
11

MySQL Questions?

Computers and Technology
2 answers:
Margarita [4]2 years ago
6 0

Answer:

The Statement for selecting values from the table in SQL is given below,

SELECT vendor_name, vendor_contact_last_name, vendor_contact_first_name FROM Vendors;

Explanation:

SQL stands for Structured query language which is used to insert, update, delete and modify the value in a table.

There are five types of SQL-

1. Data definition language  

2. Data manipulation language

3. Data control language

4. Transaction Control Language

5. Data Query Language

The SELECT statement comes under DDL which is used to select and display values from a table.

We can use select statement in two ways-

1. SELECT column_name1, column_name2 ........column_nameN FROM Table_name;

2. SELECT * FROM tablename; ( This is used to select all values from the table name)

We can also give conditions using WHERE clause while selecting values.

Viktor [21]2 years ago
5 0

Answer:

To answer this question first step is to

1. Query the table in this case vendor, so we use the SELECT statement to bring out data from a table.

SELECT vendor_name, vendor_contact_last_name, vendor_contact_first_name FROM Vendors

Explanation:

The FROM statement allows you to choose which table you want to access the selected columns. Also the columns will be comma separated so it knows that we are selecting different columns.

You might be interested in
You want to securely erase data from your hard drive what can you use to do this and what is the process called
tankabanditka [31]
You could Factory Reset a computer or you could smash it with  a hammer
7 0
3 years ago
Read 2 more answers
How many currencies do recognize?
klemol [59]
The United Nations currently recognizes 180 currencies that are used in 195 countries across the world the United States dollar is a popular currency and about 66 countries either peg their currency to the US dollar or use it as their currency
3 0
3 years ago
Wap in java to complete the following (16*1) +(14*2) +(12*3) +(10*4) +(8*5) +(6*6) +(4*7)​
vladimir1956 [14]

Answer:

It goes like:

public class Program

{

public static void main(String[] args)

{

int j=18;

int sum=0;

for (int i =1; i<7; i++)

{

sum=sum+(i*(j-2));

j=j-2;

}

System.out.println(sum);

}

}

Explanation:

<u>Variables used: </u>

j : controls the first number in product and decreases by 2 each time the loop runs.

sum: saves the values of addition as the loop runs.

3 0
2 years ago
HTML5 is______because it works on tablet or smartphone,notebooks
jeyben [28]

Answer:

Wonderful and easy language

Explanation:

Hope this helps

3 0
3 years ago
Read 2 more answers
What is the difference between above ground mining and underground mining?
neonofarm [45]
If this is in reference to diamond mining then above ground would be panning while below ground would be the actual mining into the soil. 
6 0
2 years ago
Other questions:
  • ____________________ is the premeditated, politically motivated attacks against information, computer systems, computer programs
    6·2 answers
  • The Transmission Control Protocol (TCP) splits each message into multiple packets. It's possible for packets from the same messa
    10·1 answer
  • Web 2.0 has led to a shift just from consuming content towards what
    6·1 answer
  • Assuming that t is an array and tPtr is a pointer to that array, which expression refers to the address of element 3 of the arra
    7·1 answer
  • Which field of study would be most useful for a person who wants to work in a recycling plant?
    12·2 answers
  • What are the advantages of Napier bones?​
    15·1 answer
  • Which application is a digital version of a manual typewriter? A. Database B. Presentation C. Spreadsheet D. Word processor
    8·2 answers
  • Find the root using bisection method with initials 1 and 2 for function 0.005(e^(2x))cos(x) in matlab and error 1e-10?
    8·1 answer
  • What is it called when servers on the Internet supply applications as a service, rather than a product
    14·1 answer
  • I have this questions i need to make it in a report format pages of atleast 3 pages and maximum of 5 pages​
    7·1 answer
Add answer
Login
Not registered? Fast signup
Signup
Login Signup
Ask question!