| |
| |
| |
|
Page: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19
Comments:
<0> #1075 - Incorrect table definition; there can be only one auto column and it must be defined as a key
<1> more h4x :D
<2> Darien: a correction sorry i was alrready sending 100/sec, and was working perfect, now sending 1000/sec also all the messages were stored :D
<3> nbari: hah, awesome
<3> nbari: sounds like that fixed the problem :)
<2> yes
<2> thanks a lot :D
<3> :)
<3> glad to help :)
<3> besides, I learned a lot today too
<2> i own you 2 beers :)
<0> I have a email field and it has latin1_swedish_ci for collation
<0> it doesn't seem to want to change
<0> hi GL
<2> it is incredible how DELAYED changed the things
<2> well have to go and aply this change, bye
<4> alright sorted it out, bind-adress problem, thanks guys
<0> jiggster what is collation
<4> something to do with languages
<4> character sets
<0> right what is english
<4> well you can use utf-8 or ... i'm not sure what else exactly, there's some latin ones, and some iso ones
<5> utf-16!
<4> i havent explored collations too deeply yet at all
<0> i only see utf 8
<0> is that ok
<6> its enough normaly
<4> dg_bluesky: yeah it should be fine for most things
<0> ok cool I think I created my first table
<4> congrats :D
<6> he he
<0> now I need to learn how to put things into it
<4> i just bought a book the other day on mysql to help me catch up on all the new things being put into 4.1 and above :\
<6> always a good solution
<4> i'm not a DBMS person per-say, more of a coder, but what good is a coder without any knowledge of how to use a DBMS to it's full potential
<0> GL I have a long list of email address, can I import them all into the data if they are seperated by a ,
<6> sure
<0> really?
<3> !m dg_bluesky LOAD DATA
<7> dg_bluesky: (LOAD DATA INFILE Syntax) : http://dev.mysql.com/doc/mysql/en/LOAD_DATA.html
<4> oh man
<4> mysql administrator needs a lot of work on osx
<4> 10.4 anyways
<3> heh
<3> MySQL anything-that-isn't-a-database-server needs a lot of work on OS X
<3> I tried the MySQL Query Browser
<3> it helped me design my table, and by 'helped' I mean 'wasted my ****ing time while I tried to'
<4> yeah it's uhm... quite... interesting :P better off on the term
<0> LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table;
<0> like this
<4> i'd rather use phpmyadmin tbh
<3> and when I was done and actually made it do what I wanted, it refused to actually run (or even generate) the SQL for it, so I had to dump all my work
<3> then I picked up Workbench, generated a schema in two minutes, exported it to an SQL file, and spent 30 minutes fixing their crap
<3> dg_bluesky: not quite
<3> dg_bluesky: you need to tell it what the fields/rows are delimited by
<0> can i just import the information
<3> Workbench made an SQL file with an UNSIGNED VARCHAR
<6> bluesky it is nothing easier to erase content in a table so feel free and try it out
<3> dg_bluesky: that's what you're doing
<3> LOAD DATA INFILE 'data.txt' INTO TABLE db2.my_table LINES TERMINATED BY ',';
<3> should/might do it
<3> but it won't kill anyone so try
<6> sure? :-)
<0> i get 1064 - You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right
<3> well it won't kill *me*
<3> dg_bluesky: keep pasting
<3> 'for the right .....?'
<0> syntax to use near
<3> keep going
<1> Darien: Found some info @ microsoft on a tool called "osql" seems to be doing the job FYI
<0> myemail@email.com myemail2@email.com
<4> i recently took my powerbook in for service
<1> waiting for it to finish now
<3> dg_bluesky: so they're not comma-separated, they're space-separated
<4> they put a gouge on it and there's a hair or a scrape on the opposite side of the screen, so i'm pretty upset :P
<3> the problem with MySQL's verbose and helpful error messages is that when people copy/paste them, they inevitably truncate the part with the information that is required to help diagnose the problem
<0> i tried both
<3> SirMacius: neato
<0> i tried comma and no comma same error
<0> hey that worked , I used CVS LOAD DATA
<4> oh fer gods sake
<0> and you only need to use a space
<4> now mysql -u me -p wont work to connect locally, user's host field is set to % :P
<6> but probably your commas are in the database?
<0> GL how do I set the id back to 0
<6> wich id?
<0> i removed the data but now it has 3 4 for the field
<6> thats normal
<0> can I set it back to 0
<6> because every field is unique
<6> why?
<6> don't need
<0> I am using that field to count the clients
<6> then use a third row
<0> what would I call it
<6> the id is for the database
<6> later one you erase some ...
<6> then this number isn't correct
<6> mmh you would like to count it only?
<0> yes
<6> then you don't need a row for it
<6> later for example in php you can count the entries
<0> how do I count it
<6> and then it count only the adresses wich are already there
<6> there are php functions to count entries in a database table
<0> mysql_num_row?
<6> the auto_increment id field is for the database to select the entries
<0> oh i see cool thanks, and that doesn't need to be 0 correct
<6> yes
<0> this is working out
<4> good to hear :D
<6> for the point your wamp is grap it works fine i think
<6> he he
<4> uh
<4> ugh&
<4> ugh*
<0> lol
<0> GL working great , I have all my clients emails entered into the database
<6> nice
<0> now I would like to count the rows
<0> do I use mysql_num_rows?
<6> easiest way is to load the table with a select command then use mysql_num_rows()
<8> SELECT COUNT(id) AS the_count FROM table
<8> Then use mysql_result()
<8> Therion! YOU GRUMPY OLD FOOL!
<8> Ewww~
<8> Get a wife!
<6> thats the mysql way
<9> Got a wife
<0> the id is off though
<0> it starts at 3
<6> normal. later you erase some then it starts maybe at 1057
<6> thats not interesting
<8> It doesn't count the id
<8> SELECT COUNT(id) should count the number of non-empty id's AFAIK
<8> RIGHT THERION!?!?
<8> :P
<9> What!
<8> <8> SELECT COUNT(id) should count the number of non-empty id's AFAIK
<8> <8> RIGHT THERION!?!?
<8> RIGHT!? RIGH!?
<9> would count # of non-null values
<8> That's what I meant, fool!
<8> dg_bluesky: COUNT(id) is fast and reliable.
<8> Better than COUNT(*)
<8> I don't get why people even use SELECT * at all
<6> when you are going to use the data later on this solution is also good
<8> Hm...
Return to
#mysql
or
Go to some related
logs:
quickform dataobject -formbuilder insert()
chrot: cannot run command
g++ sudo essentials
icqsmsd
#mysql
#gentoo
debian mklivecd udev
M402U VLC
libopenal0 for ubuntu
kororaa invalid compression
|
|