Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology

Shewani has recently started working in MySQL. Help her in understanding the difference between the following : -Technology
by

1 Answer

Answer :

(i) Where clause is used to show data set for a table based on a condition and having clause is used to put condition on the result set that comes after using Group by clause.(ii) COUNT(*) returns the number of items in a group, including NULL values and duplicates. COUNT(expression) evaluates expression for each row in a group and returns the number of non null values.Candidate Key – A Candidate Key can be any column or a combination of columns that can qualify as unique key in database. There can be multiple Candidate Keys in one table. Each Candidate Key can qualify as Primary Key.Primary Key – A Primary Key is a column or a combination of columns that uniquely identify a record. Only one Candidate Key can be Primary Key.A table can have multiple Candidate Keys that are unique as single column or combined multiple columns to the table. They are all candidates for Primary Key.
by

Related questions

Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Description : Ms. Archana, a class XI student has just started learning MySQL. Help her in understanding the basic difference between -Technology

Last Answer : ALTERUPDATEIt s a DDL command.It s a DML command.It can be used for the following purpose:To add a new column.To remove an existing column.To modify a column.To add/remove a constraint.It s ... Delhi ;suitable command:(i)Show Databases(ii) Use City(iii) Drop Database Clients(iv) Drop table Club

Vani, a class X student has recently completed her HTML course and just started learning XML. Help her in the following: -Technology

Description : Vani, a class X student has recently completed her HTML course and just started learning XML. Help her in the following: -Technology

Last Answer : (i) Primary purpose of HTML is to design a webpage while XML is used to store and transport the data.(ii) Right(iii) Comments are added as notes or lines for understanding the purpose of an XML ... .Syntax for comments are as follows:(v)An XML document with correct syntax is called 'Well Formed'.

Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Description : Ms. Pari, a beginner in SQL is not able to understand the meaning of “Cancelling a Transaction”. Help her in understanding the same. -Technology

Last Answer : Cancelling a transaction means rolls the transaction to the beginning. It aborts any changes made during the transaction and the state of database is returned to what it was before the transaction began to execute.Rollback command is used for the same.

is_connected() is the MYSQL function to : -Technology

Description : is_connected() is the MYSQL function to : -Technology

Last Answer : (e)verify whether the python application is connected to mysql database.

In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Description : In a school, a database named “school” is created in mysql whose password is “cbse”. Smith is trying to add a new record of a student having details -Technology

Last Answer : import mysql.connectormydb = mysql.connector.connect{host='localhost',user='root',passwd='cbse',database='school'}mycursor = mydb.cursor()mycursor.execute('INSERT INTO student values(3,'Michelle', 'Agartala');')mydb.commit()

Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Description : Write the code in python to read the contents of “number.csv” file consisting of data from a mysql table and print the data of the table -Technology

Last Answer : f = open('numbers.csv', 'r') with f:reader = csv.reader(f)for row in reader:for e in row:print(e)

What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Description : What is MySQL used for? Abhay wants to start learning MySQL. From where can he obtain the MySQL software? -Technology

Last Answer : MySQL is a Relational Database Management System (RDBMS), used for adding, accessing and processing data in a database. Abhay can download the MySQL software setup from Internet.

The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Description : The avg() function in MySql is an example of ..... (a) Math function (b) Text function (c) Date Function (d) Aggregate Function -Technology

Last Answer : (d)Aggregate Function

Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: (i) Explain her the concept of variable -Technology

Last Answer : (i)Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Description : Ruby, a class XI student has just started learning java programming. Help her in the following: -Technology

Last Answer : i. Variables are named storage location to store values temporarily which can be changed during program execution.Data type states the way the values of that type are stored, the operations that can be done ... setText( Just Pass );In the above if statement, value of marks is being compared with 40.

Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Description : Suchi has recently installed a new operating system on her computer. 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware, enables applications, software to be loaded; gives prompts and error reports to the users.2. Command-driven user interface means CUI, by which a user gives instructions via typing command onto the computer.

A man and his wife were slowly driving along when their teenage son, who had just recently received his driver's license, suddenly drove his car up behind them and started to repeatedly smash into the back of their car, while his sister, who was in the car with him, loudly cheered and egged on her brother. Witnesses to the event appeared unaffected by the incident, and in fact some were even observed smiling. The police were never called. What was going on with this family, and why did no one call the police? -Riddles

Description : A man and his wife were slowly driving along when their teenage son, who had just recently received his driver's license, suddenly drove his car up behind them and started to repeatedly smash into the back ... called. What was going on with this family, and why did no one call the police? -Riddles

Last Answer : The man and his wife had taken their two children to an amusement park. The parents were in one bumper car, and their two children were in another bumper car.

Suman is working as marketing manager in an advertising company. She has prepared a presentation on her latest product. -Technology

Description : Suman is working as marketing manager in an advertising company. She has prepared a presentation on her latest product. -Technology

Last Answer : 1. Press the Slide Sorter view button in work space area to view all the slides together.2. In the Slide Transition page, set the timing in Advance slide sections Automatically after position where the ... the layouts of tasks pane, select a chart type slide or use Insert -> Chart menu option.

Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Software name:Team Viewer

Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Description : Ms. Ivana, a leading marketing professional working in a multinational company, is most of the time on move to cater her profession demands. -Technology

Last Answer : Team Viewer

Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Description : Prachi is working with following swing controls: jButton, jLabel, jTextField, jCheckBox. Suggest her any two basic methods commonly available -Technology

Last Answer : getText(), setText()

Have you become more tolerant or understanding of anything recently?

Description : Have you become more tolerant or understanding of anything recently?

Last Answer : Good question. I think.we become more tolerant when we experience whatever ourselves. I can’t say I’ve become.more tolerant of any thing lately, especially not my sister who I haven seen in 15 years and just spent a week with in Florida. AHHHHHHH!!!!

Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Description : Mr. X has recently installed a new operating system on his computer 1. Describe the main functions of an operating system. -Technology

Last Answer : 1. Monitors the performance of the system, enables software to communicate with hardware and application softwares to be loaded; gives prompts and error reports to the users.2. Antivirus and compression tool.

Malini has recently joined a construction company as marketing executive. She saw a presentation about the company. -Technology

Description : Malini has recently joined a construction company as marketing executive. She saw a presentation about the company. -Technology

Last Answer : 1. Insert Picture2. Record Narration3. Hyperlink/Interaction feature4. Header and Footer dialog box

Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?

Description : Is there any difference in terms of performance to build my website's database using PostGreSQL than to built it using MySQL?

Last Answer : A few years back, the choice was between raw speed, in which case you chose MySQL, and features and reliability, in which case you chose PostgreSQL. (If you needed speed, features, and reliability, ... is what databases are built to do, but in older versions of MySQL there was simply no alternative.

MySQL help!

Description : MySQL help!

Last Answer : answer:You spelled “propeller” wrong, for one thing. Table SERVICE_REQUEST has a primary key, SERVICE_ID, which is a DECIMAL field. In your attempt to load the table with the error record, the secondary key value you attempted to insert for SERVICE_ID, ‘7’ is a CHAR value. That’s a show-stopper.

What are the best web sites to get help with Apache, PHP, and MySQL?

Description : What are the best web sites to get help with Apache, PHP, and MySQL?

Last Answer : stackoverflow is the best site programming q & a site I know of. Looks like there is a fair amount of LAMP-related questions there.

Do you find this kid's ability and understanding pretty amazing?

Description : Do you find this kid's ability and understanding pretty amazing?

Last Answer : Sounds like he is a human-alien hybrid.

Who will be benificiated by the trade war started recently?

Description : Who will be benificiated by the trade war started recently?

Last Answer : There may be one off beneficiaries, but from a macro perspective, it will hurt far more people than it will help. Remember that prices will rise without any improvement in goods, economies will shrink rather than expand.

Recently started to get over my social anxiety, but now the holidays are starting to freak me out. Can I just get some words of support?

Description : Recently started to get over my social anxiety, but now the holidays are starting to freak me out. Can I just get some words of support?

Last Answer : answer:Thank you very much for sharing this problem with us. It takes a lot of courage to reach out and invite insight from other people into our own dilemmas. I am not a doctor. I am, however, a ... t give advice, but I can offer you an Internet hug. I hope you make it through this time unscathed.

What are some nouns that recently started being used as verbs?

Description : What are some nouns that recently started being used as verbs?

Last Answer : Suicide Journal Impact

Why is my iPad kicking me out of my apps? It just started doing this recently. What's up?

Description : Why is my iPad kicking me out of my apps? It just started doing this recently. What's up?

Last Answer : My iPod Touch does this sometimes. A hard restart should fix it. On the iPad press and hold sleep/wake button for around five seconds. A red slider should appear. Then you just start it back up. An Apple logo should appear for about a minute while it reboots.

I just found out the protein powder I recently bought and started to take has a decent amount of creatine, what do I do?

Description : I just found out the protein powder I recently bought and started to take has a decent amount of creatine, what do I do?

Last Answer : You should talk to your doctor before taking anymore. The side effects are not worth the benefits.

A visitor from another city comes to your office complaining of incessant cough. He has diabetes and hypertension and has recently started taking a different antihypertensive medication. The most likely cause of his cough is (a) Enalapril (b) Losartan (c) Minoxidil (d) Propranolol (e) Verapamil

Description : A visitor from another city comes to your office complaining of incessant cough. He has diabetes and hypertension and has recently started taking a different antihypertensive medication. The most likely cause of his cough is (a) Enalapril (b) Losartan (c) Minoxidil (d) Propranolol (e) Verapamil

Last Answer : Ans: A

Which country recently started worlds longest zipline? (a) Australia (b) UAE (c) Canada (d) None of These

Description : Which country recently started worlds longest zipline? (a) Australia (b) UAE (c) Canada (d) None of These

Last Answer : (b) UAE

Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Description : Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Last Answer : ASCII: It is a 7 bit code that can represent 27 characters. It is platform dependent.UNICODE: It is 8 bit, 16 bit and 32 bit code to represent 28, 216, 232 characters respectively. It is platform independent.

Ms Samtha has many electronics gadgets which are not usable due to outdated hardware and software. Help her to find any three best ways -Technology

Description : Ms Samtha has many electronics gadgets which are not usable due to outdated hardware and software. Help her to find any three best ways -Technology

Last Answer : 1. Give Your Electronic Waste to a Certified E-Waste Recycler2. Donating Your Outdated Technology3. Give Back to Your Electronic Companies and Drop Off Points.

Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Description : Deepti is confused between the terms ASCII and Unicode. Help her by differentiating between ASCII and Unicode. -Technology

Last Answer : ASCII: It is a 7 bit code that can represent 27 characters. It is platform dependent. UNICODE: It is 8 bit, 16 bit and 32 bit code to represent 28 , 216, 232 characters respectively. It is platform independent.

Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

Description : Ms. Cathy is creating a form for Vidya University Sports Council application. Help her to choose the most appropriate controls -Technology

Last Answer : Appropriate controls for the given entries :S.NOFunctionControl1.To let the user enter NameTextField2.To let the user enter MOBILE NUMBERTextField3.To let the user choose one PROFESSION out of the ... , Yoga, Table Tennis, Badminton and Aerobics. More than one facility may be chosen.CheckBox

Joan recently changed employers within the same industry. At her old company, employees routinely took home company pens, pencils, and note pads, and they frequently made personal long -distance calls on company phones. Joan observes that employees do not engage in such practices at her new company. What Joan sees could best be described as a difference in A)significant others. B)profit objectives. C)corporate culture. D)legal climate. E)corporate goals.

Description : Joan recently changed employers within the same industry. At her old company, employees routinely took home company pens, pencils, and note pads, and they frequently made personal long -distance ... A)significant others. B)profit objectives. C)corporate culture. D)legal climate. E)corporate goals

Last Answer : D)legal climate

Empty entries in a mysql/php5 site database,... why?

Description : Empty entries in a mysql/php5 site database,... why?

Last Answer : How are you migrating the database? What are you using to export and import?

MySQL order by primary key, put one row on top.

Description : MySQL order by primary key, put one row on top.

Last Answer : answer:If you can guarantee that there is only one or zero active records select * from presets order by active asc, id asc

As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Description : As a specialist PHP/MySQL programmer at my (not so fun to work at) job, what's my future?

Last Answer : It depends if you want to continue doing programming or not. If you have good people skills, and good business sense, you could get PMP certified, or learn VersionOne and move to the business ... business side. We also prize business analysts with SQL knowledge in order to manage data and metrics.

If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Description : If I already know basic PHP/MySQL, what else should I learn to use Google App Engine?

Last Answer : answer:I am not an expert, I just started reading up on this myself, but here are a couple of starting points on data storage. Rather than a separately maintained SQL database, ... .com/appengine/articles/datastore/overview.html http://code.google.com/appengine/docs/python/datastore/overview.html

What takes more computing power, serving HTTP or MySQL?

Description : What takes more computing power, serving HTTP or MySQL?

Last Answer : this is not exactly my field, but i would say http has much more to do that mysql. with http you are loading everything, where mysql is just loading data. i guess it could depend on the site and whats on it, but for the most part http will be doing most the work.

What is apache or perl or php or mySQL?

Description : What is apache or perl or php or mySQL?

Last Answer : Apache, Perl, PHP, MySQL Seriously, Wikipedia does wonders. Also try searching with Google.

PHP/MySQL question.... (please read on)

Description : PHP/MySQL question.... (please read on)

Last Answer : Have you looked through these?

What is a good book for learning PHP and MySQL?

Description : What is a good book for learning PHP and MySQL?

Last Answer : I’d start here: http://www.php.net/manual/en/ Get a feel for PHP, then buy books to fill in the gaps or get deeper into particular areas.

How long does it take to learn PHP & MySQL?

Description : How long does it take to learn PHP & MySQL?

Last Answer : The O’Reilly Head First book on this is great.

Add an ID column to an already existing MySQL table?

Description : Add an ID column to an already existing MySQL table?

Last Answer : I’m not an expert on MySQL [@stewartwb?], but in SQLServer that works just fine. Add the column and set the identity property and it autogenerates. What happens when you try that in MySQL? Do you get an error? or does it just not populate?

Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Description : Do you know webhosting server including with these details: free, about 1-2 gigabytes, php script OK, mysql OK, no adds on site?

Last Answer : Hosting a free Wordpress blog. Interesting. Did you try wordpress.com? Most hosts aren’t going to offer those serviced ad-free for free. I can’t think of a single one. Everyone needs a business model. And even if I found one, I certainly wouldn’t trust it for stability and security.

How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Description : How can I create an ordered list of the most common substrings inside of a MySQL varchar column?

Last Answer : SQL is definitely not my specialty but you can use regular expressions within your select statement is this something you want to pull on the fly each time though? It seems like as your data set grows it ... ve got me wondering if I can write one SQL statement for it though, let me take a look.

Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Description : Can someone please explain to me exactly how PHP, mySQL, Javascript, and HTML/CSS are related?

Last Answer : PHP is a serverside language, while JavaScript and mySQL are clientside languages. I think the difference is that PHP/HTML is the language used by the server to encode instructions for the web browser, ... have no idea whether it's accurate or not. I just started learning this stuff this week.

MySQL Sort by every other row?

Description : MySQL Sort by every other row?

Last Answer : Couldn’t you just grab the males in a query and do the same for the females. Then loop through them in PHP. If that made any sense.

Getting certified in PHP and MySQL?

Description : Getting certified in PHP and MySQL?

Last Answer : I think Zend, the company behind PHP, has some kind of certification. Is this required for something? I’ve honestly never seen a job requiring a “certified” PHP programmer. Edit: This looks like it.