· 10 years ago · Sep 15, 2016, 03:52 PM
1<!DOCTYPE html>
2<html>
3<body>
4
5<?php
6require 'conexion2.php';
7
8$sql = "CREATE TABLE IF NOT EXISTS Cursos
9(
10id int(6),
11Departamento varchar(255)
12);";
13
14$result = $conn->query($sql);
15
16if ($result === TRUE) {
17 echo "exito\n";
18} else {
19 echo "Error: " . $sql . "<br>" . $conn->error;
20}
21 $sql2= "UPDATE Cursos
22 JOIN materias_siu_1ro16
23 SET id = materias_siu_1ro16.id
24 WHERE 1;";
25
26
27 $result = $conn->query($sql2);
28
29 if ($result !== TRUE) {
30 echo "Error: " . $sql . "<br>" . $conn->error;
31 }
32
33 $sql2
34
35
36
37$conn->close();
38?>
39</body>
40</html>