Reputation
898
Top tag
Next privilege 1,000 Rep.
See votes, expandable usercard
Badges
4 16
Newest
 Caucus
Impact
~13k people reached

15h
awarded  Caucus
1d
reviewed No Action Needed Is it necessary for rownum = 1 with Query.createQuery().getSingleResult()?
Jul
24
comment Use “NOT IN” in the same table, Mysql
@Mihai CREATE TABLE AS creates a table just with same datatypes, nothing else. CREATE TABLE LIKE creates a table including primary key and foreign keys and indexes.
Jul
24
comment Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
@Masoud There is no ordered data in a relational database unless you specify it with ORDER BY!
Jul
24
answered Set in mySQL a predefined order for SELECT queries without using the ORDER BY clause
Jul
24
answered Use “NOT IN” in the same table, Mysql
Jul
17
reviewed Reviewed Avoid joining to the same table multiple times
Jul
17
comment Avoid joining to the same table multiple times
A few explaining words are always a good idea, just saying.
Jul
17
answered How to merge two large mysql tables into one with similar data keeping the latest record
Jul
13
answered Can I remove “/*!50100 PARTITION BY HASH…” to success with import?
Jul
13
comment Can I remove “/*!50100 PARTITION BY HASH…” to success with import?
Please post the whole code. The part which throws the error is missing.
Jul
13
comment How do I name a query table in mysql?
Name it the_2_out_of_5_columns_view_from_table_whatever. Always go for the name, that best describes its content!
Jul
2
comment How can I retrieve the column names of a table in mysql?
You have a database named information_schema. You can query this to get this information.
Jun
19
comment How to select max value faster from large size table
Execute create index idx_modelparam_ems_parameterid on modelparam_ems(ParameterID); if you haven't an index on it already and it will run almost lightning-fast.
Jun
12
comment Table1 ID is auto increment and i also want to store the information from table 2 against that auto generated ID
The second statement is not valid syntax. Have a look here: dev.mysql.com/doc/refman/5.0/en/update.html That aside, I have no idea what the problem is. There's no question in your post.
Jun
2
reviewed No Action Needed postgresql Insert into table B based on foreign key in table A, if exists in A else
Jun
2
reviewed No Action Needed Database design: handling time
Jun
1
comment Reclaim disk space after dropping table(innodb_file_per_table = ON), strange scenario
Have you by any chance enabled innodb_file_per_table after you created the table in question?
May
12
answered SQL SSIS syntax question
Apr
3
awarded  Yearling