Informazioni aggiuntive

• Struttura query: INSERT INTO nome_tabella [ ( elenco_campi ) ] VALUES ( elenco_valori )
• Query di esempio:

  INSERT INTO Person VALUES ( 1, 'Agosti', 'Maristella' ); // Tutti i valori

  INSERT INTO Institution ( ID, name, city, country ) VALUES ( 1, '7th IFIP 2.6 Working Conference on Database Semantics (DS-7)','Leysin', 'Switzerland' ); // Solo quelli dei campi indicati

  INSERT INTO jos_mycom_users (idjusers, username, firstname) SELECT id, username, name FROM jos_users where gid25 AND !EXISTS (SELECT 1 FROM jos_users a, jos_mycom_users b WHERE a.id = b.idjusers)

  o meglio:

  INSERT INTO #__mycom_users (idjusers, username, firstname) select id, username, name from jos_users where gid 25 AND id NOT IN (SELECT a.id FROM jos_users a INNER JOIN jos_mycom_users b ON a.id = b.idjusers)