Could you point why this Codeigniter's data insertion is causing an error?
Thanks in advance!
The $params array:
The MySQL table structure where the data must …
is it possible to sort a data from a table according to which one is last date modified with sql ?
I mean I like the sort the rows from a table as date modified? like we sort it ASC, DESC
The DB server used is MySQL 5.7.16.
I have a program using MySQL .Net connector. I notice that i can read data into a dataset in using the dataadapter's Fill method.
However, if I call the f…
I'm planning a MySQL database that will hold a million drivers license numbers and I want to know the best way to find a particular license. Will MySQL be able to construct something better than star…
(CODE)I have read-only permission to a third-party SQL Server database. I need to manipulate the tables to create derived columns. To do this, I want to copy the tables to an existing MySQL database t…
I am having a tough time trying to figure out my first join. What I am trying to do is,
I have a table for service providers and in there is an ID number for their selected physical location. I ha…
I have this code to insert what was in my form to here, the data passes but it just doesnt add to my database, anyone know why?
This takes more than 10 minutes to execute:(CODE)Is there a faster way to accomplish the same way
I'm trying to move my WordPress site to a different server. I am moving it from a windows server 2008 iis 7.5 to a windows server 2012 iis 8.5. I've already installed WordPress and that worked fine. …
I use php and mysql database
I have a price table, which has price coloumn decimal(8,2),
when I select price from database, the output is like 1200.85
however I'd like to show it like 1,200.85 or 1…
is it possible to write an sql sentence like this?
SELECT * FROM product where type!='mobil' order by id ASC
can I use not equal for where clause?
I want to select all data …
Hi, I would like to create a test site. I found a hosting service that is providing me with an option that is within budget however they are only providing me with access to 25 "1 gigabyte MYSQL datab…
When I put
at the end of the below query I got a performance problem. As I understood from the EXPLAIN when the select sees the OR at the where section it goes over all t…
This is for an update function whereby the user can update certain aspects of their profile:
I have a database query that checks which categories have been selected when user initially chose them (…
I am on an AWS virtual server running Centos 6 and Mysql 5.5.2.
My log shows
It seems the buffer pool size is incorrect but when it tries to increase it an error occurs. Please help me…
I'm trying to figure out a query to count the IP field and tell me how many of the same IP there are in the table.
Then I need to delete the duplicates from the table and only leave 1 record for …
See attached, I have created this table.. I need to add the SAME columns again (to the SAME table) but with a "2" replacing the "1" in each case.
Is thee a way to do this other than the obvious bru…
Guys I have a problem with SqlConnection at this code and I cant find whats missing
so anyone help;
In my table i have several columns with the id as primary key.
I am using a query like select * from note where conversation_id in ('id1','id2',....'id300');
This is an extreme case where i wil…
In one of the mysql server when i run the query : select @@version;
The output is : 10.0.17-MariaDB-log
On other the output is :
What does these different mean ?
I am using these t…
I know this question seems abit counter intuitive but id like to work with the licensees I currently have, I have a MSSQL Enterprise 2008 and I currently have several Wordpress Sites using MySql, what…
I have some MYSQL code that looks like this:
Now i want to change this code into something like
But i cant get it to work. I do prefer to use SET because when i have many ro…
This program is supposed to upload an Excel Spreadsheet into a MySQL table in a MySQL database:
This program was cloned from another similar one, I'm NOT doing anything new here.
I need the total amount of times a piece of equipment was used in a assignment. Not sure if to use a count statement or group by.
I have two tables. On the first one I store all ads information. On the second table I store pictures path.
What I want to do is to select all data from the first table and select only one picture wh…