tablas bootstrap responsive sql server para datos vivos <table class=”table table-responsive table-hover”>Â Â <thead>Â Â Â Â <tr>Â Â Â Â Â Â <th>First Name</th>Â Â Â Â Â Â <th>Last Name</th>Â Â Â Â Â Â <th>Email</th>Â Â Â Â </tr>Â Â </thead>Â Â <tbody>Â Â Â Â <tr>Â Â Â Â Â Â […]
sqlalchemy unique pair of columns # version1: table definition mytable = Table(‘mytable’, meta, # … Column(‘customer_id’, Integer, ForeignKey(‘customers.customer_id’)), Column(‘location_code’, Unicode(10)), UniqueConstraint(‘customer_id’, ‘location_code’, name=’uix_1′) ) # or the index, which will ensure uniqueness as well Index(‘myindex’, mytable.c.customer_id, mytable.c.location_code, unique=True) # version2: declarative class Location(Base): __tablename__ = ‘locations’ id = Column(Integer, primary_key = True) customer_id = Column(Integer, […]
sqlalchemy get schema from database from sqlalchemy import MetaData, create_engine CONN = create_engine(DB_URL, client_encoding=”UTF-8″) META_DATA = MetaData(bind=CONN, reflect=True) USERS_TABLE = META_DATA.tables[‘users’]
sql skip the first row SELECT * FROM table WHERE something = ‘whatever’ LIMIT 10 OFFSET 1; ms sql skip take SELECT col1, col2, … FROM … WHERE … ORDER BY — this is a MUST there must be ORDER BY statement — the paging comes here OFFSET 10 ROWS — skip 10 rows FETCH […]
sql server results to comma delimited string DECLARE @csv VARCHAR(MAX) SELECT @csv = COALESCE(@csv + ‘,’ ,”) + book_title from Test.dbo.Books where book_id IN ( 101, 102, 103); SELECT @csv Output Head First SQL, SQL Puzzler, T-SQL Fundamentals
sql server drop temp table if exists IF OBJECT_ID(‘tempdb..#Results’) IS NOT NULL DROP TABLE #Results GO
sql join 3 tables SELECT column-names FROM table-name1 JOIN table-name2 ON column-name1 = column-name2 WHERE condition sql join 3 tables SELECT s.studentname , s.studentid , s.studentdesc , h.hallname FROM students s INNER JOIN hallprefs hp on s.studentid = hp.studentid INNER JOIN halls h on hp.hallid = h.hallid
sql insert into node js var mysql = require(‘mysql’); var con = mysql.createConnection({ Â host: “localhost”, Â user: “yourusername”, Â password: “yourpassword”, Â database: “mydb” }); con.connect(function(err) { Â if (err) throw err; Â console.log(“Connected!”); Â var sql = “INSERT INTO customers (name, address) VALUES (‘Company Inc’, ‘Highway 37’)”; Â con.query(sql, function (err, result) { […]
sql column contains special character SELECT Col1 FROM TABLE WHERE Col1 like ‘%[^a-Z0-9]%’
wearedevs exploit api –WEAREDEVS IS NOT SAFE GUYS, THE EXPLOIT API MIGHT BE SAFE BUT IDK. DON’T USE WEAREDEVS –I AM A DEVELOPER AND NOT A HACKER BUT I REALLY WANT TO HACK ON ROBLOX –so now I am making a noob exploit for beginners for free, no adfly, linkvertise or any of that –its […]