GRANT ALL PRIVILEGES
ON <dbname>.*
TO <dbuser>@<dbhost>
IDENTIFIED BY '<dbpass>'
WITH GRANT OPTION;
Filter
2003-08-11
MySQL - grant
Sql
2003-08-11
Lösenord i MySQL
Mysql
set password for root@localhost = password('mittlösen');
2003-08-10
Inkludera text - om
Asp
set fso = server.createobject("scripting.filesystemobject")
set infile = fso.opentextfile(server.mappath(variabel_fil))
response.write infile.readall
infile.close
set infile = nothing
' (Endast text, ej asp-kod)
2003-08-07
Enumerator
Asp
for each var in request.servervariables
response.write(var & " = ")
response.write(request.servervariables(var) & "<br>")
next
2003-03-08
Begränsad databasfråga
Asp
Begränsa antalet poster som visas från en sql-fråga till de tio senaste inläggen i en databastabell.
<%
set conn = server.createobject("ADODB.Connection")
conn.open "SystemDSN"
sql = ”select * from tabell order by id desc”
set rs = conn.execute(sql)
antal = 0
do until rs.eof
response.write(rs(”data”) & "<br>")
antal = antal + 1
if antal > 9 then
rs.close
conn.close
else
rs.movenext
loop
rs.close
conn.close
end if
%>