Is your database mssql or mysql?

|
MasterZiv 2020-12-28 22:38:42
Sqq1789 2020-12-28 22:34:03
Could anyone help me w neeps exercise on sqlzoo

Ask questions, here

2020-12-29 10:17:04
Setting up MySQL InnoDB Cluster with MySQL Shell (plus MySQL Router) using just Docker containers.

MySQL InnoDB Cluster with MySQL Shell | MySQL Router using Docker Containers | MySQL DBA Tutorial

MySQL InnoDB Cluster with MySQL Shell | MySQL Router using Docker Containers | MySQL DBA TutorialYouTube
Setting up MySQL InnoDB Cluster with MySQL Shell (plus MySQL Router) using just Docker containershttps://ittutorial.org/mysql-innodb-cluster-with-mysql-shell…
yyusuff10 2020-12-29 13:58:19
Im from Turkey
yyusuff10 2020-12-29 13:58:51
I have a database homework. CAN YOU HELP ME ?
yyusuff10 2020-12-29 13:59:24
Im a university student
MasterZiv 2020-12-29 14:29:32
Hi

Im from Turkey

I have a database homework. CAN YOU HELP ME ?

Im a university student

smlkw 2020-12-29 14:31:22
yyusuff10 2020-12-29 13:58:51
I have a database homework. CAN YOU HELP ME ?

Please, provide more information about your task

yyusuff10 2020-12-29 14:33:47
Did you understand ?
yyusuff10 2020-12-29 14:33:48
mysql_en-7253.jpg

smlkw 2020-12-29 14:58:53
is your database mssql or mysql?
yyusuff10 2020-12-29 14:59:15
Mysql
smlkw 2020-12-29 15:03:55
you need to implement the logic of substring function in your function fn_kes
yyusuff10 2020-12-29 15:07:09
can you help me with this homework … I just started learning this lesson.
ColonelMustang 2020-12-29 15:07:21
yyusuff10 2020-12-29 15:07:09
can you help me with this homework … I just started learning this lesson.

no

ColonelMustang 2020-12-29 15:07:39
I think the substring function can be implemented regardless of the technology
ColonelMustang 2020-12-29 15:07:53
So you can try doing it yourself
smlkw 2020-12-29 15:14:17
yyusuff10 2020-12-29 15:07:09
can you help me with this homework … I just started learning this lesson.

We don’t do homeworks here. You must learnt this before on lessons.

Sqq1789 2020-12-29 19:20:10
mysql_en-7262.jpg

Sqq1789 2020-12-29 19:20:13
This is the question
Sqq1789 2020-12-29 19:20:41
https://sqlzoo.net/wiki/Neeps
Sqq1789 2020-12-29 19:20:44
schema
Makgato 2020-12-30 09:48:38
Hey i am new in mySQL language

Please i need help with syntax of database and Table i don’t understand anything in this language guys please help me

ColonelMustang 2020-12-30 09:49:32
Makgato 2020-12-30 09:48:38
Hey i am new in mySQL language

Please i need help with syntax of database and Table i don’t understand anything in this language guys please help me

https://www.w3schools.com/sql/

SQL TutorialW3Schools
W3Schools offers free online tutorials, references and exercises in all the major languages of the web. Covering popular subjects like HTML, CSS, JavaScript, Python, SQL, Java, and many, many more.
Makgato 2020-12-30 09:51:27
ColonelMustang 2020-12-30 09:49:32
https://www.w3schools.com/sql/

Thank u so much 🙏🙏

MasterZiv 2020-12-30 11:38:28
Makgato 2020-12-30 09:48:38
Hey i am new in mySQL language

Please i need help with syntax of database and Table i don’t understand anything in this language guys please help me

read dev.mysql.com — all is explained !

( https://dev.mysql.com/doc/refman/8.0/en/ )

2021-01-01 11:25:52
2 – MySQL InnoDB Cluster On Production with MySQL Shell | MySQL Router https://www.youtube.com/watch?v=ykZg7zOsM3Q&ab_channel=MugheesAhmed

2 – MySQL InnoDB Cluster On Production with MySQL Shell | MySQL Router | MySQL DBA Tutorial | MySQLYouTube
Script used in the tutorial is here https://ittutorial.org/32599-2/MySQL InnoDB ClusterMySQL RouterMySQL ShellGroup Replication Please Follow me on Social Me…
2021-01-03 07:15:57
umm anyone here ?
piterden 2021-01-03 07:16:59
2021-01-03 07:15:57
umm anyone here ?

What do you want?

2021-01-03 07:20:26
i’ve two tables
table 01 : member(id, MemberID,isbn)
table 02: Lend(id, MemberID,isbn)

i created a trigger to insert isbn into member table when inserting isbn into Lend table. but trigger is not working

CREATE TRIGGER inserts AFTER INSERT ON
member FOR EACH ROW
INSERT INTO member
VALUES(NULL, NEW.MemberID, NEW.ISBN);

ColonelMustang 2021-01-03 07:24:42
2021-01-03 07:20:26
i’ve two tables
table 01 : member(id, MemberID,isbn)
table 02: Lend(id, MemberID,isbn)

i created a trigger to insert isbn into member table when inserting isbn into Lend table. but trigger is not working

CREATE TRIGGER inserts AFTER INSERT ON
member FOR EACH ROW
INSERT INTO member
VALUES(NULL, NEW.MemberID, NEW.ISBN);

Replace member to lend

ColonelMustang 2021-01-03 07:25:04
You are creating trigger on member, instead of lend
2021-01-03 07:31:47
ColonelMustang 2021-01-03 07:25:04
You are creating trigger on member, instead of lend

still not working 🙁

2021-01-03 07:32:04
syntx error near ….
piterden 2021-01-03 07:40:23
Show create table for both tables
piterden 2021-01-03 07:40:42
Also show last query you tried
|