show record in between field in mysql not using sub query

MySQL
i want the field nilai_kredit to top at between filed nilai_kredit, if the acct_no is same, but i don't want to use sub query because is slowly SELEC...
8 months ago

MySQL Ignoring Specific Rows?

MySQL
I am running a SQL query to obtain results with the column applicationstatus that aren't S to tell which position is still open. There are 3 applicati...
8 months ago

How to loop the query in this case?

MySQL
I have been trying to loop this query but all I get is the first value. When I do the same command in workbench I get all the values. What am I doing...
8 months ago

how to insert multiple values with foreach

MySQL
adding checkbox values using foreach. the checkbox name are same.. i tried this <?php // checkbox name is check[] $check = $_POST['check']; for...
8 months ago

How to find gaps in sequential numbering in mysql?

MySQL
We have a database with a table whose values were imported from another system. There is an auto-increment column, and there are no duplicate values, ...
8 months ago

How to count the mysql results of 2 tables that have similar conditions?

MySQL
I want to insert into the goals column of the pivot_data the count of 2 tables in total. I can make it work with 1 table, but I am not able to combin...
8 months ago

Unable to delete entry from table where value contains a space in the middle?

MySQL
I'm able to delete the entries which have a single word like 'Tomato' or 'Potato'. Unable to delete entries with multiple words like 'pumpkin soup'. ...
8 months ago

Mysql insert column and data from one table based on EXISTS

MySQL
Not sure why this won't work, trying to insert column(from table) and data(not from any table) from one table into another IF it isn't already there. ...
8 months ago

Your PHP installation appears to be missing the MySQL extension which is required by WordPress. On Ubuntu 14.04 LTS

MySQL
Your PHP installation appears to be missing the MySQL extension which is required by WordPress I tried to fix this problem by making sure MySQL serve...
8 months ago

Get datetime in a database and show it in 3 separate fields in dreamweaver [ year, month, day ]

MySQL
I am using xampp for my database and dreamweaver for my website. Fields in database : field 1 = id : int, primarykey and auto increment field...
8 months ago

matplotlib mySQL blank plot

MySQL
I made this Python script. The idea is using this Python script so that matplotlib can generate a vertical bar chart for me using data from a MySQL da...
8 months ago

Relation between two tables (MySQL)

MySQL
I have two tables : users that contain the following columns: userID int(11) AUTO_INCREMENT PRIMARY KEY name varchar(50) address varchar(30) phone v...
8 months ago

Convert string with array of json (PHP)

MySQL
I stored array of JSON in mysql as a string [{"id": 1, "mark": 5}, {"id": 2, "mark": 3}, {"id": 3, "mark": 2}] When I try to use it @foreach ($pl...
8 months ago

Sum column values in flipped table with generated column names

MySQL
I have the following MySQL-code: select question, sum(case when value = '1' then 1 else 0 end) '1', sum(case when value = '2' then 1...
8 months ago

MySQL and SQL scripting for dummies

MySQL
I have postponed writing SQL code for university, and now that I want to start learning it, I have no idea how to. In C I'd define headers and begin ...
8 months ago

How come this SQL query works?

MySQL
This is a exercise from wikibooks, #6 The table schema is The question is: For each piece, find the most expensive offering of that piece and i...
8 months ago

Join query is going wrong

MySQL
I have two tables. first is travellers_details and second is user_info. traveller_details table has columns id, travel_mode, dep_from, arr_t...
8 months ago

whats the right version for using either scope_identity() ,@@identity (),last_insert_id() in mysql

MySQL
im working on asp.net c# ,i tried all 3 of them but none worked , this is the sql error(You have an error in your SQL syntax; check the manual that co...
8 months ago

SQL values from two different tables

MySQL
Okay so I have two tables in one database. One is called accounts and one is called settings. Through one query I would like to fetch settings.positio...
8 months ago

search by date mysql

MySQL
I have a table named messages: date (format DATETIME) id text user_id(FK) and a table named users: id name how to get count of messages with ...
8 months ago