This command only enters the user and password of youphptube and then gives your points, what else does it do?

|
priti singh 2022-08-28 12:59:28
pls solve this
priti singh 2022-08-28 12:59:40
8 no
priti singh 2022-08-28 12:59:48
question
priti singh 2022-08-28 12:59:53
only
Yogesh Pandey 2022-08-28 13:13:03
priti singh 2022-08-28 12:59:40
8 no

mysql_en-24447.jpg

priti singh 2022-08-28 13:16:47
aap n name coloum select nhi kiya to kaise show ho raha
Yogesh Pandey 2022-08-28 13:18:44
Phle show Kiya tha badme photo ke liye delete kar diya tha.
priti singh 2022-08-28 13:20:28
mujhe exact btaiye
priti singh 2022-08-28 13:33:17
thanks its work
Swapnil 2022-08-28 13:38:57
Yogesh Pandey 2022-08-28 13:13:03

Should have used case statement like below
select population,
case
when population between 0 and 2000 then ‘low’
when population between 2001 and 4000 then ‘medium’
when population > 4000 then ‘high’ end as score
from world.country

Swapnil 2022-08-28 13:39:19
Union should be avoided wherever possible
Swapnil 2022-08-28 13:40:00
Swapnil 2022-08-28 13:38:57
Should have used case statement like below
select population,
case
when population between 0 and 2000 then ‘low’
when population between 2001 and 4000 then ‘medium’
when population > 4000 then ‘high’ end as score
from world.country

priti

Cobrapeace 2022-08-28 15:25:46
Warm Greetings to you all
Please I have a humble request and I will need assistance so those who can should help me out. I have been tasked to present a project for assessment at school. Can I get a project idea for MySQL
Cobrapeace 2022-08-28 15:25:53
Views are welcome
Swapnil 2022-08-28 15:49:55
Cobrapeace 2022-08-28 15:25:46
Warm Greetings to you all
Please I have a humble request and I will need assistance so those who can should help me out. I have been tasked to present a project for assessment at school. Can I get a project idea for MySQL

Post your question and someone will definately answer

N Mohamed rafi 2022-08-28 20:51:23
i am developing code in jsp & html & css & writing code in notepad++ & backend is mysql 1.4version, here i am having 4lakhs rows & 26columns but i can’t display morethan 27000rows limit condition also applied but not displaying all records. how to display all 4,00,000 rows records in output?
This is mysql query (select * from data limit 400000;)

Pls expert provide me solution..

smlkw 2022-08-29 00:27:37
N Mohamed rafi 2022-08-28 20:51:23
i am developing code in jsp & html & css & writing code in notepad++ & backend is mysql 1.4version, here i am having 4lakhs rows & 26columns but i can’t display morethan 27000rows limit condition also applied but not displaying all records. how to display all 4,00,000 rows records in output?
This is mysql query (select * from data limit 400000;)

Pls expert provide me solution..

Export solution: don’t do it

N Mohamed rafi 2022-08-29 03:48:55
smlkw 2022-08-29 00:27:37
Export solution: don’t do it

why ji❓is it not possible?

savvy_phukan 2022-08-29 11:48:37
Hi, what are the advance sql topics that i can prepare?
sara sara 2022-08-29 12:27:58
Hello, this command only enters the user and password of youphptube and then gives your points, what else does it do?

sudo mysql -u root -e “USE mysql;CREATE USER ‘youphptube’@’localhost’ IDENTIFIED BY ‘youphptube’;GRANT ALL PRIVILEGES ON *.* TO ‘youphptube’@’localhost’; FLUSH PRIVILEGES; ”

Senthil 2022-08-29 16:11:03
An attempt to recover an InnoDB Cluster fails.
Examine this set of messages and responses: host3:3377 ssl JS > dba.rebootClusterFromCompleteOutage() Reconfiguring the default cluster from complete outage…
The instance ‘host1:3377” was part of the cluster configuration.
Would you like to rejoin it to the cluster? [y/N]: y
The instance ‘host2:3377’ was part of the cluster configuration. Would you like to rejoin it to the cluster? [y/N]: y Dba.rebootClusterFromCompleteOutage: The active session instance isn’t the most updated in comparison with the ONLINE instances of the Cluster’s metadata. Please use the most up to date instance: ‘host1:3377’. (RuntimeError) Which statement is true?

A. The instance deployed on host3 must be rebuilt with a backup from the primary instance.
B. The cluster is running and there is at least one ONLINE instance.
C. The instance deployed on host3 must be synchronized from a donor deployed on host1 by using the command cluster.addInstance(‘host1:3377’).
D. It is possible to determine the most up-to-date instance by comparing different global transaction identifier (GTID) sets with GTID_SUBSET(set1,set2).
E. The active session instance is invalid and must be re-created by using the command shell.connect(‘host3:3377’).

Senthil 2022-08-29 16:11:19
Any inputs pls?
Liran 2022-08-29 16:45:09
can someone help me analyze a query’s explain?
N Mohamed rafi 2022-08-29 20:09:57
no one is helping. waste forum
Gnation88 2022-08-29 20:21:07
Anyone has worked on MySQL clone plug-in
A 2022-08-29 20:56:15
Can someone share some good resource to learn schema design (beginner)
SANATH 2022-08-30 06:23:08
Anyone having MySQL vedios for beginners
Maneesh Jagarlamudi 2022-08-30 08:27:03
I am using MySQL rds
Maneesh Jagarlamudi 2022-08-30 08:28:47
I am unable to run select *from table into outfile
Liran 2022-08-30 12:01:06
which log file do i need if I wants to see errors? like sql syntax errors?
Liran 2022-08-30 15:37:10
i have mysql 5.7 – does adding a new column with ALGORITHM=INPLACE, LOCK=NONE will not lock the table while adding the column?
Liran 2022-08-30 15:48:10
from what i understand is that algoritham=inplace as default

The ALGORITHM clause is optional. If the ALGORITHM clause is omitted (or if you specify ALGORITHM=DEFAULT), MySQL uses ALGORITHM=INPLACE for storage engines and ALTER TABLE clauses that support it. Otherwise, ALGORITHM=COPY is used.

Liran 2022-08-30 15:48:43
but is LOCK=NONE is also default? and is it nessecary to avoid locks when altetering table?
Cobrapeace 2022-08-31 01:58:00
database management system projects in sql with source code needed
Monu 2022-08-31 03:18:26
How to insert multiple record in SQL table using python
|