|Shaba2||guys what is the differnece between DROP and DELETE?|
|jbalint||!man drop table|
|henriquev||jbalint: ok. Would you recommend me not to use the following? If so, for what reason? SET @rownum :=0; SELECT * , @rownum := @rownum +1 AS position FROM table...? (take note that I'm using an unique field there)|
|Shaba2||hold on I am still reading it|
|jbalint||henriquev: nothing i know causes an issue with that. why do you need it?|
|joeedh||hi I'm getting an odd error on trying to insert into a table. The query and error string/number are at http://rafb.net/p/zQDW2x42.html|
|mycpuisnuralnet||is there a way just to drop all indexes?|
|joeedh||eh small typo in the paste, use http://rafb.net/p/63mF5c78.html instead|
|henriquev||jbalint: I can't use the int auto incremented value to get the position of the element as it's indepedent of another quantity that determines either if the given unique element makes part of a set of elements or not (there are many sets). And I need to get its position so that I can call 'what is next to it'...|
jbalint: well, it's a complicated thing...
|mycpuisnuralnet||try INSERT INTO `jje27_customers`|
joeedh, INSERT INTO 'jje27_customers'
|jbalint||joeedh: right. single quotes are string literals, not identifiers|
|threnody||joeedh: don't singlequote tablename|
|jbalint||henriquev: heh. ok.|
|joeedh||odd. the mysql manual seemed to say otherwise. oh well I'll ignore that.|
|mycpuisnuralnet||is there a DROP ALL INDEXES on table blah ??|
|joeedh||ok tried no quotes on table name, same error|
|mycpuisnuralnet||an easy way to do that|
|jbalint||joeedh: where in the manual?|
joeedh: dont quote the field names, they are identifiers also
|action||joeedh notes, never ever trush phpmyadmin's example query code|
|joeedh||notes, never ever trush phpmyadmin's example query code|
|jbalint||select 'a',a from tbl <--- 'a' is a literal, a is a field name for mtbl|
|jbalint||joeedh: lemme look|
|action||joeedh likely is just confused while reading that, or something.|
|joeedh||likely is just confused while reading that, or something.|
|jbalint||joeedh: thats.... uh.... not really about quoting identifiers|
|joeedh||as I said, I'm probably just a little confused :)|
http://rafb.net/p/zI9qMa32.html new error.
odd. surely it's not complaining because of the quotes around the values?
or is it the space.
|action||joeedh tries removing it|
|joeedh||tries removing it|