Search Results

Search found 5233 results on 210 pages for 'records'.

Page 111/210 | < Previous Page | 107 108 109 110 111 112 113 114 115 116 117 118  | Next Page >

• MySQL: group by and IF statement

  - by notset

  By default, parent_id = 0. I want to select all records with parent_id = 0 and only the last ones with parent_id 0. I tried this, but it didn't work: SELECT * FROM `articles` IF `parent_id` > 0 THEN GROUP BY `parent_id` HAVING COUNT(`parent_id`) >= 1 END; ORDER BY `time` DESC What could be the solution?

  Read the article

• How to write such a stored function in MySQL?

  - by user198729

  The function essentially contains 2 statements: statement1; and statement2; If statement1 fetches some records,just return them as result;If it doesn't fetch any result,return the result of statement2.

  Read the article

• What would be better, (1 database + 4 tables) or (2 databases + 2 tables each) ?

  - by griseldas

  Hi there, I would like to be advised on what would be better (in regards to performance) A) 1 DATABASE with 4 tables or B) 2 DATABASES (same server), each with 2 tables. The tables size and usage are more or less similar, so the 2 tables on Database 1 would be similar usage/size to the 2 tables on database 2 The tables could have +500,000 records and the 2 tables on each database are not related (no join queries etc between them) Thanks in advance for your comments

  Read the article

• Query on Vertical partitioning in Sybase

  - by Sairam

  hi, Am working with sybase.In that i have a table A of some 2 million records containing some columns which i want to move out and make it as a separate table B. I have some questions in this process... 1. I have decided to use vertical partitioning.Is that ok? 2.Or what other technique can i go about using in this process? Please provide your valuable inputs in this. Thanks.

  Read the article

• MVC architecture EJB funcionallity

  - by Ignacio

  HI would like to understand how do ejbs work in an MVC architecture, what i do not get is: When the web app starts, the system creates an ejb for each record in every table of db or an ejb with all the records of all tables? Thank you very much

  Read the article

• Is there an efficient way to query a document database?

  - by Zubair

  Since document databases store records in tree like structures the fields will never be at set positions. Does this make querying a document database inefficient, or would indexes just be used as with a normal relational database?

  Read the article

• PHP MYSQL SIMPLE SEARCH ISSUE

  - by Kunal

  Hi I have a table with the following structure: id int(11), name varchar(250) I have lots of records in the table but when I am trying to find a particluar record which has the following value on the name field: Lorem ipsum d\'olor sit amet The query is simply returning a blank recordset. I am not being able to figure out this weird behaviour, when my query is as simple as follows: SELECT * FROM slot_games WHERE name='Lorem ipsum d\'olor sit amet' Would appreciate your help please! Thanks in advance.

  Read the article

• Will MySQL full-text-search return the results I need?

  - by mike

  I have a keyword field with a list of 5 keywords for each item. example below: 2008, Honda, Accord, Used, Car Will MySQL full text return the item above for the following search requests? 2008 Honda Accord Honda Accord Used Car If so, how well will this hold up when searching through fifty thousand plus records?

  Read the article

• Concatenate multi value into one record.

  - by mikehjun

  I joined two tables together and what I like to do is concatenate multi vaule in one records without duplicated value. TAXLOT_ZONE TID ZONE 1 A 1 A 1 B 1 C 2 D 2 D 2 E 3 A 3 B 4 C 5 D Desirable Final table looks like; TID ZONE 1 A, B, C 2 D, E 3 A, B 4 C 5 D

  Read the article

• How to remove duplicate entries from a mysql db?

  - by Yegor

  I have a table with some ids + titles. I want to make the title column unique, but it has over 600k records already, some of which are duplicates (sometimes several dozen times over). How do I remove all duplicates, except one, so I can add a UNIQUE key to the title column after?

  Read the article

• ActiveRecord find starts with

  - by robintw

  Really simple question - how do I do a search to find all records where the name starts with a certain string in ActiveRecord. I've seen all sorts of bits all over the internet where verbatim LIKE SQL clauses are used - but from what I've heard that isn't the 'correct' way of doing it. Is there a 'proper' Rails way?

  Read the article

• How to directly access a certain part of a text file in g++?

  - by Phenom

  I have a text file containing a number of records. Each record is stored on a single line that is 100 characters long. Let's say I want to directly access the nth record. I could do it using a for loop, reading in n lines until I get to the record. But how could I access it directly?

  Read the article

• Zend Framework: Can I use an add view script for editing too?

  - by spdaly

  I have a simple Zend Framework that has a view script to add records to the database. This is a silly question IMHO, but how can I use the add view script to edit the record as well?? I have played around with a few scenarios to no avail. Thanks, Steve

  Read the article

• Rails find through association

  - by yogi

  class Customer < ActiveRecord::Base has_one :address, :foreign_key => "customerid" end class Address < ActiveRecord::Base belongs_to :customer, :foreign_key => "customerid" end How do I find records in customer that do not have customerid in address table? in SQL i'd do select * from customer a, address b where a.customerid <> b.customerid

  Read the article

• limiting a query to a specific item

  - by Dev-Ria

  I have a db with thousands of domains and data. I want to list only 100 rows of each domain. i can't use LIMIT 100 cause that only limits 100 records but I want dom1 to list 100 dom2 to list 100 dom3 to list 100 all in one query. This is what I have so far. SELECT domain COUNT(Key) AS DomCount FROM table_domain GROUP BY user,location ORDER BY domain,DomCount DESC Could I use a CASE?

  Read the article

• How to select the last record from MySQL table using SQl syntax.

  - by Vafello

  I have a table with several records. There is an id field. I would like to select the record with the most recent id (i.e. the ighest id). Any ideas?

  Read the article

• Difference between INSERT INTO and INSERT ALL INTO

  - by emily soto

  While I was inserting some records in table i found that.. INSERT INTO T_CANDYBAR_DATA SELECT CONSUMER_ID,CANDYBAR_NAME,SURVEY_YEAR,GENDER,1 AS STAT_TYPE,OVERALL_RATING FROM CANDYBAR_CONSUMPTION_DATA UNION SELECT CONSUMER_ID,CANDYBAR_NAME,SURVEY_YEAR,GENDER,2 AS STAT_TYPE,NUMBER_BARS_CONSUMED FROM CANDYBAR_CONSUMPTION_DATA; 79 rows inserted. INSERT ALL INTO t_candybar_data VALUES (consumer_id,candybar_name,survey_year,gender,1,overall_rating) INTO t_candybar_data VALUES (consumer_id,candybar_name,survey_year,gender,2,number_bars_consumed) SELECT * FROM candybar_consumption_data 86 rows inserted. I have read somewhere that INSERT ALL INTO automatically unions then why those difference is showing.

  Read the article

• dealing with a large flat data files with a very big record length

  - by gsp

  I have a large data file that is creatd from a shell script. Next script processes it by sorting and reading several times, that takes more than 14 hours, it is not viable. I want to replace this long running script with a program, probably in JAVA, C, or COBOl, that can run on windows or on sun solaris. I have to read a group of records everytime, sort and process and write to the output sort file and at the same time insert into db2/sql tables.

  Read the article

• [MYSQL] select statement that combines similar rows with certain ids ?

  - by vegatron

  hi I have a warehouse_products table which defines how many products in the warehouses so lets say I have 20 records/rows in the table, some rows may contain the same product id but in a different warehouse I need to create select statement that give every product one row, and in this row I must have the quantity in warehouse A and warehouse B .. so in the end I will get for example 10 rows that contain all the data id domain_id warehouse_id wh_product_id quantity 2 1 2 2 84 3 1 1 3 221 4 1 3 3 0 5 1 1 3 14 6 1 1 2 73 7 1 1 1 123

  Read the article

• Best way to update record X when Y is inserted

  - by Saif Bechan

  I have a huge table that is mainly used for backup and administrative purposes. The only records that matters is the last inserted record. On every hit to order by time inserted is just too slow. I want keep a separate table with the last inserted id. In PHP I now insert, get last inserted id, and update the other table. Is there a more efficient way to do this.

  Read the article

• Load huge sql dump to mySql

  - by jonathan

  Hi I have a huge mysql dump file generated from phpmyAdmin (150 000 lines of create table, inserts....) The mySql query tool fails to open such a big file. As a result i can't insert all the records. Is there a way to do this ? Thanks John

  Read the article

• What kind of database to use in C#

  - by Chris

  I'm writing a program in C# that will need to store a few Data Tables on the user's computer and load them back when he restarts the program: Up to about 10000 records consisting of text and integers. I don't want to use a CSV file, and I had some trouble with SQLite. Are there any other good options to try?

  Read the article

• Updating Access Database with Json in ASP

  - by krishit

  Hi, I have to use Json objects and Create, Update, delete and retrive the records in asp. if anybody have an example, please help me. Thanks in advance.

  Read the article

• google apps is setup on my server, how do i get php mail() to use it?

  - by Haroldo

  Hi, I've got google apps setup on my server with all the correct MX records etc, now i want to start testing it. I want to use it for all automated emails (registration, lost password etc). I'm testing on a localhost.

  Read the article

• how to specify only start index in LIMIT in MySQL select query?

  - by snew

  I want to select the records from the table starting from 3rd row. How this can achieved with LIMIT?

  Read the article

< Previous Page | 107 108 109 110 111 112 113 114 115 116 117 118  | Next Page >