database

This query work when I try it in SQLite: Transaction.where(:paid => true).select("created_at, SUM(amount)…

I have a MySql table which consists of: ~25million rows (CURRENTLY) 3 indexes Each day, a crawler adds ~3million rows I'm currently not looking too…

i am looking for a select statement that when given a specific set of co-ords(lng1+lat1) it will return all the rows within a 1km radius of…

I have a plans table: tariff | monthly_cost -------------------------- Lion , 15.00 Lion , 20.00 Cat , 15.00 Cat , 20.00 Cat Extra , 20.00 Cat Extra…

In database.php I have: $db['default']['username'] = IS_PRODUCTION ? 'prodUsername' : 'localDevBoxUsername'; $db['default']['password'] =…

Although there are many question regarding like link but i could not get this working . I have a query that select and update table…

I have a website with several directories and html files on my desktop and i want to insert the data into the mysql database of a wordpress theme;…

I'm a little confused and could do with some guidance. I want two fields to store an excerpt with a max size of 500 characters, and another to store…

I am building a service which provides a newsletter system for the users. My question is, how to organize it on the database? user opens account…

I have created a function to display the dates and the count of posts within those dates to be used as my blog menu, however it only partially…

if i have this table: users ----- id_users (pk) age name gender salary it is needed for each of these values an option to set visible or not in user…

My database has table name transactions which has 20000 records. When i run this query SELECT T1.* FROM transactions AS T1 WHERE T1.ppno IN (SELECT…

I have a situation where I would like to use a php file "query.php" to look take either a $_POST or $_GET value as the MySQL query. It looks like…

I want to make a list contains some username from my sqlite database. I want it has white background and black text. I felt difficult when find…

So I'm trying to populate a spinner from a database and I am constantly getting a NullPointerException error. I tried this code once before and it…

I want to fetch the records with the field named ppno by occurances. ie., (GIVE ME RECORDS HAVING the PPNO as TNi89873 with 5 time occurences) like…

I have an iPhone app out that stores data on the device. I want to create an app with user accounts like Instagram, Path, Foursquare, Gowalla, etc.…

I need to create thousands of database such like below: CREATE DATABASE adr0711 CHARACTER SET utf8 COLLATE utf8_bin; CREATE DATABASE adr0712…

I've been trying out coding of android apps and i'm looking at finding out how to code some databases by using existing codes on tutorials and…

I'm new in MySQL Workbench. I'm planning to create a new database called "Customers". But the problem is I don't know how to create it. I already…