Best unofficial Apache Server developers community
Username
Forgot password?
Sign in with Twitter account
Sign in with Facebook account

select

0
votes
2 answers
49 views

Sql query - select with or

i need to catch the password of a specif email when the value of activation is 1 or 2 query that i am using: $stmt = $db->prepare('select…
mysql query email select mysqli
asked June 24, 2011 3:21 pm CDT
user455318
0
votes
2 answers
32 views

MySQL count distinct query

I have a table which i kept kept posts comment_type, amount etc. PostExtras - id - amount - post_id (foreign key) - comment_type (foreign key) - ...…
mysql select distinct-values
asked June 24, 2011 6:42 am CDT
daemon
0
votes
0 answers
35 views

MySQL While Statement

BEGIN DECLARE parcelas TINYINT(3); DECLARE results VARCHAR(38); DECLARE pgid INT(11); SELECT @pgid := `pagamentos`.pgid FROM `pagamentos` WHERE…
mysql select loops while-loops statement
asked June 23, 2011 9:20 am CDT
XML4Parse
0
votes
3 answers
28 views

Using Update Query to Copy Column Data

I need to copy the value in a column named TEAM from one row into another row. Both rows need to have the same team name. This is my query that…
php mysql query select update
asked June 22, 2011 7:07 pm CDT
Jessica
1
vote
2 answers
32 views

MySQL: SELECT with LEFT JOIN

how can I join two tables and make the second optional? SELECT t1.title,SUM(t2.seconds) AS seconds FROM operation t1 LEFT JOIN workhours t2 ON t1.id…
mysql select join
asked June 22, 2011 11:02 am CDT
Billy
0
votes
3 answers
37 views

SQLite select x-th row

let's suppose I have this table, where I deleted the row with rowid=3: rowid | something ------+----------- 1 | ... 2 | ... 4 | ... 5 | ... How to…
sql sqlite select rowid
asked June 22, 2011 8:23 am CDT
Martin Janiczek
0
votes
2 answers
36 views

Mysql Select within IF condition

looking to perform a query that on a particular conditions gets the data from another table. it like select field1, field2.... IF(fieldX=3,select…
mysql select if-statement condition
asked June 21, 2011 10:42 am CDT
Junaid
0
votes
0 answers
33 views

SQL SELECT * FROM tbl (HIDE COLUMN)

I'm trying to do SELECT * FROM tbl , but out of 20 columns I don't want 1 particular column to be selected. Is there a dynamic way to do so? Just…
mysql sql sql-server query select
asked June 21, 2011 9:25 am CDT
eistrati
0
votes
4 answers
42 views

MySQL word+word search

I have two tables: Dictionary, Names. Both tables have large number of rows (like 200.000). Columns in Dictionary: id, word Columns in Names: id,…
mysql search select columns concatenation
asked June 21, 2011 8:21 am CDT
Darko Martic
0
votes
2 answers
37 views

C# mySQL connection multiple select statements

I can connect to mySQL database from my winform app fine. the question is once I am logged in how can I perform multiple select statements without…
c# mysql winforms select
asked June 20, 2011 12:21 pm CDT
John Ryann
0
votes
1 answer
28 views

How to retrieve all rows thats co-ords are within a specifc radius in MySql Database

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…
mysql database select
asked June 20, 2011 11:13 am CDT
molleman
0
votes
1 answer
55 views

CodeIgniter Select Query

I have a simple CodeIgniter Active record query to select an ID: $q = $this -> db -> select('id') -> where('email', $email) -> limit(1)…
php mysql codeigniter variables select
asked June 20, 2011 2:30 am CDT
Roman
1
vote
1 answer
28 views

Mysql Before Insert Trigger SET problem

I have a basic table which I will populate with CHAR(4) primary keys. These values are selected from a chars table with a subquery. I want to set up…
mysql select triggers insert
asked June 18, 2011 10:00 pm CDT
Cengiz Can
0
votes
5 answers
46 views

How to create a nested select query in sql

What I am trying to do is create a comments section for a website, The comments consist of a user's name, email and comment. I store this data in…
mysql sql select inner-join
asked June 18, 2011 1:31 pm CDT
AdRock
0
votes
2 answers
33 views

Using SQL to get values from another table given a table with two columns of key

After some joins, I've managed to get a table that looks like: src | destination 1 | 2 3 | 4 Both source and destinations are IDs and there's…
sql sqlite select join
asked June 17, 2011 3:15 pm CDT
Abhinav Sharma
0
votes
4 answers
32 views

MySQL: How to select sum across 100 tables?

I unfortunately have spread some data across about 100 tables, and I don't have time to reorganize it, so I am curious as to how I might do a select…
mysql select
asked June 17, 2011 10:21 am CDT
fubarts
0
votes
1 answers
53 views

Sql script that requires connection to a remote server

I have been given a sql script to execute that populates a table from the result of a query on a table that is on a remote server.. How do I select…
mysql select remote
asked June 16, 2011 4:00 pm CDT
Peter
0
votes
2 answers
31 views

Optimizing a MySQL SELECT query?

How much can the following query be changed to improve it's performance on a "large" database? SELECT SQL_CALC_FOUND_ROWS wp_rb_posts.* FROM…
mysql sql optimization select
asked June 16, 2011 3:15 pm CDT
Tal Galili
0
votes
2 answers
37 views

Select on multiple tables

I have 2 tables that contain completely seperate information table: tires columns: Tire_id name model etc etc table: product columns: product_id…
mysql table select multiple
asked June 16, 2011 6:25 am CDT
Burrii
10
votes
3 answers
38 views

Select 10 times slower when reversing order

Why would this select, call it A , (0.02406s): select * from char_kills where rid_first <= 110 and rid_last >= 110 order by kills desc limit…
mysql select query-optimization
asked June 15, 2011 11:30 pm CDT
Qtax
Pages : 1 | 2 | 3 | 4 | 5 > [19]
374

select

Tagged: select
Related Tags
mysql × 337
php × 84
sql × 72
query × 54
join × 39
sqlite × 26
insert × 23
database × 20
where × 14
table × 13
count × 13
update × 11
postgresql × 10
subquery × 8
multiple × 7
mysql-query × 7
union × 7
zend-framework × 7
order-by × 6
row × 6
date × 6
like × 6
regex × 6
android × 5
variables × 5
column × 5
java × 5
condition × 5
order × 5