select data from mysql with mysql-connector-python

MySQL
I have a mysql db that I manage via MAMP (using port 3306, server is on port 80). I have downloaded and installed the mysql-connector-python library f...
1 year ago

How to retrieve rows in the required order in mysql

MySQL
I have a table as follows, table1 When i m using the query "SELECT cat_title FROM table1 WHERE cat_id IN(21,10,25,4)" the result is in the orde...
1 year ago

how to retrieve a html brake from mysql

MySQL
first of all I found some topics about this on this forum but just can't seem to get it right on my page... so that's why I'm asking. I am trying to ...
1 year ago

laravel eloquent Array to string conversion

MySQL
I building a helper in laravel to return a single field from eloquent. class Helper { public static function getAddress($id) { //intval(...
1 year ago

Split if field contains delimiter and preserve related row values MySQL query

MySQL
The schema for the table is : CREATE TABLE `authors` ( `authorid` int(10) NOT NULL AUTO_INCREMENT, `emailaddress` varchar(255) DEFAULT NULL, 's...
1 year ago

Mysql Nested Query Speed Is Very Slow

MySQL
I have a table by the name of vehicle_plate as follow: And the above table total records is 715210 and I want to count the vehicles by latest or up...
1 year ago

Hiding Empty or Null Values of Table

MySQL
$sql="(SELECT userID AS ID,userName FROM user) UNION ALL (SELECT pageID AS ID,pageName FROM page) ORDER BY ID ASC"; $res=mysql_query($sql); while($ro...
1 year ago

How to get values from field and set to stringlist?

MySQL
how to get this all value from field username? and can convert this into stringlist or strings or memo? sorry, i can't speak english properly enter i...
1 year ago

Is it safe to disable WordPress and plugins updates without having problems in the future?

MySQL
I've disabled all auto WordPress updates on my website because I like it that way, knowing that I won't make any setting changes later. So my question...
1 year ago

Mow to sort results in MySQL right join?

MySQL
I trying to get monthly data of whole year using MySQL database. I have two tables, loan month loan ` +--------+--------+-------+----------+ | id...
1 year ago

Make 'Related To' section based on same Category in laravel

MySQL
I have a website where i post recipes. each one of them has a category, and i want to display 2-3 more posts with the same category of that post. how ...
1 year ago

MVC 4 Retrieve db id from newly created entry

MySQL
If I create a entry in a database such as this (cvmCasefile has all info needed to create the casefile): Casefile casefile = cvm.Casefile; casefile.C...
1 year ago

How can I search by emoji in MySQL using utf8mb4?

MySQL
Please help me understand how multibyte characters like emoji's are handled in MySQL utf8mb4 fields. See below for a simple test SQL to illustrate th...
1 year ago

Easy way to export a SQL table without access to the server or phpMyADMIN

MySQL
I need a way to easily export and then import data in a MySQL table from a remote server to my home server. I don't have direct access to the server, ...
1 year ago

Doctrine Select from Subquery

MySQL
I am trying to run the following query via doctrine: $sql = "SELECT league_id, sum(num_fans) AS total_fans FROM (" ."SELECT COUNT(*) as num_fans, t.i...
1 year ago

SOLVED: Handling variables from another class when saving from ArrayList to MySQL database

MySQL
I am creating a Rpg game. Now, the game progress is saved to a txt file. I have created a database which will handle the save game instead. Currently ...
1 year ago

PHP is not submitting data to MySQL

MySQL
Ive been having a great deal of trouble the past few hours. I'm attempting to get form input, sent by the user, to be sent to a table in MySQL, the ...
1 year ago

SQL table with "list" entry vs SQL table with a row for each entry

MySQL
I have a Sqlite table where each row is the form of: value, "a,b,c,d,e,f,g,h,i,j", value3, value4 Where my queries look for a pairing of value, %b%...
1 year ago

remove \n inside a string

MySQL
I have a MySQL that stored a string, and its value is Group Sales Manager\nInsurance Service since 1983. Now, I want to change this part of string int...
1 year ago

Retrieving username from MYSQL database

MySQL
ANSWERED QUESTION: So I've made a login and signup feature to my website, but now I would like to add the username's and ranks to the sidebar.. ...
1 year ago