Global variables lua

global variables lua –[[ Global variables don’t need a declaration like “local.” Instead, you’d just write like this: ]]– variable = –value –[[ Note, you don’t always have to even assign a value to a variable. You can use it for the first time and get a value of “nil” which you can update later. […]

Global variables lua Read More

Var in sql

var in sql One way of doing this is to use database variables create table testcalc ( id int(11) not null auto_increment, num1 int(11) default null, num2 int(11) default null, num3 int(11) default null, num4 int(11) default null, primary key(id) ); insert into testcalc values (default, 1, 2, 3, 4), (default, 5, 10, 15, 20); […]

Var in sql Read More

Unique key

unique key ALTER TABLE students ADD UNIQUE (S_Id) unique key CREATE TABLE students ( S_Id int NOT NULL, LastName varchar (255) NOT NULL, FirstName varchar (255), City varchar (255), UNIQUE (S_Id) )

Unique key Read More

Unable to start xampp mysql

unable to start xampp mysql 3 One of many reasons is xampp cannot start MySQL service by itself. Everything you need to do is run mySQL service manually. First, make sure that ‘mysqld.exe’ is not running, if have, end it. (go to Task Manager > Progresses Tab > right click ‘mysqld.exe’ > end task) Open […]

Unable to start xampp mysql Read More

Substring sql

sql server substring SELECT SUBSTRING(‘SQL Tutorial’, 1, 3) AS ExtractString; substring sql SELECT SUBSTRING(‘SQL Tutorial’, 4, (LENGTH(‘SQL Tutorial’)) AS LastCharactersString; //Result -> Tutorial grab part of a string sql SELECT     SUBSTRING(‘SQLTutorial.org’,         POSITION(‘.’ IN ‘SQLTutorial.org’)); grab part of a string sql SELECT SUBSTRING(‘SQLTutorial.org’);

Substring sql Read More