| Zombie | Does anyone know how to select a specific string like, 'and' |
| Chaotic_Descent | how can I understand how normalization applies to my database? I can't seem to answer my own questions on how to lay things out. I typed up this question earlier: if a figure, products containing figures, and a case assortment containing products can all be classified as being under a specific toyline, but the figure's name isn't unique, and most commonly can be differentiated by a combination of the name and toyline, do you include the toyline in the table with the figure? |
| Zombie | SELECT `PUBLISHER`.`PUBLISHER_NAME` FROM PUBLISHER WHERE (`PUBLISHER`.`PUBLISHER_NAME` LIKE 'and') This returns a null set. |
| _syphilis_ | maybe you meant '%and%' |
| katami | ALTER TABLE Person ADD City date(yyyymmdd) is that right? |
| thumbs | you can specify AFTER COLUMN_NAME |
| katami | ? i just need to know about date if I add that column, do the dates need to be put in in the same order or what |
| thumbs | datetime should be sufficient why do you need a custom date storate format, exactly? |
| katami | I don't really need a custom |
| thumbs | then datetime will suffice |
| katami | I just need the column to be set to a certain type |
| thumbs | then datetime will suffice |
| katami | wtf |
| the_wench | Profanity is the inevitable linguistic crutch of the inarticulate blockhead |
| katami | datetime isn't an option |
| Stettin | quick q.. do all inserted values have to be surrounded by single quotes, or just non-numeric values? |
| _syphilis_ | Stettin: the latter |
| Stettin | thanks |
| Zombie | Does anyone know how to make SQL Count? That is to say. Lets say I have a Query where there are 4 Records that match the Criteria I want. |
| thumbs | count(ID) |
| aleff | caotic http://archives.neohapsis.com/archives/mysql/2005-q2/2801.html this is exactly my problem i would like to use order by, before group by but mysql dont let me do that |
| Chaotic_Descent | Hrm? I don't recognize the similarity. |
| thumbs | order always goes after group |
| aleff | that's my problem :) |
| thumbs | in any SQL engine |