How to SELECT by MAX(date)??
This is the table structure CREATE TABLE `reports` ( `report_id` int(11) NOT NULL auto_increment, `computer_id`...
How to SELECT by MAX(date)??
This is the table structure CREATE TABLE `reports` ( `report_id` int(11) NOT NULL auto_increment, `computer_id`...
How to SELECT by MAX(date)??
This is the table structure CREATE TABLE `reports` ( `report_id` int(11) NOT NULL auto_increment, `computer_id`...
mysql: how do i start auto increment from a specific point??
CREATE TABLE `batchinfo` ( `rowid` int(11) NOT NULL AUTO_INCREMENT, `datapath` mediumtext, `analysistime` varc...
Stock management database design?
I'm creating an Intranet for my company, and we want to have a stock management in it. We sell and rent alarm system...
MySQL: SyntaxError: Unexpected identifier?
I just installed MySQL on my computer and when I try to create a database from the MySQL shell, I get this error: M...
SQL keys, MUL vs PRI vs UNI?
What is the difference between MUL, PRI and UNI in MySQL? I'm working on a MySQL query, using the command: desc my...
How does we understand this float-point numbers (.1E0)?
It is about data types in mysql and floating-point values, but I don't understand that format. example: .1E0 I know ...
Error 1046 No database Selected, how to resolve??
Error SQL query: -- -- Database: `work` -- -- -------------------------------------------------------- -- -- Table...
ImportError: No module named 'MySQL'?
I have downloaded the Connector/Python for MySQL successfully. I used the following code in Python's shell to test m...
MySQL user DB does not have password columns - Installing MySQL on OSX?
I am trying to change MySql root password. What I have done is below. Install MySql-5.7.6 ~ .dmg(Community Server...
There can be only one auto column?
How do I correct the error from MySQL 'you can only have one auto increment column'. CREATE TABLE book ( id INT ...
How can I avoid getting this MySQL error Incorrect column specifier for column COLUMN NAME??
How can I avoid getting this MySQL error Incorrect column specifier for column topic_id ? MySQL Error... #1063 -...
Cannot issue data manipulation statements with executeQuery()?
In MySQL I have two tables, tableA and tableB. I am trying to execute two queries: executeQuery(query1) executeQu...
How to truncate a foreign key constrained table??
Why doesn't a TRUNCATE on mygroup work? Even though I have ON DELETE CASCADE SET I get: ERROR 1701 (42000): Cann...