There's no need for it to be a flame war. The mysql extension is officially
not recommended for writing new code, so anyone using it should be informed
of this fact. I think it should consist of more than "don't use that," but
at the very least that should cause the questioner to want to know why.
Am 13.03.13 10:35, schrieb Kevin Peterson:
> In my database design, I tend to store some variable that is meant to be
> acting as a ROLE or TYPE as SMALLINT. For example :
>
> CREATE TABLE `house` (
>`id` int(11) NOT NULL AUTO_INCREMENT,
>`type` smallint(11) NOT NULL,
> )
On Mar 13, 2013, at 10:35 AM, Kevin Peterson wrote:
> In my database design, I tend to store some variable that is meant to be
> acting as a ROLE or TYPE as SMALLINT. For example :
>
>CREATE TABLE `house` (
> `id` int(11) NOT NULL AUTO_INCREMENT,
> `type` smallint(11) NOT NULL,
In my database design, I tend to store some variable that is meant to be acting
as a ROLE or TYPE as SMALLINT. For example :
CREATE TABLE `house` (
`id` int(11) NOT NULL AUTO_INCREMENT,
`type` smallint(11) NOT NULL,
)
And in php, I do
define('HOUSE_SMALL_TYPE', '0');
Hello all:
I had a few questions.
First, I'm using php-fastcgi with nginx for my primary web server. I was
wondering what sorts of optimizations exist to make this process a lot
faster.
Second, I'm setting up a custom application, and it contains an
authentication module for login/registration.
Greetings,
I have a site that I am developing and I am looking to partner/
developer with great php/mySQL skills (for share of potential profits)
to assist me in finishing this site. I am looking for someone who can
invest (like myself) their time and skills to complete the site in
Leave the past behind. You're moving forward. And - for whatever reason
that they were used originally, you now have the opportunity to rid yourself
of column names that must be a pia to type all the time.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.
On Thu, Mar 22, 2012 at 7:42 PM, Stuart Dallas wrote:
> On 23 Mar 2012, at 00:10, Chris Stinemetz wrote:
>
>> Is it possible to create a MySQL table with characters such as "." and
>> "[]" in the column headers? If so would you explain how?
>
> Try putting the column names in backticks (`).
>
> BU
On 2012-03-22, at 8:10 PM, Chris Stinemetz wrote:
> Hello List,
>
> Is it possible to create a MySQL table with characters such as "." and
> "[]" in the column headers? If so would you explain how?
>
> Thank you,
>
> Chris
>
> --
> PHP General Mailing List (http://www.php.net/)
> To unsubs
On 23 Mar 2012, at 00:10, Chris Stinemetz wrote:
> Is it possible to create a MySQL table with characters such as "." and
> "[]" in the column headers? If so would you explain how?
Try putting the column names in backticks (`).
BUT... whatever the reason why you want to do that, IT'S WRONG.
Ser
Hello List,
Is it possible to create a MySQL table with characters such as "." and
"[]" in the column headers? If so would you explain how?
Thank you,
Chris
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On 19 Mar 2012, at 22:43, Tom Sparks wrote:
> I have a members list witch I print out once a week,
> I would like to make the list into two-column list, but I dont know where to
> start looking to change the code?
>
> here is the code
> "
> $result = mysql_query("SELECT * FROM customers ORDER BY
.1, UAE AF 2006 Premium Edition, AF 2012
Plus Edition, Sam440 AOS 4.1.2, Roland DXY-1300 pen plotter, Cutok DC330
cutter/pen plotter
Wanted: RiscOS system, GEOS system (C64/C128), Atari ST, Apple Macintosh
(6502/68k/PPC only)
--- On Tue, 20/3/12, Tom Sparks wrote:
> From: Tom Sparks
> Sub
--- On Tue, 20/3/12, Ashley Sheridan wrote:
From: Ashley Sheridan
Subject: Re: [PHP] mysql list to two-column list
To: "Tom Sparks"
Cc: "php-general"
Received: Tuesday, 20 March, 2012, 10:15 AM
On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote:
--- On
>> my goal is to do something phonebook like
>>
>
> Your reply of 9 words adds no extra information. Rather than have us all
> guess what you want, try and tell us specifically what it is that you
> want.
Hi Tom
I *think* what want to be asking is, "what HTML do I change/add such that my
data c
On Mon, 2012-03-19 at 16:09 -0700, Tom Sparks wrote:
> --- On Tue, 20/3/12, Ashley Sheridan wrote:
>
> On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
>
> >>I have a members list witch I print out once a week,
> >>I would like to make the list into two-column list, but I dont know >>where
--- On Tue, 20/3/12, Ashley Sheridan wrote:
On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
>>I have a members list witch I print out once a week,
>>I would like to make the list into two-column list, but I dont know >>where
>>to start looking to change the code?
>>here is the code
>>"
>>
On Mon, 2012-03-19 at 15:43 -0700, Tom Sparks wrote:
> I have a members list witch I print out once a week,
> I would like to make the list into two-column list, but I dont know where to
> start looking to change the code?
>
> here is the code
> "
> $result = mysql_query("SELECT * FROM customers
I have a members list witch I print out once a week,
I would like to make the list into two-column list, but I dont know where to
start looking to change the code?
here is the code
"
$result = mysql_query("SELECT * FROM customers ORDER BY LastName");
while($row = mysql_fetch_array($result))
{
On Mon, Mar 5, 2012 at 7:33 AM, wrote:
>> > I have a MySQL server A, a server B with PHP 5.3.8 and a server C with
>> > PHP 5.3.3. I'm connecting to the MySQL server on A via TCP from B and C
>> > using an internal network. Server B and C use the same PHP application.
>> > There are also same PHP
> > I have a MySQL server A, a server B with PHP 5.3.8 and a server C with
> > PHP 5.3.3. I'm connecting to the MySQL server on A via TCP from B and C
> > using an internal network. Server B and C use the same PHP application.
> > There are also same PHP scripts that get data from the database and
On Mon, Feb 27, 2012 at 4:06 AM, wrote:
> Hi,
>
> I have a MySQL server A, a server B with PHP 5.3.8 and a server C with PHP
> 5.3.3. I'm connecting to the MySQL server on A via TCP from B and C using an
> internal network. Server B and C use the same PHP application. There are also
> same PHP sc
Hi,
I have a MySQL server A, a server B with PHP 5.3.8 and a server C with PHP
5.3.3. I'm connecting to the MySQL server on A via TCP from B and C using an
internal network. Server B and C use the same PHP application. There are also
same PHP scripts that get data from the database and then cal
Bear with me here. I have a problem with PHP and MySQL that's been stumping
me for a couple of days now. I'm not even sure how to describe it, so I'll
just do my best.
There's a row in our bugs database that looks like every other row in the
table, but when it's pulled from the database and displa
mysqli - it's what I wanted. thanks
Sorry, I clicked the 'reply' button instead of reply to all.
Original Message
Subject: Re: [PHP] mysql adapter and DAL
Date: Sat, 17 Sep 2011 19:07:48 +0530
From: Nilesh Govindarajan
To: shahrzad khorrami
On Sat 17 Sep 2011 04:54:13 PM IST, shahrzad khorrami wrote
hi,
If you are building your own dal I guess you would have to build your own
adapter,
simply use mysqli function and wrap them in a class.
On 17 September 2011 12:24, shahrzad khorrami
wrote:
> hi all,
> I'm looking for a mysql adapter for create my dal..
> where can I find a good one? and hav
hi all,
I'm looking for a mysql adapter for create my dal..
where can I find a good one? and have you ever written a dal with a mysql
adapter?
in my dal I want to pass parameters to sql sting, for example like
following:
$db->query($sql, array($name, $family))
thanks,
Shahrzad Khorrami
I think it's not the best place to send it but:
$dolgF is not closed with ; ...and the insert is not in a variable!
(And also I think it's not a good way using COOKIE in PHP because we have
sessions)
So the answer is: the all.. :D -or what's the full part you use for insert
int this source!?
$ime=$_COOKIE['user'];
$dolgF=filesize($filename)
INSERT INTO `friendlyCMS`.`log` (`imepriimek`, `clock`, `action`,
`onfile`, `filesize`) VALUES ( $ime, CURRENT_TIMESTAMP,
'saved',$filename, $dolgF);
What is wrong with this?
PS First column of the log table is idlog primary key autoincrement
not n
>[SNIP]
> added and else clause.
> while ($_parent != 0)
> {
> if
> ($num_rows > 0)
>{
>
> perform some action
>}
>else
>{
> $_parent =
> "0";
>}
> }
>
> and that solved the
> problem.
>
> Thank you, everyone for your help.
>
> Curtis
A small remark:
I think it is good
Sean Greenslade wrote:
>>
>
> [MASSIVE
SNIP]
>
> Well, from what I saw while wading through your
code, you allow
> unsanitized
> variables to be
concatenated to your queries. Big no-no! For ANY
>
client-generated variable, always sanitize with
mysql_real_escape_string.
> In
> fact, sanitize al
Tim Streater wrote:
> On 11 May 2011 at 19:25, Curtis
Maurand wrote:
>
>>
$_cartTotal="$0.00";
>
> Surely that should
be:
>
> $_cartTotal = "0.00";
Good
pickup. I missed that. I didn't write the code, I'm just
trying to figure out what's going on.
Thanks, I'll look at
that. --C
On 11 May 2011 at 19:25, Curtis Maurand wrote:
> $_cartTotal="$0.00";
Surely that should be:
$_cartTotal = "0.00";
tim
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Wed, May 11, 2011 at 2:25 PM, Curtis Maurand wrote:
>
>
> Marc Guay wrote:
> >> Does anyone have any ideas?
> >
> > Sounds like it's getting caught in a loop. Post the whole script
> for
> > best results.
> >
> It looks like the site is
> under attack, because I keep seeing the query, "SELECT
Marc Guay wrote:
>> Does anyone have any ideas?
>
> Sounds like it's getting caught in a loop. Post the whole script
for
> best results.
>
It looks like the site is
under attack, because I keep seeing the query, "SELECT catagory_parent FROM
t_catagories where catagory_ID=" .
$_currentCat"
wh
Marc Guay wrote:
>> Does anyone have any ideas?
>
> Sounds like it's getting caught in a loop. Post the whole script
for
> best results.
>
It looks like the site is
under attack, because I keep seeing the query, "SELECT catagory_parent FROM
t_catagories where catagory_ID=" .
$_currentCat"
wh
> Does anyone have any ideas?
Sounds like it's getting caught in a loop. Post the whole script for
best results.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
I'm running PHP 5.3.6, Mysql 5.1.51 and Apache 2.2.17
I have
code that does a simple mysql_query(); the query on the commandline
returns an empty set. when run via PHP and the web server, the page
hangs, it never gets to the if (mysql_num_rows($result) > 0) {}. and
the queries per second on my
Hi Grega,
Probably you wanna define a primary key, if so, then change from
"uniqueid" to "primary key".
2011/5/6 Curtis Maurand :
>
>
>
> engine=
>
> --C
>
> Grega Leskovšek wrote:
>> Can smbd please look at this sentence - I got an error and do
> not
>> know how to fix it - I am still very unfa
engine=
--C
Grega Leskov¹ek wrote:
> Can smbd please look at this sentence - I got an error and do
not
> know how to fix it - I am still very unfamiliar with
MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment
not null, imepriimek
> varchar(50), clock timestamp, action
varchar(30), o
On Thu, May 5, 2011 at 10:29, Grega Leskovšek wrote:
> Can smbd please look at this sentence - I got an error and do not
> know how to fix it - I am still very unfamiliar with MYSQL:
>
> CREATE TABLE log ( idlog int auto_increment not null, imepriimek
> varchar(50), clock timestamp, action va
: Grega Leskovšek
To: php-general
Date created: , 5:29:44 PM
Subject: [PHP] mysql error
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50
Can smbd please look at this sentence - I got an error and do not
know how to fix it - I am still very unfamiliar with MYSQL:
CREATE TABLE log ( idlog int auto_increment not null, imepriimek
varchar(50), clock timestamp, action varchar(30), onfile
varchar(100), filesize float(6,2), uniqueid(
I was previously on PHP 5.1.6 and was using the following code:
$dbr = mysql_unbuffered_query($query, $this->con);
while($row = mysql_fetch_array($dbr, $assoc ? MYSQL_ASSOC : MYSQL_NUM))
$this->result[] = $row;
$this->rows = mysql_num_rows($dbr);
It worked properly. The documentation at
htt
BTW, how is the traffic on your site? What's the max connection limit
and timeout set on the MySQL server?
[1] from searching [2] might be the solution to your problem.
Good luck,
Tommy
[1] http://forums.mysql.com/read.php?52,364493,364831#msg-364831
[2] http://www.google.com/search?q=php+SQLST
(Ubuntu 10.10 Server, PHP 5.3.2-1ubuntu4.7 with
> Suhosin-Patch (cli) (built: Jan 12 2011 18:36:55))
>
> Does anyone else have the same problems?
>
> Thanks for any help,
> Matthias
> --
Have you tried a basic test w/o framework like this to ensure that
both installed v
On 11-02-16 11:55 AM, Robert Cummings wrote:
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called "images" with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name
On 11-02-16 11:37 AM, דניאל דנון wrote:
Hi.
I have a table called "images" with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make su
Hi.
I have a table called "images" with 4 columns - `image_id`, `item_name`,
`image_url`, `image_views`
(Where image_id is UNIQUE and AUTO-INCREMENT).
Sometimes, there might be many items with the same name (but not with the
same url).
I want to make sure that each "item name" has at most 3 ima
Hey there,
I've just migrated to Mysql 5.5 from source and it works like a charm. Still
every now and then (in intervals of approximatly an hour) I get the following
error:
Error: Uncaught exception 'PDOException' with message 'SQLSTATE[HY000] [2013]
Lost connection to MySQL server at 'reading
Hi,
Monday, January 24, 2011, 10:50:41 PM, you wrote:
BP> Hi all,
BP> I have to perform a mysql query in a table with millions of records.
BP> I've full-text indexed my search field and I'm searching with MATCH AGAINST.
BP> But there is a problem. In this field there are company names that
BP> c
> -Original Message-
> From: Barbara Picci [mailto:barbara.pi...@sardi.it]
> Sent: Monday, January 24, 2011 4:51 AM
> To: php-general@lists.php.net
> Subject: [PHP] Mysql search query ignoring dots
>
> Hi all,
>
> I have to perform a mysql query in a tab
Hi all,
I have to perform a mysql query in a table with millions of records.
I've full-text indexed my search field and I'm searching with MATCH AGAINST.
But there is a problem. In this field there are company names that
contain dots, for istance I've "PO.SE. srl" and I want to find it if
the u
On Mon, Nov 29, 2010 at 14:40, Daniel P. Brown
wrote:
> For your convenience, both have been CC'd on this email.
Actually, PHP-DB (php...@lists.php.net) was accidentally BCC'd.
--
Dedicated Servers, Cloud and Cloud Hybrid Solutions, VPS, Hosting
(866-) 725-4321
http://www.parasane.net/
On Mon, Nov 29, 2010 at 14:35, Don Wieland wrote:
> Hi all,
>
> Is there a list/form to get some help on compiling mySQL queries? I am
> executing them via PHP, but do not want to ask for help here if it is no the
> appropriate forum. Thanks ;-)
Yes.
For MySQL queries, write to the MySQL
Hi all,
Is there a list/form to get some help on compiling mySQL queries? I am
executing them via PHP, but do not want to ask for help here if it is
no the appropriate forum. Thanks ;-)
Don
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.ph
On Fri, 2010-11-26 at 15:21 +0200, Sotiris Katsaniotis wrote:
> Greetings fellow PHP developers!
>
> I am looking of a relatively simple way to export a whole database into
> an Excel file. I have several methods to export tables to Excel files
> but unfortunately I have failed to export a whole
Greetings fellow PHP developers!
I am looking of a relatively simple way to export a whole database into
an Excel file. I have several methods to export tables to Excel files
but unfortunately I have failed to export a whole database!
Can someone be so kind to point me in the right direction?
Hello,
This doesn't relates to php directly.
Oracle , MSSQL supports TDE innately. Is there any way to adding that
support to mysql too ? Looking for some free, opensource solution.
Something which won't be much of a hit on performance.
thanks
--
Regards,
Nitesh Nandy
On Sun, 21 Nov 2010 11:19:04 -0700
"Ben Miller" wrote:
>
> To help clarify - the 3 tables look something like the following (tableName
> => column,column,column...):
>
> Products => product_id,product_name,product_description... (key =
> product_id)
> Criteria => criteria_id,criteria_title,cri
SELECT * FROM products p LEFT JOIN criteria_values cv ON p.key=cv.key LEFT
JOIN criteria c ON cv.key=c.key WHERE c.value IS NOT NULL
Hard to answer without more detail, but I am guessing the answer will be
something like the above. Your question makes it hard to understand whether
c or cv is joi
SELECT * FROM products p LEFT JOIN criteria_values cv ON p.key=cv.key LEFT JOIN
criteria c ON cv.key=c.key WHERE c.value IS NOT NULL
Hard to answer without more detail, but I am guessing the answer will be
something like the above. Your question makes it hard to understand whether c
or cv is jo
On Sat, 20 Nov 2010 13:54:29 -0700
"Ben Miller" wrote:
> Hi,
>
> I'm building a website for a client in which I need to compare their
> products, side-by-side, but only include criteria for which all selected
> products have a value for that criteria.
>
> In my database (MySQL), I have a tables
Richard L. Buskirk
-Original Message-
From: Ben Miller [mailto:biprel...@gmail.com]
Sent: Saturday, November 20, 2010 3:54 PM
To: 'php-general'
Subject: [PHP] MySQL Query Help
Hi,
I'm building a website for a client in which I need to compare their
products, side-by-
I'm going to jump in and throw in my 2 cents...
Have you used dreamweaver?
I would suggest Dreamweaver to any new programmer beginning php/mysql.
It helped me out tremendously in the beginning. I'm not an advanced programmer
with hand coding classes yet, but I can get any job com
Hi,
I'm building a website for a client in which I need to compare their
products, side-by-side, but only include criteria for which all selected
products have a value for that criteria.
In my database (MySQL), I have a tables named "products","criteria" and
"criteria_values"
If I have something
From: Gary
To: php-general@lists.php.net
Date: Tuesday, November 16, 2010, 3:35:12 PM
Subject: [PHP] mysql help (sorry, a bit OT)
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
that changes
> -Original Message-
> From: Gary [mailto:php-gene...@garydjones.name]
> Sent: Tuesday, November 16, 2010 5:35 AM
> To: php-general@lists.php.net
> Subject: [PHP] mysql help (sorry, a bit OT)
>
> Is there a way to check the syntax of a query, short of running it? I&
- Reply message -
From: "Gary"
Date: Tue, Nov 16, 2010 13:35
Subject: [PHP] mysql help (sorry, a bit OT)
To:
Is there a way to check the syntax of a query, short of running it? I've
got an insert to do (but of course it's a valid question for any query
that changes the
Redmine is (I think) one of the best out there. It is written in ruby
and does have all you need + some more.
Cheers!
On Fri, Nov 12, 2010 at 12:23 AM, Don Wieland wrote:
> Hi gang,
>
> I am looking into Project Management apps for my projects. Any suggestions:
>
> I am interested in tracking Pr
e up.
> --
> With best regards from Ukraine,
> Andre
> Skype: Francophile
> Twitter: http://twitter.com/m_elensule
> Facebook: http://facebook.com/menelion
>
> - Original message -
> From: Jonathan Tapicer
> To: Don Wieland
> Date: Friday, November 12, 2
: Don Wieland
Date: Friday, November 12, 2010, 3:00:32 AM
Subject: [PHP] Open Source PHP/ mySQL Project Management
Hi,
I don't know if it meets all of the features you enumerated but Mantis
(http://www.mantisbt.org/) is very good, and it is PHP+MySQL (or
Postgres, or MSSQL).
Jonathan
On T
Hi,
I don't know if it meets all of the features you enumerated but Mantis
(http://www.mantisbt.org/) is very good, and it is PHP+MySQL (or
Postgres, or MSSQL).
Jonathan
On Thu, Nov 11, 2010 at 7:23 PM, Don Wieland wrote:
> Hi gang,
>
> I am looking into Project Management apps f
eland
To: php-general@lists.php.net
Date: Friday, November 12, 2010, 12:23:11 AM
Subject: [PHP] Open Source PHP/ mySQL Project Management
Hi gang,
I am looking into Project Management apps for my projects. Any
suggestions:
I am interested in tracking Projects, Milestones, Tickets,
Hi gang,
I am looking into Project Management apps for my projects. Any
suggestions:
I am interested in tracking Projects, Milestones, Tickets, Files,
Discussions, Documents, Time Tracking, etc... Also, would like to have
the system have robust email integration Reminders, Email Ticket ec
cheaper than the first;
my question is:
on your experience, how do php / mySQL behave on multicores?
maybe its better a lesser_core / highest frequency system than a more_core /
lower frequency?
can a 12 GB / 24 GB RAM configuration make the difference? in which terms?
thank you for your
On Thu, 2010-08-12 at 02:02 +0430, Ali Asghar Toraby Parizy wrote:
> Hi.
> I need a protected directory in my server that only the authenticated user
> can reach all files in that folder(file type is zip and picture or a web
> page, maybe). I save user ID and passwords in mysql database. today I t
Hi.
I need a protected directory in my server that only the authenticated user
can reach all files in that folder(file type is zip and picture or a web
page, maybe). I save user ID and passwords in mysql database. today I tried
to use htaccess but mod_auth_mysql isn't installed on my server.
I know
Dear all,
I'm a newbie, need your help.
Now I am building a databasea using MySQL and PHP, I want to put two tables
in one searching, the two are in one database.
$query = "SELECT SQL_CALC_FOUND_ROWS * FROM table1 WHERE ".implode(" AND
", $data);
$number = "SELECT FOUND_ROWS()";
How can
On Mon, 19 Jul 2010 10:36:40 -0600
"Ashley M. Kirchner" wrote:
> mysql> select * from table where id='1';
> +---+-+-+---+
> | 1 | 123 | 0.0 | C |
> | 1 | 234 | 0.1 | D |
> | 1 | 345 | 0.0 | D |
> | 1 | 456 | 0.1 | C |
> | 1 | 567 | 0.1 | G |
> +---+-+-
I am very keen to see a closure to this thread so that I can add to my
snippets.
Let's all know what worked best out of many solutions that have been
proposed.
--Shreyas
On Tue, Jul 20, 2010 at 10:07 AM, Jim Lucas wrote:
> Peter wrote:
>
>> Hi All,
>>
>> I have a table which contain's some dup
Peter wrote:
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below, After exe
Just to add more perspective :
You will have a table with DISTINCT values.
Drop the initial table (better take a back-up); copy from the temporary
table which will have only DISTINCT values.
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:58 PM, Shreyas Agasthya wrote:
> How about this :
>
> CREATE
I may be going at this completely wrong but at the moment I'm
stuck. I have a DB from a client and need to do several searches on
it. This one sentence is important because it's their DB, not mine. So
I can't modify the way the DB was created in the first place, I can only
work with wh
How about this :
CREATE TEMPORARY TABLE bad_temp1 (id INT,name VARCHAR(20));
INSERT INTO bad_temp1 (id,name) SELECT DISTINCT id,name FROM SAMPLE;
Regards,
Shreyas
On Mon, Jul 19, 2010 at 7:31 PM, Richard Quadling wrote:
> On 19 July 2010 05:44, Peter wrote:
> > Hi All,
> >
> > I have a table
On 19 July 2010 15:01, Richard Quadling wrote:
> On 19 July 2010 05:44, Peter wrote:
>> Hi All,
>>
>> I have a table which contain's some duplicate rows. I just want to delete
>> the duplicate records alone
>> not original records.
>>
>> Assume my table as look as below
>>
>> column1 column2
>>
On 19 July 2010 05:44, Peter wrote:
> Hi All,
>
> I have a table which contain's some duplicate rows. I just want to delete
> the duplicate records alone
> not original records.
>
> Assume my table as look as below
>
> column1 column2
> 1
> a
> 1
> a
> 2
> b
> 3
> c
>
Hi Shiplu,
Thanks for reply.
Distinct function hide the duplicate records while we selecting the
record through the Query
i want to remove the duplicate entries in my table
i need a Delete Query instead of Select Query
shiplu wrote:
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2 FROM
Use distinct.
SELECT DISTINCT COLUMN1, COLUMN2 FROM ... ...
Shiplu Mokadd.im
My talks, http://talk.cmyweb.net
Follow me, http://twitter.com/shiplu
SUST Programmers, http://groups.google.com/group/p2psust
Innovation distinguishes bet ... ... (ask Steve Jobs the rest)
--
PHP General Mailing List
On Mon, Jul 19, 2010 at 10:44 AM, Peter wrote:
> Hi All,
>
> I have a table which contain's some duplicate rows. I just want to delete
> the duplicate records alone
> not original records.
>
> Assume my table as look as below
>
> column1 column2
> 1
> a
> 1
> a
> 2
> b
> 3
>
On Mon, Jul 19, 2010 at 10:14:30AM +0530, Peter wrote:
> Hi All,
>
> I have a table which contain's some duplicate rows. I just want to
> delete the duplicate records alone
> not original records.
>
> Assume my table as look as below
>
> column1 column2
> 1
> a
> 1
> a
> 2
> b
>
Hi All,
I have a table which contain's some duplicate rows. I just want to
delete the duplicate records alone
not original records.
Assume my table as look as below
column1 column2
1
a
1
a
2
b
3
c
3
c
i want the above table need to be as below, Aft
On Monday 28 June 2010 11:14:53 Andrew Ballard wrote:
> On Mon, Jun 28, 2010 at 10:27 AM, David McGlone wrote:
> > Tanel, we both learned something. I didn't fully understand join myself
> > yet, but I think I do now.
> >
> > but let me ask this if the join wasn't there would an if statement like
On Mon, Jun 28, 2010 at 10:27 AM, David McGlone wrote:
> Tanel, we both learned something. I didn't fully understand join myself yet,
> but I think I do now.
>
> but let me ask this if the join wasn't there would an if statement like I
> mentioned have worked?
>
> Blessings,
> David M.
I think yo
On Sunday 27 June 2010 22:12:41 Brandon Rampersad wrote:
> no
At least smack me and give us an explanation. :-)
--
Blessings,
David M.
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
On Monday 28 June 2010 09:49:55 Andrew Ballard wrote:
> On Sun, Jun 27, 2010 at 4:08 AM, Tanel Tammik wrote:
> > Hello,
> >
> > how to select only if value is present?
> >
> >$query = $db->query("select menus.id, menus.name,
> > case
> >when panels.id is not null then '1'
> >
On Sun, Jun 27, 2010 at 4:08 AM, Tanel Tammik wrote:
> Hello,
>
> how to select only if value is present?
>
> $query = $db->query("select menus.id, menus.name,
> case
> when panels.id is not null then '1'
> end as hiddenpanel
>
> from " . \DB_MENUS . " as menus
> left
no
On Sun, Jun 27, 2010 at 8:29 PM, David McGlone wrote:
> On Sunday 27 June 2010 04:08:24 Tanel Tammik wrote:
> > Hello,
> >
> > how to select only if value is present?
> >
> > $query = $db->query("select menus.id, menus.name,
> > case
> > when panels.id is not null then '1'
>
On Sunday 27 June 2010 04:08:24 Tanel Tammik wrote:
> Hello,
>
> how to select only if value is present?
>
> $query = $db->query("select menus.id, menus.name,
> case
> when panels.id is not null then '1'
> end as hiddenpanel
>
> from " . \DB_MENUS . " as menus
>
1 - 100 of 3790 matches
Mail list logo
