Guys Is their report for mysql also as we get awr report in oracle?

|
sixpeteunder 2019-12-31 15:29:56
MasterZiv 2019-12-30 21:37:23
This is true, but this has nothing to do with joins

Okay, thanks.

MasterZiv 2019-12-31 15:38:58
Gaurav 2019-12-31 15:25:34
can we create a table in mysql without using create keyword??

This is a very strange question…

This is not needed ever!

Gaurav 2019-12-31 15:39:52
MasterZiv 2019-12-31 15:38:58
This is a very strange question…

This is not needed ever!

jst came across a question …

MasterZiv 2019-12-31 15:41:23
Gaurav 2019-12-31 15:25:34
can we create a table in mysql without using create keyword??

Actually, it is

Select… Into …

but this shit is almost never used in production

MasterZiv 2019-12-31 15:41:23
Gaurav 2019-12-31 15:39:52
jst came across a question …

Forget it and sleep well!

Gaurav 2019-12-31 15:41:54
is there any way to get it done without create
sixpeteunder 2019-12-31 15:42:20
Here’s another database question. This one is more of a design problem.

I have users, each of whom can submit a review/”testimonial” on the “system”. Given that each user can only submit one review, and edit it infinite times, should I;
a. Have a separate testimonials table.
b. Add the relevant fields to the users’ table.

MasterZiv 2019-12-31 15:42:43
Gaurav 2019-12-31 15:41:54
is there any way to get it done without create

Above…

Gaurav 2019-12-31 15:43:08
MasterZiv 2019-12-31 15:42:43
Above…

could u plz mention whole query….

Gaurav 2019-12-31 15:43:22
an Example I mean
MasterZiv 2019-12-31 15:44:46
sixpeteunder 2019-12-31 15:42:20
Here’s another database question. This one is more of a design problem.

I have users, each of whom can submit a review/”testimonial” on the “system”. Given that each user can only submit one review, and edit it infinite times, should I;
a. Have a separate testimonials table.
b. Add the relevant fields to the users’ table.

This is typical many to many table, with restriction on number of reviews by one user for one system.

(You don’t have to do anything to enforce this restriction)

MasterZiv 2019-12-31 15:45:24
sixpeteunder 2019-12-31 15:42:20
Here’s another database question. This one is more of a design problem.

I have users, each of whom can submit a review/”testimonial” on the “system”. Given that each user can only submit one review, and edit it infinite times, should I;
a. Have a separate testimonials table.
b. Add the relevant fields to the users’ table.

B) variant is not possible

MasterZiv 2019-12-31 15:46:02
Gaurav 2019-12-31 15:43:08
could u plz mention whole query….

No, why? You asked how I told how.

Gaurav 2019-12-31 15:47:59
I needed an example ……as u suggested using select into…..
Gaurav 2019-12-31 15:48:15
whats ahead of into…..
MasterZiv 2019-12-31 15:54:25
Gaurav 2019-12-31 15:48:15
whats ahead of into…..

Read the docs, heck!

Manogna 2020-01-01 11:18:55
What is use of creating a view?
2020-01-01 12:01:15
Guys Is their report for mysql also as we get awr report in oracle?
MasterZiv 2020-01-01 17:29:21
Manogna 2020-01-01 11:18:55
What is use of creating a view?

Code reuse,
It’s like a procedure in imperative languages.

sixpeteunder 2020-01-02 17:37:54
I have a SELECT query, that returns the correct result set in phpMyAdmin, but when executing the query with php, one column is returned as a separate row. What could be the problem?

PS: If you need to take a look at the query, do let me know, and I will send it here.

iDoNotHaveAName 2020-01-02 18:05:23
sixpeteunder 2020-01-02 17:37:54
I have a SELECT query, that returns the correct result set in phpMyAdmin, but when executing the query with php, one column is returned as a separate row. What could be the problem?

PS: If you need to take a look at the query, do let me know, and I will send it here.

Can u send it here? It seems a PHP coding bug tho

iDoNotHaveAName 2020-01-02 18:06:26
Sometimes it happened almost the same for me, and it has always been a mistake made by me
sixpeteunder 2020-01-02 18:10:33
mysql_en-1349.jpg

sixpeteunder 2020-01-02 18:10:51
Let me take another look at my PHP
sixpeteunder 2020-01-02 18:14:00
iDoNotHaveAName 2020-01-02 18:06:26
Sometimes it happened almost the same for me, and it has always been a mistake made by me

I just found the error, you are right. You were right. Misplaced comma.

MasterZiv 2020-01-03 19:45:14
sixpeteunder 2020-01-02 17:37:54
I have a SELECT query, that returns the correct result set in phpMyAdmin, but when executing the query with php, one column is returned as a separate row. What could be the problem?

PS: If you need to take a look at the query, do let me know, and I will send it here.

This is impossible, this cannot happen

sixpeteunder 2020-01-03 22:32:12
MasterZiv 2020-01-03 19:45:14
This is impossible, this cannot happen

I found the error in my PHP

Manogna 2020-01-04 14:22:35
I am not understanding the concept of injections
iDoNotHaveAName 2020-01-04 19:41:32
Manogna 2020-01-04 14:22:35
I am not understanding the concept of injections

Imagine if a condition is like this
if(string==1) then…
Now imagine if the string would be
“1==1 or”

MasterZiv 2020-01-05 00:56:17
Manogna 2020-01-04 14:22:35
I am not understanding the concept of injections

You don’t need to know it.
Later or will be clear the you

Gaurav 2020-01-05 07:34:46
how should we see list of tables created by us in oracle 10g?
Gaurav 2020-01-05 07:34:59
Like in mysql we use show tables
piterden 2020-01-05 07:37:36
This is the group about MySQL only
Gaurav 2020-01-05 07:38:02
alright
MasterZiv 2020-01-05 09:12:07
Gaurav 2020-01-05 07:34:46
how should we see list of tables created by us in oracle 10g?

Use tables of system catalog

sixpeteunder 2020-01-05 16:36:11
I have another trivial question. I’ve checked resources like StackOverflow but the responses are unclear to me. I have a table with a primary key and two foreign keys; pk, fk_1 and fk_2. pk is auto incrementing.

I want to set up a UNIQUE constraint such that fk_1 can be duplicated, and fk_2 can be duplicated. However they cannot both be duplicated in a single entry.

Example:
If I have the data fk1 = 1 , fk_2 = 1 in the table, the input with fk_1 = 1, fk_2 = 2 is valid, but fk1 = 1 , fk_2 = 1 is invalid. I hope I have explained it well.

MasterZiv 2020-01-06 03:35:18
sixpeteunder 2020-01-05 16:36:11
I have another trivial question. I’ve checked resources like StackOverflow but the responses are unclear to me. I have a table with a primary key and two foreign keys; pk, fk_1 and fk_2. pk is auto incrementing.

I want to set up a UNIQUE constraint such that fk_1 can be duplicated, and fk_2 can be duplicated. However they cannot both be duplicated in a single entry.

Example:
If I have the data fk1 = 1 , fk_2 = 1 in the table, the input with fk_1 = 1, fk_2 = 2 is valid, but fk1 = 1 , fk_2 = 1 is invalid. I hope I have explained it well.

The description is clear, but what is the question?

ICUI4CUtwo 2020-01-07 22:59:08
Hello How are you?
madno 2020-01-08 10:24:13
mysql_en-1400.jpg
I am getting this error when i do status the MySQL
madno 2020-01-08 10:24:28
It is failing to start the service
madno 2020-01-08 10:24:42
Where shud i check for the issue
piterden 2020-01-08 10:26:17
Check journal and logs
2020-01-09 09:34:47
Hi Any,
bash scripts for mysql-slow-query-log-parser
Sergey 2020-01-09 11:02:17
madno 2020-01-08 10:24:13
I am getting this error when i do status the MySQL

sudo systemctl restart mysqld

madno 2020-01-09 11:04:25
Sergey 2020-01-09 11:02:17
sudo systemctl restart mysqld

It worked .. thanx

Sergey 2020-01-09 11:06:34
But to find the reason why this issue have happened you need to check logs. If the issue reoccures again.
madno 2020-01-09 11:35:29
Journalctl -xe was not updating…so it was difficult to find out What was the issue.
sixpeteunder 2020-01-09 13:20:53
MasterZiv 2020-01-06 03:35:18
The description is clear, but what is the question?

I was wondering how to set up such a constraint. I figured it out after more research.

MasterZiv 2020-01-09 15:13:02
sixpeteunder 2020-01-09 13:20:53
I was wondering how to set up such a constraint. I figured it out after more research.

Alter table xxxx add constraint yyyy unique (Field1, Field2)

iDoNotHaveAName 2020-01-10 00:24:10
Hi guys I have
SELECT * FROM (a NATURAL JOIN b) LEFT JOIN c AS LIST
|