Mots-clés
BDSP5 Thésaurus > Profession sanitaire & sociale
Profession sanitaire & socialeSynonyme(s)Personnel sanitaire et social Professions sanitaires et sociales |
Documents disponibles dans cette catégorie (21581)
ALTER TABLE tri_tempo_1 ADD tbdate_parution varchar(255)
The table 'tri_tempo_1' is full
CREATE TEMPORARY TABLE tri_tempo_1_update(notice_id INT NOT NULL, tbdate_parution varchar(255) not null default '') ENGINE=memory (SELECT notices.notice_id, SUBSTRING(date_parution, 1, 255) AS tbdate_parution FROM tri_tempo_1 LEFT JOIN notices ON (notices.notice_id = tri_tempo_1.notice_id))
The table 'tri_tempo_1_update' is full
ALTER TABLE tri_tempo_1_update ADD INDEX (notice_id)
Table 'sigb.tri_tempo_1_update' doesn't exist
UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbdate_parution = tri_tempo_1_update.tbdate_parution WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbdate_parution IS NOT NULL AND tri_tempo_1_update.tbdate_parution != ''
Table 'sigb.tri_tempo_1_update' doesn't exist
ALTER TABLE tri_tempo_1 ADD tbtitle varchar(255)
The table 'tri_tempo_1' is full
ALTER TABLE tri_tempo_1_update ADD INDEX (notice_id)
The table 'tri_tempo_1_update' is full
UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbtitle = tri_tempo_1_update.tbtitle WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbtitle IS NOT NULL AND tri_tempo_1_update.tbtitle != ''
Unknown column 'tri_tempo_1.tbtitle' in 'field list'
UPDATE notices, tri_tempo_1, tri_tempo_1_update SET tri_tempo_1.tbtitle = tri_tempo_1_update.tbtitle WHERE tri_tempo_1.notice_id=tri_tempo_1_update.notice_id AND notices.notice_id=tri_tempo_1.notice_id AND tri_tempo_1_update.tbtitle IS NOT NULL AND tri_tempo_1_update.tbtitle != ''
Unknown column 'tri_tempo_1.tbtitle' in 'field list'
ALTER TABLE tri_tempo_1 ORDER BY tbdate_parution DESC,tbtitle ASC
Unknown column 'tbdate_parution' in 'order clause'
SELECT * FROM tri_tempo_1 ORDER BY tbdate_parution DESC,tbtitle ASC LIMIT 30,15
Unknown column 'tbdate_parution' in 'order clause'