Results 1 to 4 of 4

Thread: check before insert data in mysql

  1. Jan 20th, 2008, 03:50 AM #1
    nokmaster
    nokmaster is offline

    Thread Starter
    Fanatic Member
    Join Date
    Nov 2002
    Location
    Philippines
    Posts
    877

    check before insert data in mysql

    Hi,

    How to do this check entry if exist or not then if not do insert data entry to mysql database.

    BR
    Reply With Quote Reply With Quote
  2. Jan 22nd, 2008, 02:22 PM #2
    killer7k
    killer7k is offline
    Fanatic Member
    Join Date
    Jul 2007
    Posts
    530

    Re: check before insert data in mysql

    isset ?
    Reply With Quote Reply With Quote
  3. Jan 22nd, 2008, 02:52 PM #3
    kfcSmitty
    kfcSmitty is offline
    PowerPoster kfcSmitty's Avatar
    Join Date
    May 2005
    Posts
    2,248

    Re: check before insert data in mysql

    INSERT INTO tbl_name (a,b,c) VALUES(1,2,3) where id not in (select id from tbl_name);

    Should do what you're looking for. It's not tested though.
    Reply With Quote Reply With Quote
  4. Jan 23rd, 2008, 08:41 AM #4
    visualAd
    visualAd is offline
    VBA Nutter visualAd's Avatar
    Join Date
    Apr 2002
    Location
    Ickenham, UK
    Posts
    4,906

    Re: check before insert data in mysql

    It is better though to use a query to check it exists first.

    SELECT NULL FROM ID tbl_name WHERE id=1

    If you have one record you know it is in there
    PHP || MySql || Apache || Get Firefox || OpenOffice.org || Click || Slap ILMV || 1337 c0d || GotoMyPc For FREE! Part 1, Part 2

    | PHP Session --> Database Handler * Custom Error Handler * Installing PHP * HTML Form Handler * PHP 5 OOP * Using XML * Ajax * Xslt | VB6 Winsock - HTTP POST / GET * Winsock - HTTP File Upload

    Latest quote: crptcblade - VB6 executables can't be decompiled, only disassembled. And the disassembled code is even less useful than I am.

    Random VisualAd: Blog - Latest Post: When the Internet becomes Electricity!!

    Spread happiness and joy. Rate good posts.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules


Click Here to Expand Forum to Full Width