SQL lower() on one side of WHERE statement works for part of result but not all?

MySQL
I will happily take an edit on the title - I have no clue what to call this. Basically, I'm looking for an explanation to something I just came across...
3 years ago

what is wrong with this query? I am trying to update a column value based on the value of a column in a second table

MySQL
So I am trying to update the value of column Proveedor_Logo in table Natan_Procesos with the value of column Proveedor_Logo in table Natan_Proveedor w...
3 years ago

Insert ArrayList into MySQL

MySQL
I trying to insert ArrayList into MySQL, but I only gets the last values in column selected_seats. The variable list holds value 2 and 3. When I check...
3 years ago

Multiple aggregations in a single SQL statement

MySQL
I have an SQL table with roughly the following structure: id | datetime | value --------------------- What I would like is get a results with the f...
2 years ago

Need to connect database mysql from shell script (linux centos7)

MySQL
#!/bin/bash date +'%F %T' echo "Show Database" mysql -u [user] -p[password] -e 'SHOW DATABASES,USE eventime,SELECT * FROM dt;' output : 2016-09-22 ...
2 years ago

How to show value in php prepared statements

MySQL
I have the following query and I want to print the "total" I want to print the total like I print "num_rows" How can I do that ? $stmt = $conn-&gt...
2 years ago

PhPMyAdmin Error #1064; Syntax Error

MySQL
I'm trying to put together a MySQL database for a forum, And when I try to make a section table I keep encountering a problem #1064 - You have an ...
2 years ago

EF Code First Mysql to SQL Server

MySQL
I have an MVC 5 application that I first configured to use Mysql but now would like it to use SQL Server. My app uses code first and migrations in or...
2 years ago

Concurrent database creation

MySQL
My web app requires some initial database scripts to be executed during installation. These are just some CREATE TABLE scripts that need to be run. I'...
2 years ago

Adding multiple rows mysql in phpmyadmin

MySQL
I'm trying to execute a rather complicated task in phpmyadmin. Shortly i need to add multiple rows in a table that uses a certain value from another t...
2 years ago

MySqli - average each rows

MySQL
I have this table: +----+---------+----+----+----+ | ID | ID_USER | Q1 | Q2 | Q3 | +----+---------+----+----+----+ | 1 | 31 | 3 | 4 | ...
2 years ago

error: Unable to cast object of type 'System.Int64' to type 'System.Data.Odbc.OdbcDataReader'

MySQL
I'm trying to count records on my saved datas. Here is my code: Dim pl_qry As String Dim pl_cmd As New Odbc.OdbcCommand Dim pl_dr As Odbc...
2 years ago

calling a function from php class

MySQL
i have witten this php class, but i have problem using it, <?php class cs_mysql{ protected $configPath; protected $db; ...
2 years ago

How to write MySql select statment to get all defined settings or default settings not overidden for an id in one statement

MySQL
In a table myTable defined as: +----+---------+-----------+ | id | name | value | |----+---------+-----------+ | 7 | hand | right | ...
2 years ago

pymysql returns error if long query is used

MySQL
With the following code if I use a long query then I get an error. Is there a limit on the query size that I give? Sorry, but I can't share the exact...
2 years ago

MySQL: Can't create table (errno: 150)

MySQL
I am trying to import a .sql file and its failing on creating tables. Here's the query that fails: CREATE TABLE `data` ( `id` int(10) unsigned NOT N...
2 years ago

MYSQL - Order By Id In DESC Order, Group By X

MySQL
For the past 4 hours I've been laser focused on this one problem, in a nut shell, I want to order this table by id in DESC order, grouped by ads_post_...
2 years ago

password limitations in SQL Server and MySql

MySQL
Does MySql 5.1 and SQL Server 2008 (Web edition, Standard) have any functional password limitations other than length limits? Are metacharacters in an...
2 years ago

I have three tables. I want to have one table. ReDesign my table

MySQL
I got three tables: call_center_telephone - TABLE NAME id | sanal_gomdol | uilchilgee_lavlagaa | shine_serg_zahialga |.......| date 1 | 87 ...
2 years ago

MySQL output in PHP tables

MySQL
I am currently designing a product selection page. I wanna show my users a series of products that I have in my SQL table. I want to output my SQL i...
2 years ago