iguiyi的专栏

PowerDesigner 15设置mysql主键自动增长及基数 1、双击标示图，打开table properties->columns, 如图点击图标Customize Columns and Filter(或直接用快捷键Ctrl+U) 2、选中identity 3、 设置基数，点击physical options ，选中auto_increment添加到右边，并在下方输入10000设

两张表,user,字段,user_id,email,namedeal,字段deal_id,user_id,deal_name对应关系,user.user_id = deal.user_id,左关联:select u.*,d.* from user as u left join deal as d on d.user_id = u.user_id;右关联:select u