Question : I am attempting to lock some tables while running some code and unlocking the tables when I am […]
Tag: mysqli
mysqli importer file – disable foreign keys
Question : I am using this script to import a mysql file but I want to set foreign key checks […]
MySQLI stored procedure return PK/AI insertID
Question : I am using a PHP framework called CodeIgniter for my application. This is using the MySQLI driver for […]
Get related columns depending on a ID
Question : I have a table with a m:n (many to many) relationship. Basically, if I select an article_id, I […]
Different types of users in one table, How to add data off different users
Question : I have 5 type of users: Super Admin Coordinator Supervisor Student External Examiner All of them have some […]
Get table name from union query?
Question : This is my query SELECT Id, productName, Largeimagepath, Discount, Price, Image FROM tablename1 where Active =1 union SELECT […]
UPDATE SET N + 1 equal to a row (with iteration)
Question : Question: How would you iterate over the previous result (referenced below) over for each of the values in […]
Cannot change root access in MySQL to %
Question : This is a new MySQL Server install. I created my root password as part of the setup (on […]
How to find the most common phrases in a MySQL database
Question : I have a table which contains articles on movies. Each article has a title and many of them […]
Calculate total attendance for each workshop
Question : I want to get overall attendance in each workshop. NumberOFWeeks column holds the number of weeks the workshop […]
- 1
- 2