Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- -- 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>
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement