Any MySQL expert is available here?

|
rohit267 2020-10-08 19:35:19
go for DSA and algo + project
Kishor_Parvatikar 2020-10-08 19:36:12
rohit267 2020-10-08 19:35:02
they never ask php

My only project is on PHP 🥺

Kishor_Parvatikar 2020-10-08 19:36:35
Anbhv90 2020-10-08 19:23:54
If you go to mnc company then they will rarely ask silly questions that I have send before

Then what questions should i expect?

Anbhv90 2020-10-08 20:20:15
They can ask core cs subjects like dbms, os, algorithms, soft. Engineering, system analysis and design
Anbhv90 2020-10-08 20:20:44
And general questions
Anbhv90 2020-10-08 20:21:39
Normalization, process management, SDLC
rohit267 2020-10-08 20:30:08
/warn no videos
rohit267 2020-10-08 20:31:25
please use text
Shubh2921 2020-10-08 21:50:43
Any MySQL expert is available here??
Shubh2921 2020-10-08 21:54:07
Please help me??
manjeshy7 2020-10-08 21:56:33
Post your query.
Shubh2921 2020-10-08 21:59:33
Okay
Shubh2921 2020-10-08 22:02:16
CREATE TRIGGER trigger_for_3pm_data
AFTER INSERT ON tbl_tenam_excel_data
FOR EACH ROW
BEGIN
  DECLARE curr_date date;
  DECLARE loc_dist_id int DEFAULT 0;
  DECLARE cumu_total_positive varchar(30) DEFAULT 0;
  DECLARE cumu_total_recovered varchar(30) DEFAULT 0;
  DECLARE cumu_total_deaths varchar(30) DEFAULT 0;
  DECLARE cumu_total_active_cases varchar(30) DEFAULT 0;
  DECLARE cumu_total_sample_tested varchar(30) DEFAULT 0;
  DECLARE new_positive_on varchar(30) DEFAULT 0;
  DECLARE tested_on varchar(30) DEFAULT 0;
  SET loc_dist_id = NEW.district_id;
  SET curr_date = NEW.date;
  SET cumu_total_positive = NEW.cumu_total_positive;
  SET cumu_total_recovered = NEW.cumu_total_recovered;
  SET cumu_total_deaths = NEW.cumu_total_deaths;
  SET cumu_total_active_cases = NEW.cumu_total_active_cases;
  SET cumu_total_sample_tested = NEW.cumu_total_sample_tested;
  SET new_positive_on = NEW.new_positive_on;
  SET tested_on = NEW.tested_on;
loop_label:
  LOOP
      UPDATE tbl_tenam_excel_data
      SET
       cumu_recovery_rate = cumu_total_recovered,
          cumu_furtality_rate = cumu_total_deaths,
          cumu_positivity_rate = cumu_total_positive,
          postivity_rate_on = new_positive_on,
          daily_grouth_rate = tested_on
       WHERE district_id = loc_dist_id AND date = curr_date;
  END LOOP;
DELIMITER ;
Shubh2921 2020-10-08 22:03:59
CREATE TRIGGER trigger_for_3pm_data
AFTER INSERT ON tbl_tenam_excel_data
FOR EACH ROW
BEGIN
DECLARE curr_date date
MySQL said: Documentation

#1064 – You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near ” at line 5

Shubh2921 2020-10-08 22:04:06
Error is that
rohit267 2020-10-08 22:06:13
Shubh2921 2020-10-08 22:02:16
CREATE TRIGGER trigger_for_3pm_data
AFTER INSERT ON tbl_tenam_excel_data
FOR EACH ROW
BEGIN
  DECLARE curr_date date;
  DECLARE loc_dist_id int DEFAULT 0;
  DECLARE cumu_total_positive varchar(30) DEFAULT 0;
  DECLARE cumu_total_recovered varchar(30) DEFAULT 0;
  DECLARE cumu_total_deaths varchar(30) DEFAULT 0;
  DECLARE cumu_total_active_cases varchar(30) DEFAULT 0;
  DECLARE cumu_total_sample_tested varchar(30) DEFAULT 0;
  DECLARE new_positive_on varchar(30) DEFAULT 0;
  DECLARE tested_on varchar(30) DEFAULT 0;
  SET loc_dist_id = NEW.district_id;
  SET curr_date = NEW.date;
  SET cumu_total_positive = NEW.cumu_total_positive;
  SET cumu_total_recovered = NEW.cumu_total_recovered;
  SET cumu_total_deaths = NEW.cumu_total_deaths;
  SET cumu_total_active_cases = NEW.cumu_total_active_cases;
  SET cumu_total_sample_tested = NEW.cumu_total_sample_tested;
  SET new_positive_on = NEW.new_positive_on;
  SET tested_on = NEW.tested_on;
loop_label:
  LOOP
      UPDATE tbl_tenam_excel_data
      SET
       cumu_recovery_rate = cumu_total_recovered,
          cumu_furtality_rate = cumu_total_deaths,
          cumu_positivity_rate = cumu_total_positive,
          postivity_rate_on = new_positive_on,
          daily_grouth_rate = tested_on
       WHERE district_id = loc_dist_id AND date = curr_date;
  END LOOP;
DELIMITER ;

seriously?

Shubh2921 2020-10-08 22:06:28
rohit267 2020-10-08 22:06:13
seriously?

Yes 😔😔

2020-10-09 08:37:44
Hi

How can we integrate payment gateway demo kit with a web portal

rohit267 2020-10-09 08:41:28
2020-10-09 08:37:44
Hi

How can we integrate payment gateway demo kit with a web portal

read their documentation

2020-10-09 08:48:39
Ok
2020-10-09 17:43:55
78 PHP CI /Laravel/Core PHP source code Available in very affordable price.
those who need can do 👇

1.CRM Software
2. Freelance CRM Software
3. Garage Management Software
4. LOAN Management Software
5. Social Store Blog software
6. Single Vendor E-commerce Software
7. OLX Clone web application
8. Freelance Web application
9. Multi-school Management with App
10. Loan Management System 2
11. Online Job Portal
12. Multivendor E-commerce website
13. Binary MLM software
14. Premium School Management software
15. School Software 1
16. Tenant Management Software
17. HRM Software (MID-Level)
18. Dating Software
19. Matrimonial Software
20. Movie Ticketing software
21. News with video and blog website
22. Ultimate School Management software
23. Multiple restaurants and Swiggy clone web and app
24. CRM accounting and Billing Software (Pro Version)
25. Website Builder (Drag and drop) and CMS
26. Ultimate college Management software
27. Pharmacy Management software (PRO-Version)
28. Project Management software (ultimate version)
29. Point of Sale (POS software advance version)
30. CRM (Accounts, HR, Inventory ) Elite version
31. Project Manager and CRM (Advance Pro version)
32. School management Software (Elite Version)
33. Online car rental Management software
34. Training and coaching centre management software
35. Online car booking software with front-end website
36. Online examination Advance PRO version
37. Online Auction Management and Frontend Website
38. Secret confession and Script and frontend website
39. Ultimate Online Examination software and Frontend Website
40. Institute Management Software
41. Blood bank Management Software
42. Online Bus booking and & Reservation system
43. Smart crowdfunding Application and Frontend website
44. Online Tutoring video classes and Frontend Website
45. Church Management software and Frontend website
46. Online Exam Pro version
47. Advance Support Ticket System
48. Fleet Management Software
49. Election campaign Management software
50. Pro School Management System
51. Mass Email Sender
52. Bizz Library management
53. laundry Management Software
54. Tailor and Fashion Designer Software
55. Tour and Travel System
56. Saloon Management Software
57. Website cloner Software
58. Advocate Management Software
59. Apartment Management Software
60. AMC Management Software
61. The online food order system
62. POS – Restaurant Management system
63. Courier and Logistics Management Software
64. CAR Workshop Software
65. Sales CRM software
66. Hotel Management System
67. Pharmacy Management System
68. Invoice Software
69. Human Resource Management Software
70. College Management Software
71. Gym Management and Fitness Management
72. Hospital Management Software
73. Real State management
74. Stock Management System
75. Accounting software (GST Enabled)
76. Ultimate Inventory software
77. CRM and Sales software Advance Pro version
78. Learning Management Software

2020-10-09 17:45:08
https://wa.me/917991146771

Share on WhatsAppWhatsApp.com
WhatsApp Messenger: More than 2 billion people in over 180 countries use WhatsApp to stay in touch with friends and family, anytime and anywhere. WhatsApp is free and offers simple, secure, reliable messaging and calling, available on phones all over the world.
S 2020-10-09 19:51:37
2020-10-09 17:43:55
78 PHP CI /Laravel/Core PHP source code Available in very affordable price.
those who need can do 👇

1.CRM Software
2. Freelance CRM Software
3. Garage Management Software
4. LOAN Management Software
5. Social Store Blog software
6. Single Vendor E-commerce Software
7. OLX Clone web application
8. Freelance Web application
9. Multi-school Management with App
10. Loan Management System 2
11. Online Job Portal
12. Multivendor E-commerce website
13. Binary MLM software
14. Premium School Management software
15. School Software 1
16. Tenant Management Software
17. HRM Software (MID-Level)
18. Dating Software
19. Matrimonial Software
20. Movie Ticketing software
21. News with video and blog website
22. Ultimate School Management software
23. Multiple restaurants and Swiggy clone web and app
24. CRM accounting and Billing Software (Pro Version)
25. Website Builder (Drag and drop) and CMS
26. Ultimate college Management software
27. Pharmacy Management software (PRO-Version)
28. Project Management software (ultimate version)
29. Point of Sale (POS software advance version)
30. CRM (Accounts, HR, Inventory ) Elite version
31. Project Manager and CRM (Advance Pro version)
32. School management Software (Elite Version)
33. Online car rental Management software
34. Training and coaching centre management software
35. Online car booking software with front-end website
36. Online examination Advance PRO version
37. Online Auction Management and Frontend Website
38. Secret confession and Script and frontend website
39. Ultimate Online Examination software and Frontend Website
40. Institute Management Software
41. Blood bank Management Software
42. Online Bus booking and & Reservation system
43. Smart crowdfunding Application and Frontend website
44. Online Tutoring video classes and Frontend Website
45. Church Management software and Frontend website
46. Online Exam Pro version
47. Advance Support Ticket System
48. Fleet Management Software
49. Election campaign Management software
50. Pro School Management System
51. Mass Email Sender
52. Bizz Library management
53. laundry Management Software
54. Tailor and Fashion Designer Software
55. Tour and Travel System
56. Saloon Management Software
57. Website cloner Software
58. Advocate Management Software
59. Apartment Management Software
60. AMC Management Software
61. The online food order system
62. POS – Restaurant Management system
63. Courier and Logistics Management Software
64. CAR Workshop Software
65. Sales CRM software
66. Hotel Management System
67. Pharmacy Management System
68. Invoice Software
69. Human Resource Management Software
70. College Management Software
71. Gym Management and Fitness Management
72. Hospital Management Software
73. Real State management
74. Stock Management System
75. Accounting software (GST Enabled)
76. Ultimate Inventory software
77. CRM and Sales software Advance Pro version
78. Learning Management Software

What is the cost

S 2020-10-09 19:54:23
Guys I want to do change of job
2020-10-09 19:54:37
S 2020-10-09 19:51:37
What is the cost

https://wa.me/917991146771
Please do msg

Share on WhatsAppWhatsApp.com
WhatsApp Messenger: More than 2 billion people in over 180 countries use WhatsApp to stay in touch with friends and family, anytime and anywhere. WhatsApp is free and offers simple, secure, reliable messaging and calling, available on phones all over the world.
S 2020-10-09 19:55:04
If any job related channel is there please do share
2020-10-09 20:48:36
S 2020-10-09 19:55:04
If any job related channel is there please do share

Please do update on naukri.com. soon you will get solution

httpstmelLbHW8yY6Ns4NDg1 2020-10-09 20:49:24
Need wamp ….can anybody help me out
Arjun_mehta 2020-10-09 21:11:00
Who can make auth code finder php of 1 app.. please msg me 🙏🙏
Shubh2921 2020-10-09 21:11:49
Shubham Raj:
Hey everyone, I have one issue in codeigniter I want to convert excel file to pdf using phpexcel in codeigniter, please help me
kasimmk 2020-10-10 02:27:19
luv_php-24650.jpg

kasimmk 2020-10-10 02:28:30
kasimmk 2020-10-10 02:27:19

How can I call id instead of value? To update data by submit button.

kasimmk 2020-10-10 02:28:35
luv_php-24652.jpg

rohit267 2020-10-10 06:06:53
kasimmk 2020-10-10 02:28:30
How can I call id instead of value? To update data by submit button.

.attr()

Kiransdj 2020-10-10 09:06:44
2020-10-09 17:43:55
78 PHP CI /Laravel/Core PHP source code Available in very affordable price.
those who need can do 👇

1.CRM Software
2. Freelance CRM Software
3. Garage Management Software
4. LOAN Management Software
5. Social Store Blog software
6. Single Vendor E-commerce Software
7. OLX Clone web application
8. Freelance Web application
9. Multi-school Management with App
10. Loan Management System 2
11. Online Job Portal
12. Multivendor E-commerce website
13. Binary MLM software
14. Premium School Management software
15. School Software 1
16. Tenant Management Software
17. HRM Software (MID-Level)
18. Dating Software
19. Matrimonial Software
20. Movie Ticketing software
21. News with video and blog website
22. Ultimate School Management software
23. Multiple restaurants and Swiggy clone web and app
24. CRM accounting and Billing Software (Pro Version)
25. Website Builder (Drag and drop) and CMS
26. Ultimate college Management software
27. Pharmacy Management software (PRO-Version)
28. Project Management software (ultimate version)
29. Point of Sale (POS software advance version)
30. CRM (Accounts, HR, Inventory ) Elite version
31. Project Manager and CRM (Advance Pro version)
32. School management Software (Elite Version)
33. Online car rental Management software
34. Training and coaching centre management software
35. Online car booking software with front-end website
36. Online examination Advance PRO version
37. Online Auction Management and Frontend Website
38. Secret confession and Script and frontend website
39. Ultimate Online Examination software and Frontend Website
40. Institute Management Software
41. Blood bank Management Software
42. Online Bus booking and & Reservation system
43. Smart crowdfunding Application and Frontend website
44. Online Tutoring video classes and Frontend Website
45. Church Management software and Frontend website
46. Online Exam Pro version
47. Advance Support Ticket System
48. Fleet Management Software
49. Election campaign Management software
50. Pro School Management System
51. Mass Email Sender
52. Bizz Library management
53. laundry Management Software
54. Tailor and Fashion Designer Software
55. Tour and Travel System
56. Saloon Management Software
57. Website cloner Software
58. Advocate Management Software
59. Apartment Management Software
60. AMC Management Software
61. The online food order system
62. POS – Restaurant Management system
63. Courier and Logistics Management Software
64. CAR Workshop Software
65. Sales CRM software
66. Hotel Management System
67. Pharmacy Management System
68. Invoice Software
69. Human Resource Management Software
70. College Management Software
71. Gym Management and Fitness Management
72. Hospital Management Software
73. Real State management
74. Stock Management System
75. Accounting software (GST Enabled)
76. Ultimate Inventory software
77. CRM and Sales software Advance Pro version
78. Learning Management Software

Cost individual and total bundle price

Kiransdj 2020-10-10 09:07:15
Support provided after purchase
2020-10-10 09:34:14
Kiransdj 2020-10-10 09:06:44
Cost individual and total bundle price

Please do ping here https://wa.me/917991146771

Share on WhatsAppWhatsApp.com
WhatsApp Messenger: More than 2 billion people in over 180 countries use WhatsApp to stay in touch with friends and family, anytime and anywhere. WhatsApp is free and offers simple, secure, reliable messaging and calling, available on phones all over the world.
2020-10-10 09:41:02
Hi , any one having good experience in PHP
sandeepnkr 2020-10-10 13:09:41
send me Music Upload code in php mysql
Khanna885 2020-10-10 13:33:08
Hello Developers,
One of my client is looking for PHP developer with 4+yrs exp in Trivandrum location any one interested kindly let me know
rohit267 2020-10-10 14:34:10
2020-10-10 09:41:02
Hi , any one having good experience in PHP

ask your issue

rohit267 2020-10-10 14:34:47
sandeepnkr 2020-10-10 13:09:41
send me Music Upload code in php mysql

tutorialspoint has one, image upload code, use that

2020-10-10 14:35:57
Looking for PHP developer to develop an educational website for my client.
rohit267 2020-10-10 14:36:58
2020-10-10 14:35:57
Looking for PHP developer to develop an educational website for my client.

please explain the basic requirement, anyone interested will ping you

Devendra Vishwakarma 2020-10-10 14:43:55
Hello friends I want to learn laravel framework

How can I learn it fast?

rohit267 2020-10-10 14:51:37
Devendra Vishwakarma 2020-10-10 14:43:55
Hello friends I want to learn laravel framework

How can I learn it fast?

give more time per day

Devendra Vishwakarma 2020-10-10 14:52:20
Okay but I also want to know where I can start
rohit267 2020-10-10 14:52:57
Devendra Vishwakarma 2020-10-10 14:52:20
Okay but I also want to know where I can start

there are plenty of youtube channels and udemy courses

poovarasu1 2020-10-10 15:25:26
Devendra Vishwakarma 2020-10-10 14:43:55
Hello friends I want to learn laravel framework

How can I learn it fast?

Hope you can check Laracast also

2020-10-10 15:32:18
rohit267 2020-10-10 14:36:58
please explain the basic requirement, anyone interested will ping you

Hi Rohit , please tell me. I have 4+ yrs of experience in web application development in Php. I can fullfill all your customized requirements. Please do message in personal.

|