-
Created BLOB to human readable?
I store "BYTE[]" type data into a BLOB. It stores it perfectly, the data being represented by hexadecimal pairs when I try to view it in MySQL. Now I want … -
Created Split database/tables across various files
We have various databases on several offsite locations and we want to do a backup to here. Problem is that database is problably going to weigh GBs of data so … -
Replied To a Post in Delete last row inserted
USE `database`; DELIMITER $$ CREATE TRIGGER `checkrow` BEFORE INSERT ON `table6` FOR EACH ROW if inserted.sha1(column1) == select sha1(column1) from table6 order by id desc limit 1 then delete inserted.column1; … -
Replied To a Post in Delete last row inserted
Best I got: USE `database`; DELIMITER $$ CREATE TRIGGER `checkrow` BEFORE INSERT ON `table6` FOR EACH ROW if inserted.column1 == select column1 from table6 order by id desc limit 1 … -
Created Delete last row inserted
In MySQL server, I want to do a trigger that checks when a row inserted, if the row has the previous value in column A than the previous row, it … -
Created See what my.cnf MySQL Server 5.6 has loaded?
I recently upgraded MySQL 5.5 to 5.6 because I needed some features but now Im not sure which my.cnf 5.6 loads... I try editing the my.cnf in /etc with some … -
Replied To a Post in Database running on SSD
> Why does the DB server have to be on the factory floor where all the vibration is occurring? And if it is a requirement for some reason, there are … -
Created Best way to prepare MySQL Server 5.6 for thousands/millions of inserts
I want to prepare MySQL Server 5.6 for thousands/millions of inserts. Ive found this: •innodb_doublewrite = 0 •innodb_buffer_pool_size = 50%+ system memory •innodb_log_file_size = 512M •log-bin = 0 •innodb_support_xa = … -
Created Database running on SSD
We plan to record/read data as fast as 10 ms (that's milliseconds) to a database. Now, this database will be in a factory so there is gonna be a lot … -
Created Use a RAM engine for database: MySQL and MS SQL Server
I want to store my databases only on RAM. I see that in MySQL server I can choose the "MEMORY" engine and the table with be stored only in the … -
Replied To a Post in MySQL: Get current time with milliseconds
Intresting: Im running 5.5.35 on Ubuntu... Is 5.6.x stable? Ill upgrade to it if neccesary (as long as it doesnt mess anything up) -
Created MySQL: Get current time with milliseconds
Oldest question in the book. Google says: SELECT NOW()+ 0; And a bunch of other things like UNIX_TIMESTAMP() but doing a select on these, it only returns the seconds, not … -
Replied To a Post in Logging in while making a thread
Im surprised.... There a reason you are pushing social, non Daniweb signups? I would think you would like more people signing up to the site! Ive seen a lot of … -
Replied To a Post in Copyright at the bottom still says 2013
> That was the year Dani copyright the web site, not the current year. All coptright notices are like that. Are you kidding? You really thought Dani copyrighted the site … -
Created Copyright at the bottom still says 2013
Just a quick lookout: Still says 2013 at the bottom. -
Created Logging in while making a thread
Why is making a thread (typing it out allowed) and then if I forget to login, it takes me to another page making me lose the entire typing? Login should … -
Created Making a email form
Im trying to make a email form where people can visit our site and send us emails. Since I am not sure if I can add PHP code, lets stick …
The End.