I have a column of type "varchar" but it consists of integer. When I make a query with orderBy, it results like below. 10 11 12 9 I have implemented orderBy like below: ->orderBy("stdmap.prvid"); When I run query directly in…
I'm a newbie in Raspberry Pi and MySQL. I've created a code, database in phpmyadmin which ran by wamp server in my PC. Meanwhile, I want to run this code in Raspberry Pi 3. Besides that, when I run the…
I have Table student, student_subject and subject_bsit "student" ----------------------- |studentID | FullName | ----------------------- |1234 | John | |1235 | Michael | |1236 | Bryce | "subject_bsit" ----------------------------------- |subject_id| subject_name |grade | ----------------------------------- | 1 | Programming | 3 |…
lets say I have the link http://localhost:8080/Simple/index.php?ref=user5 after I click it, I want "user5" to show up inside Input. Thank you in advance
Iam new on using Code Igniter. I want to use a custom insert query, reason is i want to use uuid() on my query and Im not sure what part of my code is wrong. I echoed the query, it…
I'm trying to create a stored procedure in phpmyadmin but when I try to create a second one, I get the error #1327 - Undeclared variable. This works fine: BEGIN DECLARE id_pro INT(9); SELECT user_product_id INTO id_pro FROM usuario; END…
I need a trigger in phpmyadmin for 2 tables. I have two tables called users and group_has_users. Table group_has_users has 2 values called group_id and user_id. I'm trying to make a trigger that automatically inserts new data to group_has_users table…
I've just added the MailChimp extension in Magento 2.2.5. But there is a configuration error occurring. When I click on the configuration of MailChimp it doesn't show anything and store configuration throwing an error message "Class Mailchimp does not exist"…
I have a table like this: id id2 1 435 2 345 3 345 4 567 5 456 6 987 7 987 Here in id2 345 and 987 are repeating twice, so I want to delete both the rows. My…
table arts column title - example: 1122 A TITLE 025 - ANOTHER TITLE 1/7 - SOME TITLE 1 4 5 - SOME ANOTHER TITLE I need to remove everything before the real title. Characters for removing are - everything except…