-
All Sites mysql sql sql-server sql-server-2005 sql-server-2008 sql-server-2008-r2 sqlite sqlite2 sqlite3 postgresql postgresql-8.4
MySQL: null becomes 0 in INSERT and SELECT statement
I am trying to do an INSERT statement using SELECT query statement into a table with two columns (item_id that is not null and price that can be null). The item_id is not auto-increment and I would do …
stackoverflow.com FreeRadius Disconnect User
I have been successful in sending Packet of Disconnect to NAS using CoA port 3799 (from the terminal using radclient), but this only works if I can reach the port from the outside network (i.e if I …
Need help on a getting the count with grouping
I have a SQL table with the following columns Table 1 Site Det FailFlag Comments ModifiedDate ModifiedBy ABT A01 F Dfasdf 10/11/2011 Anna ABT A01 F dsfsdf …
Which is Better more rows or more col in Student Attendance Table in mysql?
I want to create an attendance table for student Attendance which structure should I go for? I have two options. 1) Att(Stud_id,date,is_absent,reason) 2) ...
dba.stackexchange.com PHP Next and Previous links and ID displayed in the URL for sharing
I have a database with a few images already set, I would like to have the url display an ID from each query as the user hits next. The user should be able to share the URL and paste it into their ...
MySQL LIKE query and relevance result
I have a mysql table which has 5 fields. Three main fields are => Content 1 => Content 2 => Content 3 Content 1 and 2 are html and plain text contents respectively, content 3 has comma separated …
Why fetching data from sqlite block Node.JS?
I want to fetch and export to csv file huge amount (5 - 12 milions rows) of archive data from Sqlite database. While doing this the whole server is blocked. No other connection can be handled by ...
MySQL Left Join - how to get count of records found in 2nd table
Table1 id Name 1 John 2 Sheldon 3 Sarah ======== Table2 rid id id2 relation 1 1 2 1 2 1 3 1 How can i get all members from table 1 in one query and …
Deploying database changes in high availability environment
We are currently looking at our deploy process, which consists of an application tier and data tier for a web solution. We'd like to develop a deployment strategy that does not require downtime for …
How to autoincrement a varchar
Can I make a primary key like 'c0001, c0002' and for supplier 's0001, s0002' in one table?
How can I convert string to datetime in SQL Server 2008
How can I convert the following: 031413 05:53 AM into DATETIME format? Where this code: SELECT CONVERT(DATETIME, '031413 05:53 AM') gives me an error.
how to work with form based authentication in SharePoint 2010 three tier architecture?
I am working on SharePoint2010 site created on three tier architecture. I want to use the form based authentication method. I have prepared the form based authentication on web application but ...
sharepoint.stackexchange.com Select specific columns with average of specific row values using joins in CodeIgniter
I have two tables table1 and table2, in table1 I am saving the user details and in table2 the ratings he has given which are multiple rows with same table1.id and ratings in rating column, but when I …
i'm unable to insert the date in My SQL database
/* * To change this template, choose Tools | Templates * and open the template in the editor. */ package itm; import java.sql.*; /** * * @author SUSHIL */ public class student extends ...
Getting Extra Duplicate values
My requirement is this: I have to find out the duplicates from the table PSPROJECTITEM, for the PROJECTNAME which is passed in the query. The objective is to find out the duplicate projects, which …
How to find top three highest salary in emp table in oracle?
How to find top three highest salary in emp table in oracle?
Cann't pouplate sqlite3 database table in my rails app using rake db:seed
I have populated some data in my seeds.rb file that I used to seed a database table in my rails app. But today when I opened the rails app I did not see any data in my table. Subsequently I tried to …
SQLite command in an iOS app
I am using SQLite in an iPad app. I have a csv file that I have to write in the database table. Now I am using a for sentence and writing in the database with a insert sentence. The problem is that …
mysql aggregate function promblem( how to add up values before and after a specific value within the same group)
I am working on some data which I got from work and I am trying to come up a query that make my life a far more easier (I took the time to import those data on mysql.) I have bunch of samples that …
Compare range of time and compute for time difference
I wanted to determine whether the given datetime values falls within the range of time and then insert in the database the time difference between $actual_dateOut and $range_dateOut. example of data: …
Mysql server installed but not running
I tried to install mysql 5.6.12 using the following procedure # Preconfiguration setup shell> groupadd mysql shell> useradd -r -g mysql mysql # Beginning of source-build specific instructions …
askubuntu.com SQL Server 2008 + TVP merge
I am using Table Value Parameter to merge my records, but on top of that I will also need to delete records from my DB that do not exist in my TVP table. Can anyone please kindly assist. Thanks. An …
Running multiple queries in Amazon RedShift
I am having problem in running multiple queries on Amazon RedShift. RedShift is using PostgreSql ver. 8.0.2. It is written in their document that for executing multiple statements, use 'BEGIN' ...
Sample application with multitenant database
I am trying to build a sample multi-tenant application targeting 100 tenants , Can i please know are their any good multi-tenant sample database which includes design, schema and sample data
MySql query to delete duplicate rows by keeping latest timestamp value?
I am facing a problem regarding the mysql table update. I have table that contains 5 columns including ID, NAME, TIMESTAMP and other 2 columns. My problem is I want to delete those rows whose both ID …
Massaging a Fixed Width source file with C#
Problem Current Data ........Column 1....Column 2.......Column3....Column 4 Row1...........0...........0.............0...........Y Row2.......3142.56...........500............0...........N ...
How to convert data base records into csv file in android?
Hi I want to export my data from the data base in CSV format for my android application. How can i do this? Any body help me? Thanks in advance.
How to share DB link with another schema?
I have access to two schema. Only one of them has previleges to create a DB link. I want the other schema also to use this DB link. Also I do not have intentions of creating a public DB link. Is this …
implement indexing in mysql tables for speed up query execution time
I have wordpress query to fetch posts related to TAG, but when i try to execute this query it stuck and mysql server not work properly , i think there is indexing problem. SELECT wp_posts.* FROM …
Clicking on search button to search through sqlite database according to user input and display results in listview.
What code must I add to make the search button function? Clicking on search button to search through SQLite database according to user input and display results in ListView. PostLogin.java (search) …
Email Updates
Log in to receive emails of new questions in this filter. You can receive emails every 15 minutes, every 3 hours, or daily.These users asked the most up-voted questions on this page
