SELECT order_id,product_name,qty FROM ordersse pueden usar modificadores para alterar el comportamiento al guardar:
INTO OUTFILE '/tmp/orders.txt'
SELECT order_id,product_name,qty FROM orders
INTO OUTFILE '/tmp/orders.csv'
FIELDS TERMINATED BY ','
ENCLOSED BY '"'
LINES TERMINATED BY '\n'
<meta charset="utf-8">
var myObjetoJson = <?php echo json_encode($myObjeto)?>y ya sale andando como piña.
jQuery.each(array_de_datos, function(clave, valor){ /* lógica */ });array_de_datos, coleccion de objetos json o datos
header("Content-type: application/csv"); header("Content-Disposition: attachment; filename=NOMBRE_ARCHIVO.csv"); header("Pragma: no-cache"); header("Expires: 0"); echo "registro1,registro2,etc...\n";
<?php
ignore_user_abort(1); // run script in background
set_time_limit(0); // run script forever
$interval=60*15; // do every 15 minutes...
do{
// add the script that has to be ran every 15 minutes here
// ...
sleep($interval); // wait 15 minutes
}while(true);
?>
$ nohup --help Modo de empleo: nohup ORDEN [ARGUMENTO]... o bien: nohup OPCIÓN Ejecuta ORDEN, descartando las señales de colgar. --help muestra esta ayuda y finaliza --version informa de la versión y finalizasi la entrada estándar es una terminal, redirigirla desde /dev/null. si la salida estándar es una terminal, añadir la salida a `nohup.out` si es posible, en caso contrario a `$HOME/nohup.out`. si los errores van a una terminal, redirigirlos a la salida estándar. Para guardar la salida a FILE, use `nohup COMMAND > FILE`
$ ssh -p puerto usuario@ipservidoreso es todo, ya estamos logueados en el servidor
RewriteEngine on RewriteCond $1 !^(index.php|css|js|images|robots.txt) RewriteRule ^(.*)$ nombreDeLaCarpetaDondeEstaElFramework/index.php/$1 [L]despues editar el config.php de codeigniter:
$config['index_page'] = ''; //$config['index_page'] = 'index.php';
mkvextract tracks archivo.mkv 1:video.avi 2:audio.mp3 avimerge -i video.avi -p audio.mp3 -o archivo.aviluego de esto toca convertir a dvd propiamente dicho
sudo mkdir /media/NOMBRE
sudo chown -R username:username /media/NOMBRE/Paso 3: abrir gparted, localizar la partición y anotarse el sistema de archivos utilizado
sudo gedit /etc/fstab
/dev/sda5 /media/NOMBRE ext4 defaults 0 0
sudo mount -a
sudo add-apt-repository ppa:jd-team/jdownloader
sudo apt-get update
sudo apt-get install jdownloader
sudo apt-get install apache2 mysql-server php5
sudo cp cake_1.2.1.8004.tar.bz2 /var/www/ cd /var/www sudo tar -xvf cake_1.2.1.8004.tar.bz2 sudo mv cake_1.2.1.8004 cakephp
sudo chmod -R 777 cakephp/app/tmp
sudo a2enmod rewrite
sudo vim /etc/apache2/sites-enabled/000-default
<Directory /var/www/> Options Indexes FollowSymLinks MultiViews AllowOverride None Order allow,deny allow from all </Directory>
<Directory /var/www/> Options Indexes FollowSymLinks MultiViews AllowOverride All Order allow,deny allow from all </Directory>
sudo /etc/init.d/apache2 restart
create or replace function puntoC()
returns trigger as $$
begin
if (old.x::integer%2= 0) then
update multiplos_2 set funcion_1 = round((3 * old.x) - 4, 2),
funcion_2 = round((3 * (old.x ^3)) - 5/2, 2),
funcion_3 = round((old.x / 3) * (-1) + 12, 2)
where multiplos_2.x = old.x
;
end if;
if (old.x%3= 0) then
update multiplos_3 set funcion_1 = round((3 * old.x) - 4, 2),
funcion_2 = round((3 * (old.x ^3)) - 5/2, 2),
funcion_3 = round((old.x / 3) * (-1) + 12, 2)
where multiplos_3.x = old.x
;
end if;
if (old.x%7= 0) then
update multiplos_7 set funcion_1 = round((3 * old.x) - 4, 2),
funcion_2 = round((3 * (old.x ^3)) - 5/2, 2),
funcion_3 = round((old.x / 3) * (-1) + 12, 2)
where multiplos_7.x = old.x
;
end if;
return old;
end;
$$
language plpgsql;
create trigger tg_puntoC
before delete
on funciones
for each row execute procedure puntoC();
mysql> delimiter $$
mysql> create function Validar(u varchar(30), p varchar(30))
-> returns int
-> begin
-> declare retorno int;
-> select count(user) into retorno from _saraza
-> where user = u and pass = sha1(p);
-> return retorno;
-> end;
-> $$
select Validar('usuario', 'password');
CREATE TABLE _discos2012 LIKE discos;
INSERT INTO _discos2012 SELECT * FROM discos;
import java.sql.*;import java.util.ArrayList;
import java.util.logging.Level;
import java.util.logging.Logger;
public class DB {
private Connection cn;
private Statement st;
private ResultSet rs;
public DB(){
try {
Class.forName("com.mysql.jdbc.Driver");
} catch (ClassNotFoundException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public void conectar(){
try {
this.cn = DriverManager.getConnection("jdbc:mysql://localhost:3306/dvd", "root", "");
this.st = cn.createStatement();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public void desconectar(){
try {
this.st.close();
this.cn.close();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public synchronized int getCount(String tabla){
int tmp = 0;
try {
this.conectar();
rs = st.executeQuery("select count(*) from "+ tabla);
if(rs.first()){
tmp = rs.getInt(1);
}
this.desconectar();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
return tmp;
}
public void limpiarBase(){
try {
this.conectar();
this.st.executeUpdate("truncate table dvd");
this.desconectar();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
}
public void setNuevoDvd(dvd D){
}
public ArrayList getFromDb(String consulta){
ArrayList tmpReturn = new ArrayList();
try {
this.conectar();
this.rs = this.st.executeQuery(consulta);
while(rs.next()){
ArrayList tmpFila = new ArrayList();
for(int i = 1; i <= rs.getMetaData().getColumnCount(); i++){
tmpFila.add(rs.getObject(i));
}
tmpReturn.add(tmpFila);
}
this.desconectar();
} catch (SQLException ex) {
Logger.getLogger(DB.class.getName()).log(Level.SEVERE, null, ex);
}
return tmpReturn;
}
private void setDvdToDb(){
}
}
$ sudo mkdosfs -I -n "popopo" /dev/sdb
~>$sudo gedit /etc/php5/apache2/php.ini
* Restarting web server apache2
apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
... waiting apache2: Could not reliably determine the server's fully qualified domain name, using 127.0.1.1 for ServerName
[ OK ]
~>$sudo /etc/init.d/apache2 restart
sudo gedit /etc/pulse/daemon.conf
#############################################################################
# This file is part of PulseAudio.
#
# PulseAudio is free software; you can redistribute it and/or modify
# it under the terms of the GNU Lesser General Public License as published by
# the Free Software Foundation; either version 2 of the License, or
# (at your option) any later version.
#
# PulseAudio is distributed in the hope that it will be useful, but
# WITHOUT ANY WARRANTY; without even the implied warranty of
# MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU
# General Public License for more details.
#
# You should have received a copy of the GNU Lesser General Public License
# along with PulseAudio; if not, write to the Free Software
# Foundation, Inc., 59 Temple Place, Suite 330, Boston, MA 02111-1307
# USA.
## Configuration file for the PulseAudio daemon. See pulse-daemon.conf(5) for
## more information. Default values are commented out. Use either ; or # for
## commenting.
; daemonize = no
; fail = yes
; allow-module-loading = yes
; allow-exit = yes
; use-pid-file = yes
; system-instance = no
; local-server-type = user
; enable-shm = yes
; shm-size-bytes = 0 # setting this 0 will use the system-default, usually 64 MiB
; lock-memory = no
; cpu-limit = no
; high-priority = yes
; nice-level = -11
; realtime-scheduling = yes
; realtime-priority = 5
; exit-idle-time = 20
; scache-idle-time = 20
; dl-search-path = (depends on architecture)
; load-default-script-file = yes
; default-script-file = /etc/pulse/default.pa
; log-target = auto
; log-level = notice
; log-meta = no
; log-time = no
; log-backtrace = 0
resample-method = speex-float-1
; enable-remixing = yes
enable-lfe-remixing = yes
flat-volumes = no
; rlimit-fsize = -1
; rlimit-data = -1
; rlimit-stack = -1
; rlimit-core = -1
; rlimit-as = -1
; rlimit-rss = -1
; rlimit-nproc = -1
; rlimit-nofile = 256
; rlimit-memlock = -1
; rlimit-locks = -1
; rlimit-sigpending = -1
; rlimit-msgqueue = -1
; rlimit-nice = 31
; rlimit-rtprio = 9
; rlimit-rttime = 1000000
; default-sample-format = s16le
default-sample-rate = 48000
default-sample-channels = 6
; default-channel-map = front-left,front-right
default-fragments = 8
default-fragment-size-msec = 10
; enable-deferred-volume = yes
deferred-volume-safety-margin-usec = 1
; deferred-volume-extra-delay-usec = 0
[Test]
public void CrearCuenta(){
MockRepository Mock = new MockRepository();
IservicioFinanciero servicioMock = Mock.StrictMock<IservicioFinanciero>();
servicioMock.Expect(x=>x.VerificarCrearCuenta(10)).Return(true);
Mock.ReplayAll();
Cuenta cuenta = new Cuenta(servicioMock);
Cuenta.AbrirCuenta(10);
servicioMock.VerifyAll.Expectations();
}
public bool AbrirCuenta(int dni){
servicioFinanciero.VerificarCuenta(dni);
}
Tecleamos 'cmd' En la ventana de consola que nos aparece:
Diskpart
List Disk (mostramos las unidades..)
Select Disk 1 ( Sustituir el 1 con el número que refleje su unidad USB, asegúrate antes de seguir de que el número es correcto o podrías eliminar la información de tu disco duro)
clean
create partition primary
active
format fs=fat32 quick
assign
exit
xcopy d:\*.* /s/e/f e:\d: es tu unidad de CD con el windows7 e: es el usb
mysql> load data local infile 'c:/ruta/al/archivo.txt'
-> into table diseases
-> fields terminated by '$$'
-> lines terminated by '\n';
Query OK, 500 rows affected (0.05 sec)
Records: 500 Deleted: 0 Skipped: 0 Warnings: 0
VPI: 8
VCI: 35
NAT: SUA ONLY
ENCAPSULAMIENTO: PPPOE;
PPPOE : LLC. (Y COMPLETAN EL USER Y PASS QUE CORRESPONDA)
DEFAULT ROUTE: YES
ADSL MODE: ADSL2
ADSL TYPE: ANNEX A/L
BITSWAP ENABLE
SRA ENABLE
select sum(quantityinstock), productlines.productline from products inner join
productlines on products.productline = productlines.productline group by
productlines.productline;
select productname, sum(quantityOrdered) from orderdetails o inner join products p on
p.productcode = o.productcode group by o.productcode order by sum(quantityOrdered) desc
limit 1;
select productline, avg(suma) from
(select productline, o.productcode, sum(quantityordered) as suma
from products p
inner join orderdetails o
on p.productcode = o.productcode
group by o.productcode) as tt
group by productline;
select c.customername
from customers c
inner join payments p
on c.customernumber = p.customernumber
where p.amount > 25000
group by c.customername
select SO.customername
from
(select c.customername, sum(od.quantityordered * od.priceeach) as total_ordenado
from customers c
inner join orders o
on o.customernumber = c.customernumber
inner join orderdetails od
on od.ordernumber = o.ordernumber
group by c.customername) as SO
inner join
(select c.customername, sum(p.amount) as total_pagado
from customers c
inner join payments p
on c.customernumber = p.customernumber
group by c.customername) as SP
on SO.customername = SP.customername
where SO.total_ordenado > SP.total_pagado
select sum(od.quantityordered * od.priceeach) as monto_ordenes_canceladas
from orders o
inner join orderdetails od
on o.ordernumber = od.ordernumber
where o.status = 'cancelled'
