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 |