Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    1

    Question Unanswered: mysql simple insert command... need help

    Hi... i Have a database which stores websites... basically a search engine. I want to add bulk links by using INSERT but need some help with it. The only fields which need changing manually are:
    link_name
    link_url
    link_desc
    link_keywords

    The two fields which need to autochange are
    link_id (autoincrement)
    link_email - i need this to auto increment by name.. for instist. email1@test.com
    email2@test.com
    email3@test.com......

    The rest of the fields I want to remain static for all links I enter for a particular category.. and can change them when entering future links.


    the here is my links table structure.

    `link_id` int(6) unsigned NOT NULL auto_increment,
    `cat_id` int(4) unsigned NOT NULL default '0',
    `link_name` varchar(80) NOT NULL default '',
    `link_url` varchar(100) NOT NULL default '',
    `link_desc` text NOT NULL,
    `link_keyword` varchar(150) NOT NULL default '',
    `link_email` varchar(50) NOT NULL default '',
    `link_val` char(3) NOT NULL default '',
    `date` date NOT NULL default '0000-00-00',
    `link_pop` char(3) NOT NULL default '',
    `link_broken` char(3) NOT NULL default '',
    `link_sendemail` char(3) NOT NULL default '',
    `hits` int(5) NOT NULL default '5',
    `rate` int(5) NOT NULL default '1',
    `rating` int(8) NOT NULL default '9',
    `exp_date` date NOT NULL default '0000-00-00',
    `sponsorlogo` varchar(150) NOT NULL default ''

  2. #2
    Join Date
    Jun 2003
    Location
    Minnesota
    Posts
    61

    Post

    try searching the forums. Im sure there are tons of articles on this
    Mr. Lars

Posting Permissions

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