I want to add like condition with % wildcard on the one side, like: where name like 'value%' My code: Table::find()->filterWhere(['like', 'name' , $_GET[
I want to return HTML from PHP. I found a solution from StackOverflow which is insert JSON_HEX_QUOT | JSON_HEX_TAG after array in json_encode but it does not wo
I have read the MySQL mannual about intention lock： http://dev.mysql.com/doc/refman/5.5/en/innodb-locking.html#innodb-intention-locks It says that "To m
I couldnt start mysql on my ubuntu server and got the error message ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysq
I tried a lot to install MySQL8 via Homebrew on Mac 10.14.5. I was running MySQL 5.7 before that and did the following: I removed MySQL completely via this tuto
Students and Grades. Students contains three columns ID, Name and Marks, Grades-(grade,min_mark,max_mark) Ketty gives Eve a task to generate a report containin
I have a table with fields latitude and longitude stored as float values, and I want to start saving them into points in a new column to use spatial features. C
We have a date of birth field(type date) and user_id in the table and we want to get count of users group by age based on the date of birth field For e.g. afte
I'm having phone number 1212010089 and want to know from which country I'm getting this number.I do have a table_1 which is having column1 area_codewhere lots o
Does calling the Laravel increment() on an Eloquent model lock the row? For example: $userPoints = UsersPoints::where('user_id','=',\Auth::id())->first();
We have a date of birth field(type date) and user_id in the table and we want to get count of users group by age based on the date of birth field For e.g. afte
I am currently pulling data from a database with blobs. I retrieve the blob from the database, but I need to parse the text. the ZipFile class takes in files no
I was using the query below to find the next AUTO_INCREMENT value of table in MYSQL 5.7 SELECT AUTO_INCREMENT FROM INFORMATION_SCHEMA.TABLES WHERE TABLE_NAME
I have a Google Cloud SQL MySQL 2nd Gen 5.7 instance with 70GB of unused storage. I want to reduce the unused storage of my instance as this is one of the major
I did an upgrade of my XAMPP from 7.1.24 to 7.4.2. First I uninstall my XAMPP using uninstall.app, then I install my new XAMPP, then i check my phpmyadmin every
I am using mysql8.0.27, here is my table: CREATE TABLE `test` ( `id` int NOT NULL, `number` int DEFAULT NULL, PRIMARY KEY (`id`), UNIQUE KEY `idx_number
I am using Sequelize to map objects to my already existing database, in this database they didnt use the auto-generated timestamps, they did their own datetime
I am using felixge/node-mysql. Also I am using express-myconnection which prevents mysql timeout and in turn prevents killing of node server. What I am doing is
I have 2 tables named tblDemo and tblSubDemo; tblDemo havve 2 columns _id and _name. tblSubDemo have 3columns, ID,Name, Demo_ID(it is the primary key of tblDemo
I am working in a project in which I have a Display.jsp page which fetches all the records from mysql database and shows in a table on the page. While I want to