字段:id,uid,pwd
id为自动编号
insert into t(uid,pwd) values('a','ccc')
我想执行上面的INSERT操作时,得到id值,应该怎么办?

解决方案 »

  1.   

    真想得到那个id值,则id要设置成guid才行,否则无论什么方法都不能完全保证取出的值正确。
      

  2.   

    如果是sql server ,可以用select @@identity
      

  3.   

    SQL保留关键字:
    action
    add
    aggregate
    all
    alter
    after
    and
    as
    asc
    avg
    avg_row_length
    auto_increment
    between
    bigint
    bit
    binary
    blob
    bool
    both
    by
    cascade
    case
    char
    character
    change
    check
    checksum
    column
    columns
    comment
    constraint
    create
    cross
    current_date
    current_time
    current_timestamp
    data
    database
    databases
    date
    datetime
    day
    day_hour
    day_minute
    day_second
    dayofmonth
    dayofweek
    dayofyear
    dec
    decimal
    default
    delayed
    delay_key_write
    delete
    desc
    describe
    distinct
    distinctrow
    double
    drop
    end
    else
    escape
    escaped
    enclosed
    enum
    explain
    exists
    fields
    file
    first
    float
    float4
    float8
    flush
    foreign
    from
    for
    full
    function
    global
    grant
    grants
    group
    having
    heap
    high_priority
    hour
    hour_minute
    hour_second
    hosts
    identified
    ignore
    in
    index
    infile
    inner
    insert
    insert_id
    int
    integer
    interval
    int1
    int2
    int3
    int4
    int8
    into
    if
    is
    isam
    join
    key
    keys
    kill
    last_insert_id
    leading
    left
    length
    like
    lines
    limit
    load
    local
    lock
    logs
    long
    longblob
    longtext
    low_priority
    max
    max_rows
    match
    mediumblob
    mediumtext
    mediumint
    middleint
    min_rows
    minute
    minute_second
    modify
    month
    monthname
    myisam
    natural
    numeric
    no
    not
    null
    on
    optimize
    option
    optionally
    or
    order
    outer
    outfile
    pack_keys
    partial
    password
    precision
    primary
    procedure
    process
    processlist
    privileges
    read
    real
    references
    reload
    regexp
    rename
    replace
    restrict
    returns
    revoke
    rlike
    row
    rows
    second
    select
    set
    show
    shutdown
    smallint
    soname
    sql_big_tables
    sql_big_selects
    sql_low_priority_updates
    sql_log_off
    sql_log_update
    sql_select_limit
    sql_small_result
    sql_big_result
    sql_warnings
    straight_join
    starting
    status
    string
    table
    tables
    temporary
    terminated
    text
    then
    time
    timestamp
    tinyblob
    tinytext
    tinyint
    trailing
    to
    type
    use
    using
    unique
    unlock
    unsigned
    update
    usage
    values
    varchar
    variables
    varying
    varbinary
    with
    write
    when
    where
    year
    year_month
    zerofill