sql Archives - Page 40 of 45

Table: UserId, Value, Date. I want to get the UserId, Value for the max(Date) for each UserId. That is, the Value for each ...

Is there a way to restrict certain tables from the mysqldump command? For example, I’d use the following syntax to dump only table1 ...

table1 (id, name) table2 (id, name) Query: SELECT name FROM table2 -- that are not in table1 already 15 s 15 SELECT t1.name ...

I didn’t see any similar questions asked on this topic, and I had to research this for something I’m working on right now. ...

I have a table which I want to get the latest entry for each group. Here’s the table: DocumentStatusLogs Table |ID| DocumentID | ...

Assume a table structure of MyTable(KEY, datafield1, datafield2...). Often I want to either update an existing record, or insert a new record if ...

In postgres, how do I change an existing user to be a superuser? I don’t want to delete the existing user, for various ...

I am using SQL Server 2008 and Navicat. I need to rename a column in a table using SQL. ALTER TABLE table_name RENAME ...

What is the (default) charset for: MySQL database MySQL table MySQL column 15 s 15 Here’s how I’d do it – For Schemas ...

I have to update a field with a value which is returned by a join of 3 tables. Example: select im.itemid ,im.sku as ...