MySQL Tables Help

[EightyVice]

Well , i didnt do any server with database before
what i know just how to connect
how to add values to columns and rows  and tables and so on and how get values from it
i didnt find that on wiki or i didnt understand the wikis :v
Thanks

[Xmair]

Learn SQL.

[Mötley]

It takes patience, Your answers wont just jump out in front of you with a snap of a finger.

Hear is some really old documentation that I really find useful http://www.tizag.com/sqlTutorial/
And also don't just forcibly switch how you store data, Your going to end up with a F'D up script possibly, Do your homework/studies first

[EightyVice]

It takes patience, Your answers wont just jump out in front of you with a snap of a finger.

Hear is some really old documentation that I really find useful http://www.tizag.com/sqlTutorial/
And also don't just forcibly switch how you store data, Your going to end up with a F'D up script possibly, Do your homework/studies first

Thanks but what i want is how to add value to SQL database by squrriel

[Mötley]

Your best bet is to study SQL, Once you understand SQL you will be able to imply it to squirrel yourself.

http://www.tizag.com/sqlTutorial/sqlinsert.php

There is so much to help you there, Once you read and understand feel free to ask for coding help

But until then we can not do your accounts for you

All of this is documented learning material on that site

SQL Tutorial
SQL - Introduction
SQL - Databases
SQL - Tables
SQL - Queries
SQL - Select
SQL - Where
SQL - As
SQL - Operators
SQL - Create
SQL - Insert
SQL - And / Or
SQL - Between
SQL - Order By
SQL - Update
SQL - Alter
SQL - Distinct
SQL - Subqueries
SQL - Join
SQL - In
SQL - Case
SQL - Group By
SQL - Views
SQL - Dates
SQL - Datepart
SQL - Dateadd
SQL - Delete
SQL - Union
SQL - Syntax
SQL - Data Types
SQL - Expressions
Conceptual SQL
SQL - History
SQL - Platforms
SQL - Commands
SQL - Structure
SQL - Predicates
SQL - Identifiers
Get Help!
SQL Forum

[EightyVice]

Your best bet is to study SQL, Once you understand SQL you will be able to imply it to squirrel yourself.

http://www.tizag.com/sqlTutorial/sqlinsert.php

There is so much to help you there, Once you read and understand feel free to ask for coding help

But until then we can not do your accounts for you

All of this is documented learning material on that site

SQL Tutorial
SQL - Introduction
SQL - Databases
SQL - Tables
SQL - Queries
SQL - Select
SQL - Where
SQL - As
SQL - Operators
SQL - Create
SQL - Insert
SQL - And / Or
SQL - Between
SQL - Order By
SQL - Update
SQL - Alter
SQL - Distinct
SQL - Subqueries
SQL - Join
SQL - In
SQL - Case
SQL - Group By
SQL - Views
SQL - Dates
SQL - Datepart
SQL - Dateadd
SQL - Delete
SQL - Union
SQL - Syntax
SQL - Data Types
SQL - Expressions
Conceptual SQL
SQL - History
SQL - Platforms
SQL - Commands
SQL - Structure
SQL - Predicates
SQL - Identifiers
Get Help!
SQL Forum

i know SQL but i dont know how to use it in Squrriel in vcmp , there is not any select * from and so on

[Xmair]

The function is

Code Select Expand

QuerySQL( yourDB, query );

[KAKAN]

i know SQL but i dont know how to use it in Squrriel in vcmp , there is not any select * from and so on

Dafuq you talking about?

[EightyVice]

i know SQL but i dont know how to use it in Squrriel in vcmp , there is not any select * from and so on

Dafuq you talking about?

let me explain it for you :v
if we have db with name Name and the username is user and password is pass and there is a table called players and a column for kills stats
how can i get the value from it and set the value? :v

[EK.IceFlake]

i know SQL but i dont know how to use it in Squrriel in vcmp , there is not any select * from and so on

Dafuq you talking about?

let me explain it for you :v
if we have db with name Name and the username is user and password is pass and there is a table called players and a column for kills stats
how can i get the value from it and set the value? :v

By doing transactions on it

[KAKAN]

i know SQL but i dont know how to use it in Squrriel in vcmp , there is not any select * from and so on

Dafuq you talking about?

let me explain it for you :v
if we have db with name Name and the username is user and password is pass and there is a table called players and a column for kills stats
how can i get the value from it and set the value? :v

I don't know what's so hard to not understand in the "wiki"
mysql_connect( "localhost", "user", "pass", "name" ); will establish the connection.
this is the code:-

Code Select Expand

myDB <- mysql_connect( "localhost", "user", "pass", "name" );
local data, query = mysql_query( myDB, "SELECT * FROM Players");
while( data = mysql_fetch_assoc( query ) )
 print( data["Kills"] ); //or whatever
mysql_free_result( query ); //cause you sux.
mysql_query( myDB, "UPDATE Players SET Kills=-1 WHERE Name='Zeyad_Ahmed' );
I simply do not use SQL much, so, it might be wrong.

[Mötley]

@Zeyad Ahmed, Firstly I haven't had time to play with these accounts. So don't expect anything pretty.

But once I call upon the class, The values from the database will transfer to my class. That's it...

pretty sure thats what you are talking about

Sorry I could go into this better, But I feel strange explaining it

Code Select Expand

class Registration
{
     Name = null; // The players name
     Password = null; //The players password

     Joins = 0; // Amount of times the player joined the server, Login count
     PreviousData = false; // Logged

     /* A bool if the player is admin, if admin after login, It will call for the admin class as well admin db */
     Admin = null;

     constructor(player, PassDB)
     {
       /* Store the players name */
       
       Name = player.Name;

       local query = ::QuerySQL( PassDB, "SELECT * FROM Passwords WHERE Name='" +  Name + "'" );
       
       /* Set da playa as a Guest */
       player.Name = "Guest[" + player.ID + "]"; //Player is a guest
       
       Password = ::GetSQLColumnData( query, 1 );
       Joins = ::GetSQLColumnData( query, 2 );
       
        /* Even though we set the bool, it doesnt do a check/class set until the player has logged in */
        Admin = ::GetSQLColumnData( query, 3 );

       ::FreeSQLQuery( query );
     }


[EightyVice]

Thanks KAKAN and TurboGrafx
That what i needed :v