Tja Leute,
#1064 - 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 '= 0' at line 1
Das ist mein problem.... hier ist das Script welches ich einauen möchte:
EDIT: Komplette SQL Abfrage mit der es Funktioniert...besteht nur noch das Problem mit Fehler #1227
SQL
- DELIMITER $$
- --
- -- Procedures
- -- Edit arma3 and root to match a user in MySQL
- --
- CREATE DEFINER=`101207`@`localhost` PROCEDURE `resetLifeVehicles`()
- BEGIN
- UPDATE `vehicles` SET `active`= 0;
- END$$
- CREATE DEFINER=`101207`@`localhost` PROCEDURE `deleteDeadVehicles`()
- BEGIN
- DELETE FROM `vehicles` WHERE `alive` = 0;
- END$$
- CREATE DEFINER=`101207`@`localhost` PROCEDURE `deleteOldHouses`()
- BEGIN
- DELETE FROM `houses` WHERE `owned` = 0;
- END$$
- CREATE DEFINER=`101207`@`localhost` PROCEDURE `deleteOldGangs`()
- BEGIN
- DELETE FROM `gangs` WHERE `active` = 0;
- END$$
- DELIMITER ;
- /*
- Navicat MySQL Data Transfer
- Source Server : localhost
- Source Server Version : 50712
- Source Host : localhost:3306
- Source Database : testserver
- Target Server Type : MYSQL
- Target Server Version : 50712
- File Encoding : 65001
- Date: 2016-05-24 00:24:14
- */
- SET FOREIGN_KEY_CHECKS=0;
- -- ----------------------------
- -- Table structure for dynmarket
- -- ----------------------------
- DROP TABLE IF EXISTS `dynmarket`;
- CREATE TABLE `dynmarket` (
- `id` int(11) NOT NULL DEFAULT '1',
- `prices` text NOT NULL,
- PRIMARY KEY (`id`)
- ) ENGINE=InnoDB DEFAULT CHARSET=latin1;
- -- ----------------------------
- -- Records of dynmarket
- -- ----------------------------
- -- ----------------------------
- -- Table structure for gangs
- -- ----------------------------
- DROP TABLE IF EXISTS `gangs`;
- CREATE TABLE `gangs` (
- `id` int(11) NOT NULL AUTO
phpMyAdmin hat die Version: 4.4.15(ältere Version habe keinen schimmer wie man das Updatet)
Ist ein Altis Life Tabellen Code