sql select all record for all

MySQL
so there is 3 tables 1 passanger detail 2 booking 3 flight passanger +----+------+ | id | name | +----+------+ | 1 | A | | 2 | B | | 3 ...
1 year ago

libgdx city building game tutorial

MySQL
i am a beginner in libgdx. i wonder how to develop a city building game. Is there some good guy show me how to make a city building game? i need my ap...
1 year ago

how can I sum a column while joining three tables at once

MySQL
I believe there is a good way to do. I searched and tried but could not find. I want to join three tables like this (or a better way, please suggest) ...
1 year ago

How can I convert MySQL database to SQLite in PHP?

MySQL
I need PHP code to convert the database. I tried How to convert mysql to SQLite using PHP but it dint have answer ...
1 year ago

BigQuery combine tables based on closest timerstamp and matching value

MySQL
I have two tables and for each row of table numberTwo I need to get the hint in table numberOne that has the same cod value and between those, the one...
1 year ago

SELECT with INNER JOIN, GROUP BY by and WHERE

MySQL
I have a 3 MySQL tables about movies. First one is movie, second is actor and last one is movie_actor_mapping. CREATE TABLE `movie` ( `movie_id` in...
1 year ago

Select one row where alert type and item id are the same and also how many similar rows

MySQL
I am trying to make the notification system for my project as simple as possible on the user's side. "john brown and 4 others liked your photo" I tr...
1 year ago

How to remove users from Table1 which has more than 90 days from register date specified in Table2?

MySQL
I need LEFT JOIN ON Table1.userid=Table2.id and delete users from Table1 which has more than 90 days since register date in Table2.registerDate (datet...
1 year ago

symfony2 execute CREATE table query into controller

MySQL
In my symfony2 application there is a need to create a table on the basis of user selection. if user selects yes then a new table will be create into...
1 year ago

How to split a query value into several mutiple rows for a select tag using explode()

MySQL
I have in the column size values for each query like 38 40 42 44 and I want then to select the size and split to give the use the option to select aft...
1 year ago

Mysql group by and prefered field = 1 in join table

MySQL
I have workshops that have manufacturers, one workshop can have many manufacturers, but only one official. I want to get all workshops that have manuf...
1 year ago

How to query a data from a column containing range in SQLquery

MySQL
first of all. I dont know what should be the title of my question. I have a table called the scholars_ table, and one of its column has a name of val...
1 year ago

select rows after each row with if condition

MySQL
First sorry for poor english ! two i have a table with many record >5000 with below structure id | uid | uam(user after me) | plan -----------------...
1 year ago

pcntl_fork and the MySQL connection is gone

MySQL
I have a foreach loop that forks within it. After the process forks, it accesses the database. I get an error: SQLSTATE[HY000]: General error: 2006 M...
1 year ago

cant login with Auth::attempt

MySQL
RegisterController : public function register(Request $request) { $user=$request->file('cover'); $destination ='img/user'; $filename=...
1 year ago

Multiple MySQL updates from a string using PHP

MySQL
I need some help putting together this PHP SQL update. I am pretty sure I need a foreach loop to post this query, but I am not sure how to write it. ...
1 year ago

MySQL Duplicate entry, but a wrong string

MySQL
I'm trying to duplicate some rows with a new number for editie_id And I'm getting the following, weird duplicate entry error 1062 - Duplicate entr...
1 year ago

SQL select where ALL records of id = 'x' have status of 'y'

MySQL
I have a single table incoming which contains a list of emails , and their attachments. I import each of the attachements, and process them, at which...
1 year ago

MySQL error : sql_mode=only_full_group_by

MySQL
i have this script where i'm used to do a simple projection for a dynamic result SELECT M.nom_utilisateur, SUM(M.montant_bulletin ) as ...
1 year ago

Creating a temp table in mysql for querying when the main table is getting updated

MySQL
i created a huge table in mysql, say table1 i will be querying on this table for my results, continuously once a week i will be flushing the ...
1 year ago