#mysql - Sat 14 Apr 2007 between 16:10 and 16:54

NY Lost Funds



dsadsalike delete automatically all dupe by putting unique on some field.
erorr unique becaus eof duplciate found, but i heard there a way to ignore tat.
so all duplicate will be delete
toad_HarrisonF: thanks!
dsadsais there a way to force ALTER TABLE `users` ADD UNIQUE (`name` ,`id`); and ignoring duplciate key?
freepenguinexcuse me: Why can't I create more than one auto column ? must i use a different engine?
sfullenwiderIs there a way one could ssh or telnet into a mysql database from a remote machine?
SpCombmysql -h <remote machine>
archivistfreepenguin, the real question is, why you would need more than one
Tmanis it okay to do an insert, get the insert_id, and use that id as a foreign key in another insert, all in one transaction without committing until the end, without getting constraint errors?
freepenguinarchivist, because i must have 2 column auto_increment (they'll have the same value)
archivistexactly duplicated data so no need
sfullenwiderwhy would mysql allow me to use it via a web page but not at the console?
archivistdifferent grant
sfullenwidertnx
jstarcherIsn't this query wrote correct? "INSERT INTO " . TABLE_PREFIX . "user (username, usergroupid, password, passworddate, usertitle, email, salt, showvbcode, languageid, timezoneoffset, posts, joindate, lastvisit, lastactivity, options) VALUES ($edit[name], 1, $passhash, $passdate, $usertitle, $edit[email], $salt, 1, 1, $edit[timezone], 0, $joindate, $joindate, $joindate, 3415)"
sfullenwideris there a different grant for different dbs? See I have a problem, my provider wants me to move from wordpress to b2evolution, which is no problem for me, but my provider isn't that great with mysql so I need to remove my wordpress db and create a b2evolution db, what's the most secure way of doing this
?
archivistlots of php there so no
jstarcherarchivist, you are talking to me, right?
archivistyes
jstarcherarchivist, should I put the php in {}?
archivistno but echo the resultant sql and the error you get from the server
$edit[name] should be $edit['name']
etc
jstarcherarchivist, it's just a vBulletin database error "The database has encountered a problem."
yeah I had the single quotes and it didn't help
lizalo--can someone help me figure this out
can anyone hyelp me with this situation please http://pastebin.ca/440017
jstarcherlizalo, that's not even a mysql error is it?
archivistno
lizalo--hehe
no
but noeneon wants to help me
archivistprobably an empty variable causing a syntax error
lizalo--openssl genrsa -des3 -rand /etc/hosts -out smtpd.key 1024
using that ...
archivistlizalo, how are we supposed to know about that
lizalo--heh i know .. dont know ;(
jstarcherarchivist, if one is empty it will cause an error?

Page: 2 9 16 23 30 

IrcArchive

NY Lost Funds