KTUGFaq
KTUG FAQ
Your mode of life will be changed for the better because of new developments.
BibTexMng › IncludeGraphics&value=WinEdtTip/DOS¸í·É½ÇÇà › bb���Ͼ�� › ChoF › LyX/한글쓰기&value=LaTeXϺ&value=LyX/한글쓰기&value=LaTeXÀ¸·ÎÀϺ»¾î»ç¿ë › MySQL
- MakingDic . . . . 2 matches
== mySQL database¹× table¸¸µé±â ==
{{{#> /usr/local/mysql/bin/mysql mysql
mysql>update user set password=password('******') where user='root';
mysql>flush privileges;
mysql>quit
{{{#> /usr/local/mysql/bin/mysql -u root -p mysql
mysql>create database TeXObGyDic;
mysql>insert into user (host,user,password) values('localhost','KTUG',password('KTUG1234'));
mysql>insert into db values ('localhost','TeXObGyDic','KTUG','y','y','y','y','y','y',
mysql>flush privileges;
mySQL ¹öÀü¿¡ µû¶ó dbÅ×À̺íÀ̳ª userÅ×À̺íÀÇ Ä®·³ ¼ö°¡ ´Ù¸£±â ¶§¹®¿¡, SQL¹®¹ý ¿À·ù°¡ ³¯ °æ¿ì¿¡´Â desc db;¸í·ÉÀ» »ç¿ëÇÏ¿© TypeÀÌ enum('N','Y')ÀÎ Ä®·³ ¼ö¿¡ ¸Â°Ô 'y'ÀÇ °¹¼ö¸¦ Á¶Á¤ÇÑ´Ù.
{{{#>/usr/local/mysql/bin/mysql -u KTUG -p TeXObGyDic
mysql>create table ObGyDic_main (
mysql>create table Admission_ObGyDic (
1. ±âÁ¸ÀÇ OpenOffice.calc·Î ¸¸µé¾îÁø data¸¦ mySQL·Î Áý¾î³Ö±â.
* ¿ì¼± openoffice¿¡¼ csvÀúÀå(field±¸ºÐÀº ;·Î ÇÏ°í ³ÈÄ¿¡ )-> mysql¿¡¼ load data infile './test.csv' into table test_table fields terminated by ';' (.....);
* openoffice->excel->access->ODBC->mySQL
* openoffice¿¡¼ csv·Î ÀúÀåÇÒ¶§µµ ±×·¸°í mySQL¿¡ Áý¾î³ÖÀ»¶§µµ ±×·¸°í \´Â ¹«½Ã¸¦ ÇÏ´Â °Í °°½À´Ï´Ù. ±×·¡¼ ¾î¿¼ö ¾øÀÌ \\Áý¾î ³Ö°í ÇÏ´Ï ¿øÇÏ´Â °á°ú´Â ³ª¿À´Â ±º¿ä.
* mySQL¿¡ µé¾î ÀÖ´Â dataÁß¿¡¼ \commandµÈ ºÎºÐÀ» ÀûÀýÈ÷ htmlÈ Çϱâ
*mySQLÀÇ dataµéÀº Á÷Á¢ TeX·Î Á÷Á¢ »Ì¾Æ¾²±â À§Çؼ ¸î°¡Áö ¸í·É¹®ÀÌ µé¾î°¡ ÀÖ´Ù. ¸í·É¹®ÀÇ Á¾·ù·Î´Â - PerlTeX . . . . 3 matches
º» ¿¹Á¦´Â DB(MySQL)¿¡ ÀúÀåµÇ¾î ÀÖ´Â ¼öÄ¡ µ¥ÀÌÅ͸¦ Perl·Î ÃßÃâÇÏ¿© À̸¦ PSTricks¸¦
ÀÏ´Ü, localhost¿¡ MySQLÀÌ ¼³Ä¡ µÇ¾î ÀÖ´Ù°í °¡Á¤ÇÏ°í,
% mysql -h localhost -p -u root
mysql> GRANT ALL ON perltexdb.* TO 'ptuser'@'localhost' IDENTIFIED BY 'ptpass';
mysql> CREATE DATABASE perltexdb;
mysql> quit
% mysql -h localhost -p -u ptuser
mysql> USE perltexdb;
mysql> CREATE TABLE perfdata (num INT, value FLOAT);
mysql> INSERT INTO perfdata (num,value) VALUES(1, 10.21);
mysql> INSERT INTO perfdata (num,value) VALUES(2, 20.22);
mysql> INSERT INTO perfdata (num,value) VALUES(3, 30.23);
mysql> INSERT INTO perfdata (num,value) VALUES(4, 40.24);
mysql> INSERT INTO perfdata (num,value) VALUES(5, 50.25);
mysql> INSERT INTO perfdata (num,value) VALUES(6, 52.24);
mysql> INSERT INTO perfdata (num,value) VALUES(7, 30.23);
mysql> INSERT INTO perfdata (num,value) VALUES(8, 20.22);
mysql> INSERT INTO perfdata (num,value) VALUES(9, 10.21);
mysql> INSERT INTO perfdata (num,value) VALUES(10, 8.18);
# connect.pl - connect to the MySQL server