All categories

3 years ago

MySQL Questions?

Computers and Technology

2 answers:

Margarita [4]3 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]3 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

Suppose you find a magic $1.00 coin. Its magic power is as follows: as each day passes, you get an additional dollar plus half o

AfilCa [17]

Answer:

See explaination

Explanation:

public class QuickRich {

static void getRichQuick() {

double amount = 1;

int day = 1;

System.out.println("Day 1: $1");

while (amount < 1000000) {

day++;

if(amount + 1 + (amount/2) < 1000000)

System.out.printf("Day %d: $%.2f + ($1 + %.2f) = $%.2f\n", day, amount, amount/2, amount+(amount/2)+1);

else

System.out.printf("Day %d: $%.2f + ($1 + %.2f) >= $1000000\n", day, amount, amount/2);

amount += (1 + (amount/2));

}

public static void main(String[] args) {

getRichQuick();

}

7 0

4 years ago

Assume that the variables gpa, deansList and studentName, have been declared and initialized . Write a statement that both adds

Alborosie

Answer:

Following are the statement which is given below:

if (gpa > 3.5) // check the condition if gpa exceeds 3.5.

{

deansList++; // increment of 1 in the deansList variable

cout << studentName; // display the studentName,

}

Explanation:

The description of the statement

In the if statement we check the condition of "gpa" .if "gpa" is greater then 3.5 then it executed the statement inside the if block otherwise nothing will be executed.