I have the need for a complex query.
I want to select all entries from table_1 where zones = 6 and cw = "city". See attached image table_1.jpg.
Then select all entries from table_2 where custnum…
I have loaded the basic MySQL data (i.e. data from the multiple tables using LEFT OUTER JOIN) into Tableview (VB.NET). Simultaneously, now I need to load the clubbed data (i.e. total…
I have setup a test LAMP site on VMware Workstation 12 using Centos 6. I found out I have a problem by trying to update a field and the update not being honored. Looking at the logs this is what it…
I have been attempting to create a simple function in phpMyAdmin for the better part of an hour now with absolutely no success. The function is simple, nothing more than a select from a table where a…
Here is my query, the explain result and the indexes are attached.
At the where the query is searching from a big table (CFV.VALUE=18809), To speed up the query I have added the VAL index to table …
I have a query that has worked fine for a long time, but our database had a recent influx of new entries. I'm now getting this warning.
Allowed memory size of 134217728 bytes exhausted (tried to …
Here's my SELECT:
select pymt.*, pgm.program,
payment pymt INNER JOIN programs pgm ON
(pgm.program='After School' or pgm.program='Camp')
I'm trying to do an inplace upgrade to my MySQL 5.5 instance on Windows 2008 R2 to 5.6 via these instructions https://dev.mysql.com/doc/refman/5.6/en/upgrading.html#upgrade-procedure-inplace . …
Mysql Server 5.7
I am able to backup a mysql database from the mysql server. It gets backed up to C:\mysql_backups\office.sql. I do this utilizing <cfexecute> …
Couls you point a way to make Codeigniter to consider the UTF-8 characters in config.php?
Thanks in advance!
<a href="showDetails.php">Show All User's Profile</a>
The MySQL Memory keeps getting into a cycle. It steadily increases and hits a max and then all of a sudden drops way back down only to repeat the cycle again. See the attached image showing 7 days of…
I've got an interview this morning and the potential employer describes the contract to my recruiter like this:
SQL injection remediation
Retrofit for existing web services
I have a similar Sql:
Select t.*, a.allquantity
left join(select productnumber,
when 0 then sum(quantity)
The MySQL log contains 1000s of statements like this:
“[Warning] Unsafe statement written to the binary log using statement format since BINLOG_FORMAT = STATEMENT. The statement is unsafe because …
I use php and mysql
I need to encrypt a letter, number combination like this LCKR242sdfasT and decrtpy it again.
I want to save the data encrypted on my server, when I need the …
I am trying to display images from BLOB type.
I tried tons of different ways and none of them work.
Look my function that displays my image:
And i tried to use the …
Could you point what's necessary to make PHPExceel to consider special characters when saving the sheets?
If I use the word: Leão in a where clause
... WHERE name LIKE …
I'm experiencing a sudden change in performance when updating records in my mysql databases. I do this through classic asp.
I have no problems when inserting records - only when …
I am able to create/restore a mysql database from an sql file using the cmd environment :
C:\DUMPS>"c:\Program Files\MySQL\MySQL Server 5.7\bin\mysql.exe" -u root -p office < …
I have records in the database written as:
I want to pull the records between these 11/28 and 11/30 but I only …
I have been looking to create my own online database, and started to add MySQL database to my hosting service accounts. (Plesk platform)
I can create basic database using their …
Could you point what is avoiding the PHPExcel library to fill the sheet?
The query produces data in MySQL
But Excel sheet is clean:
Thanks in …
I have a database called office on mysqlserver. I need to have a user friendly backup facility - ie the user can click a link and the backup will be created - ie office.sql and inserted into a …
Do we have any techniques or tools to convert ER to Activity diagram.
If so, how?