Data Base/MySQL
-
kimho_board queryData Base/MySQL 2008. 4. 17. 10:48
mysql> create table board( -> b_id int not null primary key, -> b_name varchar(20) not null, -> b_mail varchar(30), -> b_title varchar(60), -> b_content text, -> b_date datetime, -> b_view int, -> b_pwd varchar(12)); Query OK, 0 rows affected (0.20 sec)
-
user insert 쿼리Data Base/MySQL 2008. 4. 17. 10:38
Enter password: ********* Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 2 Server version: 5.0.51a-community-nt MySQL Community Edition (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> create database mydb; Query OK, 1 row affected (0.03 sec) mysql> user mydb; ERROR 1064 (42000): You have an error in your SQL syntax; check the manua..
-
회원 테이블 생성 쿼리Data Base/MySQL 2008. 4. 11. 14:26
create table member (mem_id varchar(10) not null primary key, mem_pwd varchar(10) not null, mem_name varchar(20) not null, mem_addr1 char(3) not null, mem_addr2 char(3) not null, mem_addr3 varchar(100), mem_tel1 varchar(4), mem_tel2 varchar(4), mem_tel3 varchar(4), mem_mail varchar(40), mem_memo varchar(200) );
-
mysql 을 설치했는데...자꾸 삐삐 거리면서 신경 거스르는 소리가 났지만 해결.Data Base/MySQL 2008. 4. 10. 16:03
http://opensource.apress.com/article/46/removing-the-beep-from-mysqls-console 페이지에 보면 To stop the dreaded beep on Windows, you can also type ‘net stop beep’ at the command line. 콘솔 창에 net stop beep. 삐삐 소리가 난게 beep 음이라고 하는거 같은데... 싸이트에 제거 하는 방법이 여러개 있었는데 저 명령어가 킹왕짱인듯.
-
java.lang.ClassNotFoundException: org.gjt.mm.mysql.DriverData Base/MySQL 2008. 3. 12. 01:10
kimho's jsp 를 하다가 java.lang.ClassNotFoundException: org.gjt.mm.mysql.Driver 에러가 났다. C:\Documents and Settings\han58>javap org.gjt.mm.mysql.Driver Compiled from "Driver.java" public class org.gjt.mm.mysql.Driver extends java.lang.Object implements java.sql.Driver{ static final int _MAJORVERSION; static final int _MINORVERSION; static final boolean debug; static final boolean trace; public org.gjt..