#mysql - Thu 10 May 2007 between 00:05 and 01:14

NY Lost Funds



autopsyHow do I create a DATABASE with the MySQl client with a * in it's name?
CREATE DATABASE E*NIX;
seekwillDo you really need to do that?
Crazy!!!
`E*NIX`
axscodekimseong: what i did is just: ln -s /tmp/mysql/sock /var/run/mysql/mysql.sock
then it works fine.. then delete it again... gee..
Code-EHi, I am trying to create a mysql table and i am getting the following error:
Failed to create table : SQL create table `News` (`id` longtext(100) not null,`subject` varchar(80) not null,`wroteby` varchar(50) not null,`wrotedate` varchar(80) not null,`content` text(90000) not null) failed : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '(100) not null,`subject` varchar(80) not null,`wroteby` varchar(50) not
Why is this?
kimseong!man longtext
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/string-type-overview.html
kimseongCode-E: should not be using longtext, use varchar
autopsyseekwill, hah, so simple, thanks.
seekwillCode-E: lol. What is the difference between LONGTEXT(100) and VARCHAR(80)?
kimseonglongtext(100) fails
Code-Eum
lol
seekwillI meant, what does Code-E think the difference is...
Code-Ehow do i do a primary key on a table?
(im creating mysql table in webmin)
?
nevermind
lwizardlHi
i'm trying to learn how to link mysql tables inside a database together using id's
Axsuulhi i was wondering where are the tables kept on a mysql mac os x installation?
lwizardlI'm new to this can someone take a look at this http://pastebin.ca/480126 and help me with linking the tables together
kimseongAxsuul: show variables like 'datadir'; and you will see the path
lwizardl: linking?
lwizardlwell using joins to pull data from multiple tables and have it display as if it was in the same table
kimseonglwizardl: just write your join, the join condition in the join itself
!man join
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/join.html
lwizardlkimseong, i was told i had to use id's
kimseonglwizardl: use whatever to get your result you require
lwizardl: sometimes you get extra rows or duplicates when you don;t join on pk or unique key
lwizardl: you just need to understand join
lwizardlk
[DHX]hi
I can't find the variable that correspond to NOW(). I mean CURRENT_DATE is a variable that equals the same value as what CURDATE() returns

Page: 2 9 16 23 30 37 44 

IrcArchive

NY Lost Funds