Did you check your function if it exist or not?

qualification of candidate called education
qualification of company called opening
when candidate makes opening it calls placement

candidate can have A FEW jobhistories

qualification consists of courses witch consists of sessions and participation of candidate in a session calls enroll

but participation of a candidate in a qualification calls education

what if session would been the part of qualification not related to a candidate?

candidate already have his own qualification through session and course

Are you The Lord of Rings?

I write following:

SELECT C.CAND_NUM,C.CAND_LNAME, CR.COURSE_NUM,CR.COURSE_DESCRIPTION FROM CANDIDATE AS C INNER JOIN EDUCATION AS E ON C.CAND_NUM=E.CAND_NUM INNER JOIN COURSE AS CR ON CR.QUAL_CODE= E.QUAL_CODE INNER JOIN PLACEMENT AS P ON C.CAND_NUM=P.CAND_NUM WHERE C.CAND_NUM<>P.CAND_NUM

For query 5

Need help to correct

Sorry I don’t have more time now

Ok. Thanks Denis..

Hello guys i really need help with MySQL for beginners please

Mysql documentation is the way

Okay

Can I get some pdf

For beginners

Go to mysql website. You have the option to download there, the documentation

https://www.percona.com/blog/2015/01/29/multi-threaded-replication-with-mysql-5-6-use-gtids/

Hi everyone, I want to sort my database by one specific field, for example, I have the name of the database of football players, there is an identifier of a football player, name and age! Want to show the older from 25 years old? How can i do this? Please help me

You should select all rows where your condition is true. I suggest you to read docs about MySQL queries.

Thank you for suggestion!

Anyone with details knowledge on innodb_flush_log_at_trx_commit

innodb_flush_method

Use O_Direct

Use 2 for high throughput
Use 1 for data consistency bt ur performance will slightly impact
And uh can use 0 if for high throughput as well

Better go with 1 and innodb_flush_method = O_Direct will give uh better performance.

Few blogs mentions that in case of sever crash, data can be retrieved from logs amd innodb crash recovery, if innodb_flush_log_at_trx_commit is 2.

The details are in the docs, very detailed.

There is a mistake, 1 not for data consistency, 1 for crash-safe. Ilia said right, read the docs.

With flush_trx_commit !=1 in bad case you can loose approx 1 second of data

Guys I need one help

How to select all records which are in 5 minute intervals

Schematically:

Select * from thetable where moment between now () and now () – 5 minutes

mysql> Select * from master_invoiceheader_logistics where MAKERDTM between ‘2020-06-01 00:00:00’ and now () – INTERVAL 5 MINUTE;
ERROR 1630 (42000): FUNCTION nippon_Nadi.now does not exist. Check the ‘Function Name Parsing and Resolution’ section in the Reference Manual
mysql>

requirements,
get the data with the difference of more than 5 mins

did you check your function if it exist or not ?

select invoiceDate,MAKERDTM from master_invoiceheader_logistics where MAKERDTM >= date_sub(‘2020-06-01 00:00:00’, interval 5 minute) order by MAKERDTM ;

FUNCTION nippon_Nadi.now does not exist ,
so check your function name .

ok bro

is that correct for that requirement

i don’t know because i don’t see the columns

+————-+———————+
| invoiceDate | MAKERDTM |
+————-+———————+
| 2020-06-01 | 2020-06-01 04:32:05 |
| 2020-06-01 | 2020-06-01 04:32:05 |
| 2020-06-01 | 2020-06-01 04:32:05 |
| 2020-06-01 | 2020-06-01 04:32:05 |
| 2020-06-01 | 2020-06-01 04:32:05 |
| 2020-06-01 | 2020-06-01 05:00:04 |
| 2020-06-01 | 2020-06-01 05:00:04 |
| 2020-06-01 | 2020-06-01 05:00:04 |
| 2020-06-01 | 2020-06-01 05:08:03 |
| 2020-06-01 | 2020-06-01 05:08:03 |
| 2020-06-01 | 2020-06-01 05:27:59 |
| 2020-06-01 | 2020-06-01 05:27:59 |
| 2020-06-01 | 2020-06-01 06:03:59 |
| 2020-06-01 | 2020-06-01 06:03:59 |
| 2020-06-01 | 2020-06-01 06:03:59 |
| 2020-06-01 | 2020-06-01 06:03:59 |
| 2020-06-01 | 2020-06-01 06:08:22 |
| 2020-06-01 | 2020-06-01 06:16:25 |
| 2020-06-01 | 2020-06-01 06:20:08 |
| 2020-06-01 | 2020-06-01 06:31:55 |
| 2020-06-01 | 2020-06-01 06:31:55 |
| 2020-06-01 | 2020-06-01 06:36:03 |
| 2020-06-01 | 2020-06-01 06:36:03 |
| 2020-06-01 | 2020-06-01 06:36:03 |
| 2020-06-01 | 2020-06-01 06:36:03 |
| 2020-06-01 | 2020-06-01 06:36:03 |
| 2020-06-01 | 2020-06-01 06:40:20 |
| 2020-06-01 | 2020-06-01 06:44:02 |
| 2020-06-01 | 2020-06-01 06:48:31 |

did you tried it ?

yea but its wrong

show me the wrong

5 min interval mean

5,10,15,20 ryte

There is no error with the code .. Maybe your syntax error

if i change to 10 min interval im getting same count 244 rows

for 5 min interval also im getting same 244 rows

wondrous , i’m sorry i don’t know bro .

cool,thanks for your help bro