I'm trying to build a filter function with several dependencys but when i add an AND to the SQL query, it seems like no results were found but if i'm searching with the queries before and after the AND, the…
I want to return rows where certain fields follow a particular pattern such as whether a particular character in a string is a letter or number. To test it out, I want to return fields where the first letter is…
Currently, I have this time stamp from shopify api (2018-12-16T17:36:29+11:00) that I need to store in a datetime field in mysql. 1st question: What exactly 2018-12-16T17:36:29+11:00 means? date: 2018-12-16, time: 17:36:29, timezone: +11:00????? 2nd question: If I want to store…
So I tried to make these following two tables with phpmyadmin. create table category ( catId int identity(1,1), catName varchar(20), Constraint pk_category PRIMARY KEY(catId)) create table subcategory ( subCatId INT IDENTITY(1,1), catId INT, subCatName VARCHAR(20), CONSTRAINT pk_subcategory PRIMARY KEY(catId,subCatId), CONSTRAINT…
I'm trying to spin up a container on my raspberry pi 3. The container has a MySQL server that is giving me some trouble when I try to spin up. $ docker-compose up > /dev/null & $ Building mysql ERROR:…
I have a web based applications that runs on tomcat5 mysql and using JVM and java etc... it works fine but everytime it starts getting up to around 300MB of memory for the java.exe (windows server ) it will crash…
I need to automate a couple things for my website, one of them being having the database cleared at midnight every night. I looked at cron job tutorials and came up with a script <?php $con = mysqli_connect("localhost", "root", "password",…
I've read my logfiles into R, and when I look at the referer there are some strange entries: > logs <- read.table("logfile") > referer <- data.frame(table(logs$referer)) > head(referer, 2) Var1 Freq 1 157 2 - 250290 Apache uses a dash…
I have a problem. My web site very slowly I think it's mysql. Max user connection instant 100 users. 30-40 people in most cases. My server : Intel Xeon E3-1230v3 16 GB DDR3 Ram 240 GB OCZ SSD Disk Centos…
I have a php website on localhost, and it always worked fine, but now it just shows old css files and old js files. When I edit the files and refresh the page nothing changes. especially the css layout file…