select all column of table but row should be filtered by unique or disticnt entry in a column

SQL
CREATE TABLE IF NOT EXISTS `history` ( `bill_no` int(11) NOT NULL, `cid` int(11) NOT NULL, `pid` int(11) NOT NULL, `TIME` timestamp NOT NULL DEFAULT ...
1 year ago

How to remove 'NULL' from results of queries SQL 2008

SQL
I have a table with 59 columns and over 17K rows. Lots of the rows have NULL in some of the columns. I want to remove the NULL so that queries return...
1 year ago

Update fields in MySQL table where fields in several tables are matched

SQL
I have four tables. The first contains a list of volunteers, the second a list of sites, and the third a list of projects. A project row is simply a r...
1 year ago

Node.js mySQL module error

SQL
Playing with mysql module and code examples from Packt’s Node Cookbook. var mysql = require('mysql'); var client = mysql.createClient({ user: 'root',...
1 year ago

how to check login username from more then one field in php like facebook

SQL
This is my login form. I want to check username from company name or by nik_name, and password is mandatory field. As like facebook in which we can lo...
1 year ago

MYSQL UPDATE TABLE ERRORS

SQL
I want do some calculations for the column total by adding the two marks columns for the specific std_id. For example 30+25=55, total=55 for std_id...
1 year ago

Get the user with the 1000th point (SQL query)

SQL
I am trying to just do a query that will illustrate which student from school_id 1 has got the 1000th point - in this case it is 'Sharon' ++++++++++...
1 year ago

Laravel format DateTime from database result

SQL
My database stores two dates in the mysql DateTime format YYYY-MM-DD HH:MM:SS. When I get this data (with other strings etc), I want to convert it to ...
1 year ago

Delphi - combo box search in database using sql queries

SQL
This is the error I get when I run the code below. I'm not too sure what's wrong any help is appreciated procedure TFSearchMember.btnSearchClick(Se...
1 year ago

I need help on selection statement in mySQL

SQL
I am not familiar with the advance queries in mySQL. So please kindly help me. clubs table (has more than these fields) cid | clubname | ----+-----...
1 year ago

SQL How to replace values of select return?

SQL
In my database (MySQL) table, has a column with 1 and 0 for represent true and false respectively. But in SELECT, I need it replace for true or false...
1 year ago

MYSQL ERROR 1054 (42S22) complaint about Unknown column in 'field list' that does not exist

SQL
$ mysql -u admin -pABC123 db < backup.sql ERROR 1054 (42S22) at line 365438: Unknown column 'NTLL' in 'field list' $ grep -E -i -e 'NTLL' backup.sq...
1 year ago

Mysql connector Python Syntax error

SQL
I want to run the create function in a tkinter interface but it give me this error: 1064 (42000): You have an error in your SQL syntax; check the ...
1 year ago

Mysqli Prepared Statement Fails On Second Iteration

SQL
I'm having trouble with my prepared statement not working on the second iteration and I was wondering if I need to free it or something I'm missing? ...
1 year ago

Display a query from a SQL table in a text box

SQL
I've been tinkering with with this for over an hour now and am starting to feel poorly about myself. I would like to capture a value from a SQL table...
1 year ago

SQL Query for Logins

SQL
What is the SQL query to select all of the MSSQL Server's logins? Thanks, more then one of you had the answer I was looking for SELECT * FROM syslog...
1 year ago

Connect and query database in Managed C++ using SqlConnection

SQL
I'm building a project in C++ in Visual Studio 2012 and I've started by writing some classes for database access. Using SQL Server data tools I've man...
1 year ago

Order table by number of matches

SQL
I have following database schema: Applicants table: applicant_id | name --------------|----- 1 | Bill 2 | Tom 3...
1 year ago

select values with same cloumn a but different column b

SQL
I am using phpmyadmin database. I have a table with columns 'admitno' and 'name' . I want to select values with same Admit No but different name and...
1 year ago

Login in c# with SQLite

SQL
I am trying to make a login form using SQLite database, i have created a new table named login, i have added id (pk), username and password fields (bo...
1 year ago