This is a read-only copy of the MariaDB Knowledgebase generated on 2024-11-14. For the latest, interactive version please visit https://mariadb.com/kb/.

Created: 8 months, 1 week ago
Modified: 8 months, 1 week ago
Type: article
Status: active
License: CC BY-SA / Gnu FDL

Attachments

No attachments exist

Error 1393: Can not modify more than one base table through a join view

Error Code	SQLSTATE	Error	Description
1393	HY000	ER_VIEW_MULTIUPDATE	Can not modify more than one base table through a join view '%s.%s'

Possible Causes and Solutions

Possible Causes and Solutions

This article doesn't currently contain any content. You can help!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

↑ MariaDB Error Codes 1300 to 1399 ↑
Error 1300: Invalid character string
Error 1301: Result was larger than max_allowed_packet - truncated
Error 1302: Conflicting declarations
Error 1303: Can't create from within another stored routine
Error 1304: already exists
Error 1305: does not exist
Error 1306: Failed to DROP
Error 1307: Failed to CREATE
Error 1308: with no matching label
Error 1309: Redefining label
Error 1310: End-label without match
Error 1311: Referring to uninitialized variable
Error 1312: PROCEDURE can't return a result set in the given context
Error 1313: RETURN is only allowed in a FUNCTION
Error 1314: is not allowed in stored procedures
Error 1315: The update log is deprecated and replaced by the binary log
Error 1316: The update log is deprecated and replaced by the binary log; SET SQL_LOG_UPDATE has been translated to SET SQL_LOG_BIN
Error 1317: Query execution was interrupted
Error 1318: Incorrect number of arguments; expected, got
Error 1319: Undefined CONDITION
Error 1320: No RETURN found in FUNCTION
Error 1321: FUNCTION ended without RETURN
Error 1322: Cursor statement must be a SELECT
Error 1323: Cursor SELECT must not have INTO
Error 1324: Undefined CURSOR
Error 1325: Cursor is already open
Error 1326: Cursor is not open
Error 1327: Undeclared variable
Error 1328: Incorrect number of FETCH variables
Error 1329: No data - zero rows fetched, selected, or processed
Error 1330: Duplicate parameter
Error 1331: Duplicate variable
Error 1332: Duplicate condition
Error 1333: Duplicate cursor
Error 1334: Failed to ALTER
Error 1335: Subquery value not supported
Error 1336: is not allowed in stored function or trigger
Error 1337: Variable or condition declaration after cursor or handler declaration
Error 1338: Cursor declaration after handler declaration
Error 1339: Case not found for CASE statement
Error 1340: Configuration file is too big
Error 1341: Malformed file type header in file
Error 1342: Unexpected end of file while parsing comment
Error 1343: Error while parsing parameter
Error 1344: Unexpected end of file while skipping unknown parameter
Error 1345: EXPLAIN/SHOW can not be issued; lacking privileges for underlying table
Error 1346: File has unknown type in its header
Error 1347: '%s.%s' is not %s
Error 1348: Column is not updatable
Error 1349: View's SELECT contains a subquery in the FROM clause
Error 1350: View's SELECT contains clause
Error 1351: View's SELECT contains a variable or parameter
Error 1352: View's SELECT refers to a temporary table'
Error 1353: View's SELECT and view's field list have different column counts
Error 1354: View merge algorithm can't be used here for now
Error 1355: View being updated does not have complete key of underlying table in it
Error 1356: View references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them
Error 1357: Can't drop or alter from within another stored routine
Error 1358: GOTO is not allowed in a stored procedure handler
Error 1359: Trigger already exists
Error 1360: Trigger does not exist
Error 1361: Trigger's is view or temporary table
Error 1362: Updating of row is not allowed in trigger
Error 1363: There is no row in trigger
Error 1364: Field doesn't have a default value
Error 1365: Division by 0
Error 1366: Incorrect value for column at row
Error 1367: Illegal value found during parsing
Error 1368: CHECK OPTION on non-updatable view
Error 1369: CHECK OPTION failed
Error 1370: command denied to user for routine
Error 1371: Failed purging old relay logs
Error 1372: Password hash should be a %d-digit hexadecimal number
Error 1373: Target log not found in binlog index
Error 1374: I/O error reading log index file
Error 1375: Server configuration does not permit binlog purge
Error 1376: Failed on fseek()
Error 1377: Fatal error during log purge
Error 1378: A purgeable log is in use, will not purge
Error 1379: Unknown error during log purge
Error 1380: Failed initializing relay log position
Error 1381: You are not using binary logging
Error 1382: The syntax is reserved for purposes internal to the MariaDB server
Error 1383: WSAStartup Failed
Error 1384: Can't handle procedures with different groups yet
Error 1385: Select must have a group with this procedure
Error 1386: Can't use ORDER clause with this procedure
Error 1387: Binary logging and replication forbid changing the global server
Error 1388: Can't map file
Error 1389: Wrong magic in
Error 1390: Prepared statement contains too many placeholders
Error 1391: Key part length cannot be 0
Error 1392: View text checksum failed
Error 1393: Can not modify more than one base table through a join view
Error 1394: Can not insert into join view without fields list
Error 1395: Can not delete from join view
Error 1396: Operation failed for
Error 1397: XAER_NOTA: Unknown XID
Error 1398: XAER_INVAL: Invalid arguments (or unsupported command)
Error 1399: XAER_RMFAIL: The command cannot be executed when global transaction is in the state

Error 1393: Can not modify more than one base table through a join view

Contents

Possible Causes and Solutions

Products

Services

Pricing

Resources

About Us

Download MariaDB