MySQL Help! - Printable Version

MySQL Help! - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: MySQL Help! (/showthread.php?tid=535719)

MySQL Help! - Jigsaw123 - 05.09.2014

Hey guys.. I've uploaded my coding on SQL, and it gave this error:

Код:

--
-- Temporary table structure for view `FamilyStats`
--

DROP TABLE IF EXISTS `FamilyStats`;
MySQL said: Documentation

#1109 - Unknown table 'FamilyStats' in information_schema

Re: MySQL Help! - BroZeus - 05.09.2014

Mind showing us your coding
PS. i think this is because you are trying to get or update something from 'FamilyStats' table after dropping it which isnt possible

Re: MySQL Help! - Jigsaw123 - 05.09.2014

Oh I uploaded another code.. It still gives this error:

Код:

SQL query:




-- ----------------------------
-- Table structure for `drivers`
-- ----------------------------
DROP TABLE IF EXISTS `drivers`;
MySQL said: Documentation

#1046 - No database selected

This is the coding:

Код:

/*
Navicat MySQL Data Transfer

Source Server         : MySQL
Source Server Version : xxxx
Source Host           : xxxx
Source Database       : nfsw

Target Server Type    : MYSQL
Target Server Version : xxxx
File Encoding         : xxxx

Date: 2013-09-04 22:13:43
*/

SET FOREIGN_KEY_CHECKS=0;

-- ----------------------------
-- Table structure for `drivers`
-- ----------------------------
DROP TABLE IF EXISTS `drivers`;
CREATE TABLE `drivers` (
  `drivername` varchar(32) NOT NULL default '',
  `money` int(11) NOT NULL default '150000',
  `vehiclesnum` smallint(1) NOT NULL default '0',
  `vehmodels` varchar(32) default NULL,
  `exp` int(11) default '0',
  `level` int(11) default '1',
  `actvehnum` smallint(1) default '0',
  `vehparams1` varchar(128) default '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-1',
  `vehparams2` varchar(128) default '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-1',
  `vehparams3` varchar(128) default '0|0|0|0|0|0|0|0|0|0|0|0|0|0|0|-1',
  `treasparams` varchar(16) default '1|0|0',
  `lastlogin` date default '0000-00-00',
  `bonuses` varchar(32) default '50|50|50',
  PRIMARY KEY  (`drivername`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of drivers
-- ----------------------------

-- ----------------------------
-- Table structure for `emails`
-- ----------------------------
DROP TABLE IF EXISTS `emails`;
CREATE TABLE `emails` (
  `email` varchar(128) NOT NULL default '',
  `password` varchar(128) NOT NULL default '',
  `driversnum` int(11) NOT NULL default '0',
  `drivers` varchar(128) NOT NULL default '',
  `used` smallint(5) NOT NULL default '1',
  PRIMARY KEY  (`email`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of emails
-- ----------------------------

Re: MySQL Help! - BroZeus - 05.09.2014

No problem in the code i ran them on php MyAdmin