Untitled

a guest

Dec 1st, 2019

163

Never

Add comment

Not a member of Pastebin yet? Sign Up, it unlocks many cool features!

text 3.71 KB | None | 0 0

raw download clone embed print report

-- Commento
mysql -h contabile.fermi.intra -u s01518 -p
show databases;
use nomedb;
show tables;
select * from nometabella;
select * from nometabella where campo='qualcosa'
source file.sql;
create table nome (Attributo tipo(grandezza));
DESCRIBE nometabella;
drop table nometabella1, nometabella2;
INSERT INTO nometabella VALUES ('Apici per i char', 'Prova', 20);
CREATE TABLE nome
(
stringa varchar(10) default not null auto_increment primary key unique ,
num int,
data date,
FOREIGN KEY (num) references squadra(nome),
PRIMARY KEY (att, att2)
);
INSERT INTO tab (stringa, num) VALUES
('we', 3),
('we', 4);
SELECT tab.att FROM tab1, tab2 WHERE tab.att='stringa' and (tab.att=0 or tab.att=1)
messo nell'head
<script type="text/javascript">
var inp;
var inp2;
var msg = "";
function verificaForm()
{
inp = document.getElementById("nome").value;
document.getElementById("nome").value = "We";
var a = parseInt("10");
if(inp == "")
{
msg = "Attenzione! Il campo nome non puo essere vuoto";
//return false;
}
}
function Fibonacci(n)
{
var n1 = 0;
var n2 = 1;
var n3;
var i;
document.write(n1 + " " + n2);
for(i = 2; i < n; ++i)
{
n3 = n1 + n2;
document.write(" " + n3);
n1 = n2;
n2 = n3;
}
}
function Tabella()
{
var num;
var riga;
var colonna;
num = document.getElementById("val").value;
document.write("<table border=\"1\">");
for(riga = 0; riga < num; riga ++)
{
document.write("<tr>");
for (colonna = 0; colonna < num; colonna ++)
document.write("<td>cella " + riga + ", " + colonna + "</td>");
document.write("</tr>");
}
document.write("</table>");
}
</script>
<form action="" onsubmit="return verificaForm();">
<label for="telefono">Numero di telefono</label> <br>
<input type="tel" id="telefono" name="telefonocompleto" placeholder="Inserisci il tuo numero telefonico" maxlength="15"> <br>
<label for="area">Richieste particolari</label> <br>
<textarea id="area" name="areacompleta" rows="12" cols="60"></textarea> <br>
<input type="submit" value="Invia">
<input type="reset" value="Reset">
</form>
<input type="button" onclick="ciao()" value="Cliccami"> <br>
Checkbox: <input type="checkbox"> <br>
Color picker:<input type="color"> <br>
Data: <input type="date"> <br>
<input type="datetime-local"> <br>
Email:<input type="email"> <br>
<input type="file"> <br>
<input type="hidden"> <br>
<input type="image"> <br>
<input type="month"> <br>
<input type="number"> <br>
Password: <input type="password"> <br>
<input type="radio"> <br>
<input type="range"> <br>
<input type="reset"> <br>
<input type="search"> <br>
<input type="submit"> <br>
<input type="tel"> <br>
<input type="text"> <br>
<input type="time"> <br>
<input type="url"> <br>
<input type="week">
<style>
html
{
height: 100%;
}
body
{
background: linear-gradient(to top, #66ffff 0%, #ccffcc 100%);
background-repeat: no repeat;
}
.centro
{
text-align: center;
}
input[type=text], input[type=email], input[type=tel], select
{
width: 50%;
padding: 12px 20px;
margin: 8px 0;
display: inline-block;
border: 1px solid #ccc;
border-radius: 4px;
box-sizing: border-box;
}
input[type=submit], input[type=reset]
{
background-color: #ccffcc;
color: black;
padding: 14px 20px;
margin: 8px 0;
border: none;
border-radius: 4px;
cursor: pointer;
}
input[type=submit]:hover, input[type=reset]:hover
{
background-color: #33cc33;
}
div
{
border-radius: 5px;
padding: 20px;
}
</style>

Add Comment

Please, Sign In to add comment