| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17
Comments:
<0> I count 4 too
<1> 2 open, 2 close
<1> the closers are the simple cases
<0> agreed
<0> 2 open 2 close
<2> Xgc, but that is what defines the uniqueness in the table , user1 is not enough.. and there should be no duplicate entries, have i understood it right?
<3> lofe: Ah. Sorry. Misunderstood your question. Answer: It's fine both ways. Some people prefer a separate generated id. Some don't.
<2> ok, thanks
<1> ikonia I performed a more involved test
<1> seems to be cleaning only font tags and leaving all else
<0> really ?
<0> I can't get it to even clear the font tags
<1> update test set content = concat(
<1> left(content,@pos:=locate('<font',content)-1),
<1> right(content,length(content)-locate('>',content,@pos)));
<0> ok
<0> lets try
<1> cleans only one tag each iteration
<0> changed = 0
<0> failed again on my db
<1> I set up several rows containing 0 1 or 2 font tags, some with other tags
<0> bobfield FYI: thanks for the time your taking on this
<0> let me take a dump of that table
<0> and give it to you
<0> so you have exactly the same data
<1> okay
<0> as the data looks different in the db than it does then its rendered
<1> perhaps we both learn something here
<0> http://testsite.ff1600.co.uk/ikonia_demo_tables.dump.bz2
<0> thats a dump of the tables I'm using (not the whole db - just the table for this test)
<0> bobfield I'm learning a lot already here
<4> how can i remove a mysql user?
<5> I have just installed mysql on my Ubuntu-running computer. I get an error "Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' The file referenced in the error does not exist.
<6> hello there, on one server, we are still using myisam DBs. When I only have the .bins as backups, can I "use" them somehow?
<5> It turns out the database was not started properly.
<7> ndee_ if those bin files go back to when the tables were created, yeah
<1> ikonia, got your data, testing it, see it's not working, scratching my head
<0> well thats a start ;o)
<1> update cms_site_content set content = concat( left(content,@pos:=(locate('<font',content)-1)), right(content,length(content)-locate('>',content,@pos+1)));
<1> couple of minor tweaks
<1> think I nailed it
<8> is it just me, or is ENUM / SET not really useful ?
<8> since you can't get the ENUM / SET values, it's actually very useless, or?
<0> rats can you stick in the pastebin I've just cleared my screen by acciden tlike a fool
<8> and it doesn't encourage normalization
<1> update cms_site_content set content = concat( left(content,@pos:=(locate('<font',content)-1)), right(content,length(content)-locate('>',content,@pos+1)));
<0> testing
<0> 887 changed
<0> looks better
<1> it had been locking onto the > of the previous tag
<1> my simple test had text surronding the tags
<0> bobfield cracking start
<0> stripped 1 <font>
<0> so if I run it again
<0> lets see if it gets rid of the second
<1> :nods
<0> 860 rows
<0> its slowly decreasing
<1> I'm still iteratively testing here
<9> is there a string function that can prepend strings at the beginning?
<1> down to 606 rows now
<0> cool
<0> bobfield nice job
<1> ronn try concat()
<10> I don't suppose this has illustrated one of the inflexibilities of keeping your pages in the database yet, instead on the filesystem in templates, has it?
<1> thanks
<0> infi in a big way
<0> its like this because of a problem with the initial release
<10> performance is another major one.
<0> which should now be fixed
<0> but a year has gone by
<0> so the records are too many to retro fit
<9> bobfield: can concat lets you join the string from the beginning? left ?
<1> ronn give me a better idea of what you want
<9> bobfield: what i want to do is prepend "CH" to all fields in the column
<1> update table1 set field=concat('CH',field)
<9> bobfield: thanks a lot.
<0> 512 rows.....left
<1> still running it here too
<1> 558 changed last run
<11> Hello
<11> I am a MySQL newbie
<0> bobfield this is an excellent solution
<11> Is it possible to preform a SQL query where I can take the row where a column named "id" is the greatest number?
<0> more than acceptable to use on the produciton site once I've tested the cms
<1> I'm glad, hope it gets the job done for you
<0> well, it certainly seems to set the test db up correctly
<0> 440 left to go
<0> so I'll know shortly
<1> going faster on your end
<0> yeah
<1> my laptop just doesn't have the horsepower
<0> ahh this box isn't doing much
<0> and its a dual cpu
<0> so its pretty nippy
<11> Help please?
<0> even if it is a tad old
<1> ShuaiKing, select * from table1 order by id desc limit 1;
<11> Where * is?
<11> I'm sorry
<11> I'm new to this.
<1> * selects all fields in your table
<11> Oh
<12> Hi
<11> so if I'm using PHP... how can I store that to a variable $id?
<12> I try to start MySQL with: /opt/mysql/bin/mysqld_safe --user=mysql --basedir=/opt/mysql --datadir=/var/mysql_data &
<12> But then I've got this error: The file /usr/local/mysql/bin/mysqld doesn't exist or is not executable
<12> Why mysqld_safe is looking for mysqld in /usr/local/mysql/bin while I specify that the basedir is /opt/mysql ??
<13> Can a varchar be ORDERED BY and treated like an int+
<13> ?
<1> ShuaiKing, http://pastebin.com/574046
<11> bobfield: thanks!
<0> bobfield does your job involve mysql
<0> you seem very ontop of i
<1> no but it should
<0> clearly
<14> Anywhere here ever use the Debian package of the JDBC connector? I keep getting Cl***NotFoundException regardless how how I put mysql.jar and/or mysql-3.1.11.jar into my javac CL***PATH environment or on via the command line with -cp or -cl***path
<0> what do you use mysql for then to be as involved as you are ?
<14> Terr1: anyONE here ever use ...
<1> Well actually I only started using MySQL last fall.
<1> I've used other databases before
<0> I ***ume you use other DB's such as oracle/sybase
<0> on a regular basis
<1> access, RDB/VMS
<11> Hi
<0> urghh
<0> surprising
<11> In PhpMyAdmin, what does "number of fields" mean?
<1> well I've been pigeonholed in the VMS world for years, trying to branch out
<10> pretty, pretty VAXen
<1> I cut my teeth on PDPs
<10> doesn't that leave marks on the front panel?
<1> learned Fortran in the 3rd grade
<14> I've tried Cl***.forName ("org.gjt.mm.mysql.Driver"); and Cl***.forName ("com.mysql.jdbc.Driver");
<10> I was still on Apple //e BASIC in 3rd grade :{
<10> but at least I graduated from my TRS-80 by then.
<1> I should have gone the unix road long ago
<1> well I'm new school but catching up fast
<0> I'd be happy to return the favour if you get stuck
<1> big slackware fan here
<0> interesting choice
<1> installing things by brute force appeals to me
<0> 188 rows left
<1> I've been trying to sort out a huge database of GPS coordinates
<1> 1.18 million rows
<0> on what platform
<1> windows as well as slack
<0> what database platform ?
Return to
#mysql
or
Go to some related
logs:
#gentoo
#debian
#debian
#perl
qpsmtpd smtproutes
#linux
#css
lactophilia+pics
ubuntu zd1211 unreachable
#linux
|
|