how to select max of mixed string/int column?

MySQL
Lets say that I have a table which contains a column for invoice number, the data type is VARCHAR with mixed string/int values like: invoice_number *...
1 year ago

Disable autocommit in SQL Developer when using MySQL

MySQL
I'd like to connect to a MySQL server with Oracle SQL Developer, but with autocommit disabled. By default, all MySQL connections have autocommit enabl...
1 year ago

whats the right version for using either scope_identity() ,@@identity (),last_insert_id() in mysql

MySQL
im working on asp.net c# ,i tried all 3 of them but none worked , this is the sql error(You have an error in your SQL syntax; check the manual that co...
1 year ago

SQL values from two different tables

MySQL
Okay so I have two tables in one database. One is called accounts and one is called settings. Through one query I would like to fetch settings.positio...
1 year ago

search by date mysql

MySQL
I have a table named messages: date (format DATETIME) id text user_id(FK) and a table named users: id name how to get count of messages with ...
1 year ago

Error while using LAST() aggregate function in SQL

MySQL
Recently i started working on a project. In which i want to fetch the last record inserted in the database. Query is: SELECT c.lat, c.lng, LAST(v.co...
1 year ago

Sending content from my frontend to my PHP/MySQL-backend

MySQL
When I send my content from my frontend it successfully reaches my if (!empty)-statement but the table in my phpmyadmin/mysql-database does not reciev...
1 year ago

multiple entries from variable date range

MySQL
i have a form on page1 that has 4 inputs (Name, startdate, enddate, reason). i want to add an entry into MySQL for every day from the date range (sta...
1 year ago

Error in Inserting values into a database

MySQL
long_url = http://www.google.com , final_short_url = http://127.0.0.1:5000/b5 @app.route('/test',methods=['GET','POST']) def shortessturl(): ...
1 year ago

Interesting Query in MySQL with conditions

MySQL
Here is the question: Management wants to know which specific aircraft have always been assigned to the same hangar lot (each aircraft is assigned to...
1 year ago

Error: String or binary data would be truncated. The statement has been terminated. aspx

MySQL
i want to insert data into my tbl_Transaction_Master table. here is my database table tbl_Transaction_Master and my query for database insert comma...
1 year ago

Block is temporary so don't panic

MySQL
Block is temporary only so don't mind. Block is temporary only so don't mind. Block is temporary only so don't mind. Block is temporary only so don't ...
1 year ago

The ordering of indexes group

MySQL
I read somewhere there is a different between these two indexes groups: ADD KEY id_user (id_user,seen); ADD KEY id_user (seen,id_user); Well is th...
1 year ago

Add the table name as variable in PDO

MySQL
I know, that PDO won't let me use the "param system" on tables. My problem is, that I store all table names as variables / static variables in an obje...
1 year ago

Get info using table Joins with 2 MySQL tables and DISTINCT

MySQL
I have two tables: the 'bidders' and 'solditems' tables. The solditems table has 2 columns I need to use: buyerid and paidstatus. In the bidders tabl...
1 year ago

MYSQL Multiple tables left joins with conditions and duplicate tables

MySQL
I can't seem to produce a valid MySQL (version MySQL 5.6). I have the bellow SQL that works well but it returns records only when all conditions are s...
1 year ago

How to get 10 latest records from database

MySQL
How to display 10 latest jobs from database like this. Please click here to see image I have written following code so far not sure what to do next....
1 year ago

How to find the next record after a specified one in SQL?

MySQL
I'd like to use a single SQL query (in MySQL) to find the record which comes after one that I specify. I.e., if the table has: id, fruit -- ----- 1...
1 year ago

how to create inner query using criteria in hibernate?

MySQL
I have a query like: SELECT * FROM mars_india.leave_x_user WHERE user_id in (SELECT user_id FROM mars_india.user where vendor_id=16); I got the f...
1 year ago

CRON job on OPENSHIFT PaaS

MySQL
So I would like to periodically run a script in my application that Im running on openshift PaaS. I would like to periodically delete some entries fro...
1 year ago