Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- CREATE TABLE IF NOT EXISTS `temps_test` (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `sensor_serial` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
- `temp_c` float DEFAULT NULL,
- `dates` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `date` (`dates`)
- )
- foreach ($output as $k => &$v) {
- $sql = "INSERT INTO temps_test (sensor_serial,temp_c,dates) VALUES ('$v[7]','$v[3]','$v[5]') WHERE NOT EXISTS (SELECT * FROM temps_test WHERE sensor_serial='$v[7]' AND dates='$v[5]')";
- $go = mysql_query($sql) or die( mysql_error() );
- }
- INSERT INTO temps_test (sensor_serial,temp_c,dates)
- VALUES ('val1','val2','val3')
- ON DUPLICATE KEY UPDATE sensor_serial=sensor_serial;
- CREATE TABLE IF NOT EXISTS `temps_test`
- (
- `id` int(10) unsigned NOT NULL AUTO_INCREMENT,
- `sensor_serial` varchar(64) COLLATE latin1_general_ci DEFAULT NULL,
- `temp_c` float DEFAULT NULL,
- `dates` datetime DEFAULT NULL,
- PRIMARY KEY (`id`),
- KEY `date` (`dates`),
- CONSTRAINT t_uq INIQUE (`sensor_serial`) -- <== this one
- )
Add Comment
Please, Sign In to add comment