MySQL

I have two tables named 'users' and 'sponsors' bellow - first one is 'users' and second one is 'sponsors'

I'm attempting to cleanup some code that was flagged as being vulnerable to SQL injectionAs such, I am converting a lot of raw SQL query strings over to ActiveRecord's methods

This question already has an answer here:

I have 2 types of records, ones that start with the Owners name, and others that start with the companies name

Let's assume that I have 5 tables

For years when I want my user to search some field in my database where he can type anything he wants I use an algorithm to break the words and search each word separetely

List the customer number, customer name, and sales rep that have the same rep number as customer number 282This will need to be a subquery and do not test for sales rep 35 explicitly

Upon compilation of a C# Application, I run into an error such as this:

I want to execute a 'CREATE PROCEDURE' command from PHPIs there a way to change the MySQL DELIMITER on a PHP connection? Of course I know how to do it in a console session, but I want to do it from PHP

Hi so I've started my Computer Science A Level this year and for the project I am required to implement a DBI already have reasonable knowledge in Java and how to use the LWJGL library

I am trying to connect to Server A (Ubuntu 1604) remotely from Server B (Ubuntu 16

I'm a student and I feel like I'm working on a bit too little information on this one

I have a little problem with getting the quickest way to work my PHP server (in making a game)

When I enter the vehicleID and Date, the records must be sorted by using both vehicle ID and Date, however it doesn't get sorted from the Date but only with the vehicleIDHow can I achieve this ?

I know in sql using IFNULL I can replace null valueBut i need this using laravel eloquent and also not use raw sql query in laravel eloquent

I would like to create a link within a while loop where the anchor link is a record from the query and the href passes a variable from the same query to another page so I only have to create one page that displays information based on the passed variable

Hi I am attempting to join two MySQL tablesThe tables are as follows:

I declared RDS variables correctly in myenv file, but I get error:

I'm using python 27 with pandas 0

I'm getting this error:

I have a MySQL table in which a column name is tags and type is VARCHARI'm inserting the data with comma separated: