Pesan selamat datang pemuktahiran basisdata

Untuk memuktahirkan pesan selamat datang pada kursus.

Setelah mencari pesan anda perlu memuktahirkan klausa put this as the where. Lalu meletakan pesan yang anda ingin muktahirkan di klausa set.

update mdl_lp_enrol_email 
set body = "***Welcome to
{coursename}
!***
You have been assigned this course as part of your mandatory/personal development training.
Please log in to complete this module as soon as possible. 
If you have any queries please contact a member of the Learning Development team.
{profileurl}"
where body = "Welcome to {coursename}!

If you have not done so already, you should edit your profile page
within the course so that we can learn more about you:

  {profileurl}";