Tagged Questions
0
votes
1answer
43 views
SQL error “#1118 - row size too large” on the first row of the table only
I ran into a problem using a mySQL database. I have some columns as type text but when I try to enter data into the first row I get the error code "#1118 - Row size too large. The maximum row size for ...
0
votes
1answer
40 views
MySQL UPDATE statement using a table created on the fly
I want to update a table, say Table 1 using a table that I create on the fly (saytemp). To achieve this I have the following query:
UPDATE Table1 SET COUNT = temp.ctemp FROM ( SELECT A, SUM(UNO) AS ...
0
votes
1answer
133 views
MySQL: Create multiple tables with one query
Can you list multiple table names in a MySQL CREATE TABLE query?
CREATE TABLE table1, table2, table3 LIKE table_template;
If so, can you do it with the IF NOT EXISTS clause?
CREATE TABLE IF NOT ...
0
votes
1answer
53 views
syntax error within php script sql statement [closed]
I am getting this error when I execute this script:
You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'table) ...
1
vote
1answer
233 views
declare keyword error mysql
This is the code I've written:
delimiter //
create procedure `update_pts`()
begin
set @ctr=1;
set @cnt=(select count(*) from participant);
declare cs1 cursor for select sap from participant;
open ...
1
vote
1answer
79 views
SQL query to get the syntax of an existing table
Is there any SQL query to get the syntax of an existing table in my MySql database?
Intent:
Iam in the early stages of working with databases and I am using the MySql workbench for creating tables ...
1
vote
1answer
158 views
MySql: #1221 - Incorrect usage of UNION and ORDER BY
I have the following query which is intended to retrieve the newest 3 comments for each post in an array of posts.
SELECT * FROM comment AS tbl WHERE sscm_id IN
(
SELECT sscm_id FROM comment AS t1 ...
7
votes
2answers
255 views
What is the purpose of the USING parameter in SQL?
Working with some code on a standard MySQL database, and I came across this statement:
SELECT * FROM foo LEFT JOIN bar USING ('bar_id') WHERE foo_id = 1
What's throwing me is: what is USING for, ...
2
votes
1answer
274 views
create trigger which inserts rows depending on enum values?
I'm quite new to triggers and I ran into general problems. I'd like to achieve this:
CREATE TABLE `searcharticles` (
`articleID` int(11) unsigned NOT NULL,
`ean` char(13) COLLATE utf8_unicode_ci ...
0
votes
2answers
3k views
MySQL Set UTC time as default timestamp
How do I set a timestamp column whose default value is the current UTC time?
MySQL uses UTC_TIMESTAMP() function for UTC timestamp:
mysql> SELECT UTC_TIMESTAMP();
+---------------------+
| ...
