All Questions
8 questions
1
vote
1
answer
5k
views
MySQL NEW keyword
I have what seems like a basic question, but I have been unable to find the answer. Does the NEW keyword in MySQL refer to what the row will look like after the given action is performed or does it ...
- 23
0
votes
1
answer
189
views
Python Coding in Blender
can someone help me solve this problem?
I'm using Blender 2.74 and Python 3.4 with the correct connector for MySQL. (By the way, I'm just a beginner in using Blender and Python.)
What I want is to ...
- 1
0
votes
2
answers
146
views
MySQL insert where not with conditional statement
Objective:
Using only MySQL, insert sku, tablename, slugs table when a sku & table name are not not already set. I've got multiple tables that can have the same sku, but they are not the same. ...
- 2,237
0
votes
1
answer
223
views
Formatting 11/16/2002 12:00:00 PM to date time stamp in MySQL
How do I change this format "11/16/2002 12:00:00 PM" to something that MySQL will understand without using PHP?
I've tried SELECT CONVERT('11/03/2002 02:45:33 PM', DATETIME) AS datetime; and I ...
- 2,237
0
votes
1
answer
253
views
how to get row when change in column data
I have following table
Id | Status | date
-------------------
1 | Onsite |2007
2 | Onsite |2008
3 | Onsite |2009
4 | Abroad |2010
5 | Abroad |2011
6 | Onsite |2012
7 | Abroad |2013
8 ...
- 836
2
votes
1
answer
7k
views
MySQL Show Grants for... is different than mysql.db and information_schema.schema_privileges
I have discovered a difference between show grants for user@host and the mysql.db table. Why is this?
How can I resolve this? We are worried about security.
I ran a show grants against users in ...
- 118
1
vote
3
answers
165
views
Error in SQL Syntax (MYSQL 5.0)
Does anybody know what is wrong in this MYSQL 5.0 syntax?
CREATE TABLE IF NOT EXISTS target (
_id int(11) NOT NULL AUTO_INCREMENT,
time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
map_id int(...
- 679
3
votes
2
answers
1k
views
Proper syntax for MySQL 5.0.x FEDERATED table creation?
So I'm trying to create a federated table using the syntax from the docs. Following this, I've created a table like so:
CREATE TABLE `federated_table` (
`table_uid` int(10) unsigned not null ...
- 2,257