#mysql - Wed 14 Mar 2007 between 00:06 and 00:27

NY Lost Funds



phantomcircuitIf i do CREATE TABLE copy (tested BOOLEAN) SELECT * FROM master;
mistergibsonhello all
phantomcircuitone of the fields in master is unique
would the copyied table inherit the unique attribute from the select?
mistergibsonhow do I store a var into a table fleld? select var1 into catalog.table.field?
kimseongmistergibson: update
mistergibsonthe manual pages seem a big vague on the subject of select ... into
update, thanks :)
davockhey
i have a problem to conect php aplications with mysql
always appear things like "error establishing database connection"
but from a local console i can connect me to the database
seekwilldavock, You'll need the message from mysql_error()
EvolutionI'm looking for some documentation on password protecting specific fields or rows within a db but I'm not using the proper google-fu.
I thought I had it bookmarked, but I was mistaken
seekwill!m Evolution encryption
the_wenchEvolution see http://dev.mysql.com/doc/refman/5.0/en/secure-basics.html
seekwillUgh
!m Evolution sha
the_wenchEvolution see http://dev.mysql.com/doc/refman/5.0/en/encryption-functions.html
davockseekwill : how i can extract the message from mysql_error()
seekwillecho mysql_error()
;
Evolutionthat's the one.
phantomcircuityeah i checked the manual before i asked :P
mistergibson: if you were wondering the unique attribute isnt copied
mistergibson??
ok
kimseongphantomcircuit: the table is created based on the result of the select
mistergibsonI'm not that far along in my syntax lessons I think
on an INSERT INTO (table): can I specify which fields the 'VALUES' are padded into?
kimseong!man insert
the_wenchsee http://dev.mysql.com/doc/refman/5.0/en/insert.html
mistergibsonI'm reading the manual online actually
kimseongthen you should ind the answer there
find
mistergibsonyeah, found where I went wrong in the manual browse ... thanks all
ramza3how do you load a mysql script at the mysql client
seekwillSOURCE file.sql
ramza3right

Page: 2 9 16 23 30 37 44 51 58 

IrcArchive

NY Lost Funds