Loading ...
Sorry, an error occurred while loading the content.
 

Re: [phpexperts] i want to know the how to get the in built unique id in mysql

Expand Messages
  • mizanur rahman
    well that will creat row id , just for the tables. not for the whole database. you can use postgre sql , postgre have this feature which is known as OID thanks
    Message 1 of 4 , Jun 2, 2005
      well that will creat row id , just for the tables. not
      for the whole database. you can use postgre sql ,
      postgre have this feature which is known as OID

      thanks


      --- "Md. Ashraful Anam" <anam@...> wrote:

      >
      > Just create a ID field as AUTO_INCREMENT. Say the
      > table structure is:
      >
      > CREATE TABLE `news` (
      > `id` int(6) NOT NULL default '0' AUTO_INCREMENT,
      > `edate` datetime NOT NULL default '0000-00-00',
      > `news_type` tinyint(1) DEFAULT '0' NOT NULL,
      > `title` varchar(125) NOT NULL default '',
      > `news` text NOT NULL,
      > `filedata` longblob,
      > `filename` varchar(140) NOT NULL,
      > `filesize` varchar(50) NOT NULL,
      > `filetype` varchar(60) NOT NULL,
      > PRIMARY KEY `id`
      > ) TYPE=MyISAM;
      >
      > the id field will be autogenerated here. After a
      > insert query u can find this id with the function
      > mysql_insert_id();
      >
      > -Russell.
      >
      >
      > ----- Original Message -----
      > From: nalin_krish
      > To: phpexperts@yahoogroups.com
      > Sent: Wednesday, June 01, 2005 5:04 PM
      > Subject: [phpexperts] i want to know the how to
      > get the in built unique id in mysql
      >
      >
      >
      >
      > hi,
      >
      >
      > i want to know how to get the inbuilt unique id in
      > mysql similar to
      > the rowid in oracle.
      >
      >
      >
      >
      >
      >
      >
      >
      > Visit ProjectsHosted, online directory for PHP
      > software : http://dev6.php5.nedlinux.com
      >
      >
      >
      >
      ------------------------------------------------------------------------------
      > Yahoo! Groups Links
      >
      > a.. To visit your group on the web, go to:
      > http://groups.yahoo.com/group/phpexperts/
      >
      > b.. To unsubscribe from this group, send an
      > email to:
      > phpexperts-unsubscribe@yahoogroups.com
      >
      > c.. Your use of Yahoo! Groups is subject to the
      > Yahoo! Terms of Service.
      >
      >


      __________________________________________________
      Do You Yahoo!?
      Tired of spam? Yahoo! Mail has the best spam protection around
      http://mail.yahoo.com
    Your message has been successfully submitted and would be delivered to recipients shortly.