SQL
cheng9007
这个作者很懒,什么都没留下…
展开
-
JDBC 建立MySQL连接
import java.sql.*;public class DataBase { private static String url = "jdbc:mysql://localhost:3306/mysql"; private static String driver = "com.mysql.jdbc.Driver"; private static String user原创 2012-04-11 21:51:27 · 394 阅读 · 0 评论 -
sql查询时实现类型转换(将字符串转换为日期)
Select sb_orders_product_name,sb_orders_product_description,sb_orders_qty,sb_orders_unit_price,sb_orders_subtotal,sb_orders_service_dateFROM sb_orders WHERE sb_orders_number ='40976801' AND sb_c原创 2012-05-30 13:58:35 · 2817 阅读 · 0 评论 -
添加、查看、删除外键
http://hi.baidu.com/shanghaocool/blog/item/1d014b0bf4afdc89d1581bbc.html添加外键alter table sitecodes drop foreign key FK_sitecodes设置外键 alter table 需要建立外键的表 add constraint 外键名字 foreign key原创 2012-05-31 18:20:35 · 370 阅读 · 0 评论