All categories

2 years ago

How to create create a database in mysql using clv files

1 answer:

7 0

Access the command line. Open whatever application you use to access your computer's command line interface.

Log into MySQL mysql -u my_user -p.

Connect to your database USE database_name;

Create a skeleton table that will house your CSV data.

Load the table with data from your CSV file.

You might be interested in

SHOW ALL YOUR WORK. REMEMBER THAT PROGRAM SEGMENTS ARE TO BE WRITTEN IN JAVA. Assume that the classes listed in the Java Quick R

adoni [48]

Answer:

Check the explanation

Explanation:

Player 1 Coin

Player 2 Coin

Player 1

Player 2

Round

Count at

Player

Coin

Number

Beginning of

Outcome

Count at

Round

Spends

End of

Round

Off-by-

one,

10 - 1

player 2

10 - 2

= 8

gains 1

= 10

coin

Same,

10 - 2

player 2

gains 1

coin

Off-by-

two,

6 - 1

player 1

9 - 3

gains 2

coins

Same,

player 2

7 - 2

6 - 2+

gains 1

coin

Kindly check the attached image below to see the well arranged table to solve the above question.

4 0

3 years ago

True or False (type the entire word)

kozerog [31]

Answer:

True.

Explanation:

(Facts from Google): The answer is true because small data is defined as data that is small enough for human comprehension. Big data is data that comes in large chunks and is too large for traditional data processing. Small data is most likely all about finding the causation because it is understandable, and therefore can be read.

5 0

2 years ago

Write a repetition statement that outputs the numbers 45 , 51 , . . . , 165 . That is, all of the multiples of 6 in increasing o

Bingel [31]

Answer:

#include <iostream>

using namespace std;

int main()

{

int i = 45;

for ( i = 45; i <=165; i = i + 6)

cout << i << endl;

}

Explanation:

I corrected your code and highlighted the mistakes. Even though you wrote the correct algorithm, your code did not compile because of the typos you made.

Remember, C++ is a case-sensitive language. That means, "For" is not same as "for".

Generally, variables and keywords are written in lower case. Of course, there are exceptions, such as constant variables are all written in uppercase letter and class names start with an uppercase letter.

8 0

3 years ago

You are going to write a program for Computer test which will read 10 questions from a file, order them randomly and provide the

ollegr [7]

Answer:

from pprint import pprint

import random

match = {

"mcq1": "a",

"mcq2": "c",

"mcq3": "c",

"mcq4": "d",

"mcq5": "a",

"mcq6": "a",

"mcq7": "a",

"mcq8": "b",

"mcq9": "d",

"mcq10": "a"

}

file = open("test","r")

questions = set()

for i in range(10):

ques = []

for line in file:

if "-" in line:

break

else:

ques.append(line)

questions.add(tuple(ques))

def quiz(questions, match):

questions = list(questions)

marks = 0

for i in range(10):

pprint(questions[i])

mcq = "mcq",str(i+1)

mcq = list(mcq)

answer = input("enter your answer: ")

if answer == match["".join(mcq)]:

marks += 1

return marks

print("Your score is: ",quiz(questions, match))

Explanation:

the file which has been loaded is test, and its data is provided below...

mcq1. The device which converts analog signals to digtital signals and vice versa is called.

a) mother board

b) TAP

c) Modem

d) I/O device

mcq2. The main components of a computer system are.

a) TAP, CPU, Printer

b) CPU, Input device

c) CPU, ALU, CU

d) CPU , Output device , Memory unit, Control unit

mcq3. A source program is a program.

a) writter in machine laguage

b) translated in machine langaue

c) written in high level language

d) required to boot a computer

mcq4.Which image format supports transparency in images.

a) PNG

b) GIF

c) JPG

d) A & B

mcq5. (10111) 2 = (?) 10.

a) 23

b) 50

c) 24

d) 89

mcq6. UNICODE is an example of.

a) character encoding set

b) driver

c) software

d) database

mcq7. (10111) 2 = (?) 10.

a) 23

b) 50

c) 24

d) 89

mcq8. NTFS stand for.

a) Network File Saving

b) New Technology File System

c) Newt Trend File Saving

d) Non Technology File System

mcq9. FF is example of.

a) Octal number system

b) Binary Number System

c) Decimal Number System

d) Hexadecimal number system

mcq10. Emails are sent with the help of ?

a) SMTP

b) FTP

c) HTTP

d) UDP

3 0

3 years ago

What is a motherboard

aleksandr82 [10.1K]

Answer:

A motherboard is the main printed circuit board in general-purpose computers and other expandable systems. It holds and allows communication between many of the crucial electronic components of a system

Explanation:

8 0

2 years ago