// Modify last record
UPDATE userinfo set userid='55' WHERE 1 ORDER BY userid DESC LIMIT 1
// Delete first record
delete from userinfo where 1 order by userid limit 1

mysql sql Modify table name Build foreign key Modify column name Delete column -- rename table
rename table t_softwareport to software_port;

-- Build foreign key
alter table software_port add constraint fk_software_port_softwareprocessid
foreign key (softwareprocessid)
      references software_process (id) on delete restrict on update restrict;

-- Delete column
alter table software_type
drop column upid,
drop column orderid;

-- Modify column name
alter table software_process change  software_id  softwareid  int(11) not null;

Technology
©2019-2020 Toolsou All rights reserved,
It's unexpected Python Cherry tree (turtle The gorgeous style of Library ) Some East 14 Pay change 16 salary , Sincerity or routine ? Browser kernel ( understand )java Four functional interfaces ( a key , simple )HashMap Explain in detail html Writing about cherry trees , Writing about cherry trees os Simple use of module